Oracle12CDG的搭建教程资料

Oracle12CDG的搭建教程：RAC-RAC/RAC-单机主库上操作1.开启RAC的forceloggingSQL>alterdatabaseforcelogging;SQL>2.修改RAC初始化参数文件SQL>altersystemsetlog_archive_config='DG_CONFIG=(eisoo,eisoos)';SQL>altersystemsetlog_archive_dest_2='SERVICE=eisoosASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoos'scope=spfile;SQL>altersystemsetlog_archive_dest_state_1=ENABLE;SQL>altersystemsetlog_archive_dest_state_2=ENABLE;SQL>altersystemsetfal_server=eisoos;SQL>altersystemsetdb_file_name_convert='eisoos','eisoo'scope=spfile;SQL>altersystemsetdb_file_name_convert='/data/oradata/eisoos','+DATA/EISOO/DATAFILE'scope=spfile;//如果备库没有使用asmSQL>altersystemsetlog_file_name_convert='eisoos','eisoo'scope=spfile;SQL>altersystemsetlog_file_name_convert='/data/oradata/eisoos','+DATA/EISOO/ONLINELOG'scope=spfile;//如果备库没有使用asmSQL>altersystemsetstandby_file_management='AUTO';SQL>altersystemsetlog_archive_max_processes=30;3.开启归档模式sr\t"/database/201807/_blank"vctlstopdatabase-deisoosrvctlstartdatabase-deisoo-ieisoo-omountSQL>alterdatabasearchivelog;SQL>alterdatabaseopen;4.创建standbylogfile;SQL>selectthread#,group#,bytes/1024/1024fromv$log;THREAD#GROUP#BYTES/1024/1024-----------------------------------1150125023502450SQL>alterdatabaseaddstandbylogfilethread1group10size50M;SQL>alterdatabaseaddstandbylogfilethread1group11size50M;SQL>alterdatabaseaddstandbylogfilethread1group12size50M;SQL>alterdatabaseaddstandbylogfilethread2group13size50M;SQL>alterdatabaseaddstandbylogfilethread2group14size50M;SQL>alterdatabaseaddstandbylogfilethread2group15size50M;SQL>selectthread#,group#,bytes/1024/1024fromv$standby_log;THREAD#GROUP#BYTES/1024/1024-----------------------------------1105011150112502135021450215505.创建备库参数文件棋牌评测网SQL>showparameterspfile;NAMETYPEVALUE-----------------------------------------------------------------------------spfilestring+DATA/EISOO/PARAMETERFILE/spfile.281.923255053SQL>createpfile='/tmp/initeisoos.ora'fromspfile='+DATA/EISOO/PARAMETERFILE/spfile.281.923255053';[oracle@rac1tmp]$scpiniteisoos.ora8:$ORACLE_HOME/dbs备库上操作：1.修改参数文件使用asm：*.audit_file_dest='/u01/app/oracle/admin/eisoos/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/data/oradata/eisoos/control01.ctl'*.db_block_size=8192*.db_create_file_dest='/data/oradata/eisoos'*.db_domain=''*.db_file_name_convert='eisoo','eisoos'*.db_name='eisoo'*.db_unique_name='eisoos'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=eisoosXDB)'*.fal_server='EISOOS'*.log_archive_config='DG_CONFIG=(eisoo,eisoos)'*.log_archive_dest_1='LOCATION=/data/oradata/eisoos/archivelog'*.log_archive_dest_2='SERVICE=eisooASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoo'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.arc'*.log_archive_max_processes=30*.log_file_name_convert='eisoo','eisoos'*.open_cursors=300*.pga_aggregate_target=453m*.processes=300*.remote_login_passwordfile='exclusive'*.sga_target=1361m*.standby_file_management='AUTO'eisoos.undo_tablespace='UNDOTBS1'单机未使用asm：*.audit_file_dest='/u01/app/oracle/admin/eisoos/adump'*.audit_trail='db'*.compatible='.0'*.control_files='/data/oradata/eisoos/control01.ctl'#RestoreControlfile*.db_block_size=8192*.db_create_file_dest='/data/oradata/eisoos'*.db_domain=''*.db_file_name_convert='+DATA/EISOO/DATAFILE','/data/oradata/eisoos','+DATA/EISOO/TEMPFILE','/data/oradata/eisoos'*.db_name='eisoo'*.db_unique_name='eisoos'*.diagnostic_dest='/u01/app/oracle'*.dispatchers='(PROTOCOL=TCP)(SERVICE=eisoosXDB)'*.fal_server='EISOOS'*.log_archive_config='DG_CONFIG=(eisoo,eisoos)'*.log_archive_dest_1='LOCATION=/data/oradata/eisoos/archivelog'*.log_archive_dest_2='SERVICE=eisooASYNCVALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=eisoo'*.log_archive_dest_state_1='ENABLE'*.log_archive_dest_state_2='ENABLE'*.log_archive_format='%t_%s_%r.arc'*.log_archive_max_processes=30*.log_file_name_convert='+DATA/EISOO/ONLINELOG','/data/oradata/eisoos'*.open_cursors=300*.pga_aggregate_target=453m*.processes=300*.remote_login_passwordfile='exclusive'*.sga_target=1361m*.standby_file_management='AUTO'eisoos.undo_tablespace='UNDOTBS1'2.启动到nomout状态SQL>startupnomountpfile='/u01/app/oracle/product/12.1.0/db_1/dbs/initeisoos.ora';ORACLEinstancestarted.TotalSystemGlobalArea1442840576bytesFixedSize2924448bytesVariableSize486539360bytesDatabaseBuffers939524096bytesRedoBuffers13852672bytesSQL>SQL>ALTERSYSTEMSETSEC_CASE_SENSITIVE_LOGON=false;备注：SEC_CASE_SENSITIVE_LOGON参数是决定密码文件是否可以在本地创建，否则只能从主库拷贝到备库。默认值是“true”。易火棋牌3.在本地创建密码文件ocrl:/u01/app/oracle/product/12.1.0/db_1/dbs@oracle1>orapwdfile=orapweisoospassword=oracleentries=10ignorecase=yforce=y4.配置监听文件，保证primary和standby能够互连备库:LISTENER=(DESCRIPTION_LIST=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1)(PORT=1521))(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))))SID_LIST_LISTENER=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=eisoos)(ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1)(SID_NAME=eisoos)))或者SID_LIST_LISTENER_EISOOS=(SID_LIST=(SID_DESC=(GLOBAL_DBNAME=eisoos)(ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1)(SID_NAME=eisoos)))主库和备库是tnsname.ora配置如下：eisoo=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=eisoo)))eisoos=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=1)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=eisoos)))主备分别验证：[oracle@rac1~]$sqlplussys/oracle@eisooassysdba[oracle@rac1~]$sqlplussys/oracle@eisoosassysdba[oracle@rac2~]$sqlplussys/oracle@eisooassysdba[oracle@rac2~]$sqlplussys/oracle@eisoosassysdba5.备份恢复数据eisoos:/home/oracle@oracle1>rmantargetsys/oracle@eisooauxiliarysys/oracle@eisoosRecoveryManager:Release.0-ProductiononMonSep2616:50:422016Copyright(c)1982,2014,

