oracle12cdg的搭建教程

1、acle12CDGacle12CDG的搭建教程：的搭建教程：RACRACRACRACRACRAC單機(jī)單機(jī)主庫上操作1.開啟RAC的fceloggingSQLalterdatabasefceloggingSQL2.修改RAC初始化參數(shù)文件SQLaltersystemsetlog_archive_config=DG_CONFIG=(eisooeisoos)SQLaltersystemsetlog_archive_dest_2=SERVICE

2、=eisoosASYNCVALID_F=(ONLINE_LOGFILESPRIMARY_ROLE)DB_UNIQUE_NAME=eisoosscope=spfileSQLaltersystemsetlog_archive_dest_state_1=ENABLESQLaltersystemsetlog_archive_dest_state_2=ENABLESQLaltersystemsetfal_server=eisoosSQLalter

3、systemsetdb_file_name_convert=eisooseisooscope=spfileSQLaltersystemsetdb_file_name_convert=dataadataeisoosDATAEISOODATAFILEscope=spfile如果備庫沒有使用asmSQLaltersystemsetlog_file_name_convert=eisooseisooscope=spfileSQLaltersyst

4、emsetlog_file_name_convert=dataadataeisoosDATAEISOOONLINELOGscope=spfile如果備庫沒有使用asmSQLaltersystemsetstby_file_management=AUTOSQLaltersystemsetlog_archive_max_processes=303.開啟歸檔模式srvctlstopdatabasedeisoosrvctlstartdatabas

5、edeisooieisooomountSQLshowparameterspfileNAMETYPEVALUEspfilestringDATAEISOOPARAMETERFILEspfile.281.923255053SQLcreatepfile=tmpiniteisoos.afromspfile=DATAEISOOPARAMETERFILEspfile.281.923255053[acle@rac1tmp]$scpiniteisoos.

6、a192.168.180.48:$ACLE_HOMEdbs備庫上操作：1.修改參數(shù)文件使用asm：.audit_file_dest=u01appacleadmineisoosadump.audit_trail=db.compatible=12.1.0.2.0.control_files=dataadataeisooscontrol01.ctl.db_block_size=8192.db_create_file_dest=dataadat

7、aeisoos.db_domain=.db_file_name_convert=eisooeisoos.db_name=eisoo.db_unique_name=eisoos.diagnostic_dest=u01appacle.dispatchers=(PROTOCOL=TCP)(SERVICE=eisoosXDB).fal_server=EISOOS.log_archive_config=DG_CONFIG=(eisooeisoos