\t"/database/201807/_blank"Oracle

and/oritsaffiliates.Allrightsreserved.connectedtotargetdatabase:EISOO(DBID=3774196505)connectedtoauxiliarydatabase:EISOO(notmounted)RMAN>duplicatetargetdatabaseforstandbyfromactivedatabase;StartingDuplicateDbat2016/09/2616:52:126.开启实时同步SQL>alterdatabaserecovermanagedstandbydatabaseusingcurrentlogfiledisconnectfromsession;验证:1)SQL>selectdest_name,errorfromv$archive_dest;//通过查看archive_log_dest_2列是否有error报错，如果有报错，则需要先根据报错内容解决问题2)查询主库最大归档序号和备库最大归档序号selectmax(sequence#)fromv$archived_log;然后在主库切换日志：altersystemswitchlogfile;再次查询备库最大归档序号，一致即归档同步成功。主库：SQL>selectmax(sequence#)fromv$archived_log;MAX(SEQUENCE#)--------------133SQL>altersystemswitchlogfile;Systemaltered.SQL>selectmax(sequence#)fromv$archived_log;MAX(SEQUENCE#)--------------134SQL>备库：SQL>selectmax(sequence#)fromv$archived_log;MAX(SEQUENCE#)--------------134SQL>3)主库验证SQL>selectSEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED,ARCHIVEDfromV$ARCHIVED_LOG;备库验证SQL>selectSEQUENCE#,FIRST_TIME,NEXT_TIME,APPLIED,ARCHIVEDfromV$ARCHIVED_LOG;备注：观察主备库日志是否同步，如一致则表示日志CDP同步正常。主备切换1.检查DG是否同步是否正常主库：SQL>selectswitchover_status,database_rolefromgv$database;SWITCHOVER_STATUSDATABASE_ROLE------------------------------------TOSTANDBYPRIMARYTOSTANDBYPRIMARY备库:SQL>selectswitchover_status,database_rolefromgv$database;SWITCHOVER_STATUSDATABASE_ROLE------------------------------------NOTALLOWEDPHYSICALSTANDBY2.准备切换工作:关闭RAC库，并把rac1起到open状态[oracle@rac1~]$srvctlstopdatabase-deisoo[oracle@rac1~]$sqlplus/assysdbaSQL*Plus:Release.0ProductiononTueSep2709:12:252016Copyright(c)1982,2014,Oracle.Allrightsreserved.Connectedtoanidleinstance.SQL>startupORACLEinstancestarted.TotalS