\u540c\u4e00\u53f0\u673a\u5668\u4e0a\u914d\u7f6eDataGuard
\n1. \u5b9e\u9a8c\u73af\u5883:
\n1. ip:192.168.10.11;
\n2. hostname:primary.snda.com;
\n2. \u8bbe\u7f6e~\/.bash_profile,$ORACLE_HOME\/network\/admin\/listener.ora\u548c$ORACLE_HOME\/network\/admin\/tnsnames.ora\u6587\u4ef6;
\n3. \u521b\u5efa\u5fc5\u8981\u7684\u76ee\u5f55;
\n4. \u4fee\u6539\u4e3b\u5e93\u7684\u7cfb\u7edf\u53c2\u6570,\u7136\u540e\u5173\u95ed\u6570\u636e\u5e93,\u542f\u52a8\u5230mount\u72b6\u6001,\u5e76\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f;
\n5. \u5728\u4e3b\u5e93\u4f7f\u7528spfile\u521b\u5efapfile:CREATE PFILE FROM SPFILE;
\n6. \u5907\u4efd\u4e3b\u5e93\u7684\u6570\u636e\u6587\u4ef6\u548c\u63a7\u5236\u6587\u4ef6;
\n7. \u62f7\u8d1d\u4e3b\u5e93\u7684\u6587\u4ef6\u5230\u5907\u5e93;
\n8. \u4fee\u6539\u5907\u5e93\u7684\u53c2\u6570\u6587\u4ef6;
\n9. \u8bbe\u7f6e\u5907\u5e93\u7684ORACLE_SID,\u5e76\u542f\u52a8\u5907\u5e93\u5230nomount\u72b6\u6001;
\n10. \u8bbe\u7f6e\u5907\u5e93\u7684ORACLE_SID, \u4f7f\u7528rman\u6062\u590d\u5907\u5e93;
\n11. \u4e3b\u5e93\u5907\u5e93\u5206\u522b\u6dfb\u52a0Standby Redo Log Fiels;
\n12. \u91cd\u542f\u5907\u5e93,\u5e76\u4f7f\u7528spfile\u542f\u52a8\u5230mount\u72b6\u6001,\u5e76\u8bbe\u7f6e\u5e94\u7528\u65e5\u5fd7\u6587\u4ef6;
\n13. \u4fee\u6539\u6570\u636e\u5e93\u95ee\u9ad8\u53ef\u7528\u6a21\u5f0f;
\n14. \u5207\u6362\u4e3b\u5e93\u5907\u5e93\u7684\u89d2\u8272;<\/p>\n
— ~\/.bash_profile\u6587\u4ef6\u5185\u5bb9;
\nORACLE_SID=PROD
\nORACLE_BASE=\/u01\/app\/oracle
\nORACLE_HOME=$ORACLE_BASE\/product\/10.2.0\/db_1
\nPATH=\/usr\/sbin:$PATH
\nPATH=$ORACLE_HOME\/bin:$PATH
\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib
\nCLASSPATH=$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib
\nexport ORACLE_BASE ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH CLASSPATH
\nalias sqlplus=’rlwrap sqlplus’
\nalias rman=’rlwrap rman’
\nalias dgmgrl=’rlwrap dgmgrl’<\/p>\n
— $ORACLE_HOME\/network\/admin\/listener.ora\u6587\u4ef6\u5185\u5bb9;
\nLISTENER=
\n(DESCRIPTION=
\n(ADDRESS_LIST=
\n(ADDRESS=(PROTOCOL=tcp)(HOST=primary.snda.com)(PORT=1521))
\n)
\n)
\nSID_LIST_LISTENER=
\n(SID_LIST=
\n(SID_DESC=
\n(SID_NAME=PROD)
\n(ORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0\/db_1)
\n)
\n(SID_DESC=
\n(SID_NAME=PRODDG)
\n(ORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0\/db_1)
\n)
\n)<\/p>\n
— $ORACLE_HOME\/network\/admin\/tnsnames.ora\u6587\u4ef6\u5185\u5bb9;
\nPROD_PRI=
\n(DESCRIPTION=
\n(ADDRESS=(PROTOCOL=tcp)(HOST=primary.snda.com)(PORT=1521))
\n(CONNECT_DATA=
\n(SERVICE_NAME=PROD)
\n(SERVER=DEDICATED)
\n)
\n)
\nPROD_SBY=
\n(DESCRIPTION=
\n(ADDRESS=(PROTOCOL=tcp)(HOST=primary.snda.com)(PORT=1521))
\n(CONNECT_DATA=
\n(SERVICE_NAME=PRODDG)
\n(SERVER=DEDICATED)
\n)
\n)<\/p>\n
— \u521b\u5efa\u5fc5\u8981\u7684\u76ee\u5f55;
\nmkdir -p \/u01\/app\/oracle\/oradata\/PRODDG\/
\nmkdir -p \/u01\/app\/oracle\/admin\/PRODDG\/adump
\nmkdir -p \/u01\/app\/oracle\/admin\/PRODDG\/bdump
\nmkdir -p \/u01\/app\/oracle\/admin\/PRODDG\/cdump
\nmkdir -p \/u01\/app\/oracle\/admin\/PRODDG\/udump
\nmkdir -p \/u01\/app\/oracle\/archivelog\/prod
\nmkdir -p \/u01\/app\/oracle\/archivelog\/proddg<\/p>\n
— \u4fee\u6539\u4e3b\u5e93\u7684\u7cfb\u7edf\u53c2\u6570,\u7136\u540e\u5173\u95ed\u6570\u636e\u5e93,\u542f\u52a8\u5230mount\u72b6\u6001,\u5e76\u4fee\u6539\u6570\u636e\u5e93\u4e3a\u5f52\u6863\u6a21\u5f0f;
\nALTER SYSTEM SET DB_UNIQUE_NAME=PROD_PRI SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_CONFIG=’DG_CONFIG=(PROD_PRI,PROD_SBY)’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_DEST_1=’LOCATION=\/u01\/app\/oracle\/archivelog\/prod VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD_PRI’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE=PROD_SBY LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD_SBY’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=’ENABLE’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=’ENABLE’ SCOPE=SPFILE;
\nALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=’EXCLUSIVE’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_ARCHIVE_FORMAT=’%t_%s_%r.arc’ SCOPE=SPFILE;
\nALTER SYSTEM SET FAL_SERVER=’PROD_PRI’ SCOPE=SPFILE;
\nALTER SYSTEM SET FAL_CLIENT=’PROD_SBY’ SCOPE=SPFILE;
\nALTER SYSTEM SET DB_FILE_NAME_CONVERT=’\/u01\/app\/oracle\/oradata\/PRODDG’,’\/u01\/app\/oracle\/oradata\/PROD’ SCOPE=SPFILE;
\nALTER SYSTEM SET LOG_FILE_NAME_CONVERT=’\/u01\/app\/oracle\/oradata\/PRODDG’,’\/u01\/app\/oracle\/oradata\/PROD’ SCOPE=SPFILE;
\nALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=’AUTO’ SCOPE=SPFILE;
\nSHUTDOWN IMMEDIATE;
\nSHUTDOWN MOUNT;
\nALTER DATABASE FORCE LOGGING;
\nALTER DATABASE ARCHIVELOG;
\nALTER DATABASE OPEN;
\nCREATE PFILE FROM SPFILE;<\/p>\n
— \u5907\u4efd\u4e3b\u5e93\u7684\u6570\u636e\u6587\u4ef6\u548c\u63a7\u5236\u6587\u4ef6;
\nrman target \/
\nBACKUP DATABASE FORMAT ‘\/u01\/app\/oracle\/flash_recovery_area\/%U’;
\nBACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT ‘\/u01\/app\/oracle\/flash_recovery_area\/%U’;<\/p>\n
— \u62f7\u8d1d\u4e3b\u5e93\u7684\u6587\u4ef6\u5230\u5907\u5e93;
\ncd $ORACLE_HOME\/dbs
\ncp initPROD.ora initPRODDG.ora
\norapwd file=orapwPRODDG password=oracle force=y<\/p>\n
— \u4fee\u6539\u5907\u5e93\u7684\u53c2\u6570\u6587\u4ef6
\n*.db_name=’PROD’
\n*.db_block_size=8192
\n*.db_unique_name=’PROD_SBY’
\n*.fal_client=’PROD_PRI’
\n*.fal_server=’PROD_SBY’
\n*.log_archive_config=’DG_CONFIG=(PROD_PRI,PROD_SBY)’
\n*.log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/archivelog\/proddg VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD_SBY’
\n*.log_archive_dest_2=’SERVICE=PROD_PRI LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD_PRI’
\n*.log_archive_dest_state_1=’ENABLE’
\n*.log_archive_dest_state_2=’ENABLE’
\n*.log_archive_format=’%t_%s_%r.arc’
\n*.sga_target=300M
\n*.pga_aggregate_target=150M
\n*.processes=150
\n*.compatible=’10.2.0′
\n*.remote_login_passwordfile=’EXCLUSIVE’
\n*.standby_file_management=’AUTO’
\n*.undo_management=’AUTO’
\n*.undo_tablespace=’UNDOTBS’
\n*.db_file_name_convert=’\/u01\/app\/oracle\/oradata\/PROD’,’\/u01\/app\/oracle\/oradata\/PRODDG’
\n*.log_file_name_convert=’u01\/app\/oracle\/oradata\/PROD’,’\/u01\/app\/oracle\/oradata\/PRODDG’
\n*.control_files=’\/u01\/app\/oracle\/oradata\/PRODDG\/control01.ctl’,’\/u01\/app\/oracle\/oradata\/PRODDG\/control02.ctl’<\/p>\n
— \u8bbe\u7f6e\u5907\u5e93\u7684ORACLE_SID,\u5e76\u542f\u52a8\u5907\u5e93\u5230nomount\u72b6\u6001;
\nORACLE_SID=PRODDG
\nsqlplus \/ as sysdba
\nSTARTUP NOMOUNT<\/p>\n
— \u8bbe\u7f6e\u5907\u5e93\u7684ORACLE_SID,\u4f7f\u7528rman\u6062\u590d\u5907\u5e93;
\nORACLE_SID=PRODDG
\nrman target sys\/oracle@prod_pri auxiliary \/
\nDUPLICATE TARGET DATABASE FOR STANDBY;<\/p>\n
— \u5206\u522b\u5728\u4e3b\u5e93\u548c\u5907\u5e93\u6dfb\u52a0Standby Redo Log files;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (‘\/u01\/app\/oracle\/oradata\/PROD\/redo04.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (‘\/u01\/app\/oracle\/oradata\/PROD\/redo05.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (‘\/u01\/app\/oracle\/oradata\/PROD\/redo06.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (‘\/u01\/app\/oracle\/oradata\/PROD\/redo07.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 4 (‘\/u01\/app\/oracle\/oradata\/PRODDG\/redo04.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 5 (‘\/u01\/app\/oracle\/oradata\/PRODDG\/redo05.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 6 (‘\/u01\/app\/oracle\/oradata\/PRODDG\/redo06.log’) SIZE 100M;
\nALTER DATABASE ADD STANDBY LOGFILE GROUP 7 (‘\/u01\/app\/oracle\/oradata\/PRODDG\/redo07.log’) SIZE 100M;<\/p>\n
— \u91cd\u542f\u5907\u5e93,\u5e76\u4f7f\u7528spfile\u542f\u52a8\u5230mount\u72b6\u6001,\u5e76\u8bbe\u7f6e\u5e94\u7528\u65e5\u5fd7\u6587\u4ef6;
\nshutdown immediate
\nCREATE SPFILE FROM PFILE;
\nstartup mount
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT SESSION;
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;<\/p>\n
— \u4fee\u6539\u6570\u636e\u5e93\u95ee\u9ad8\u53ef\u7528\u6a21\u5f0f,\u5728\u4e3b\u5e93\u8fd0\u884c;
\nALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY;
\nALTER SYSTEM SWITCH LOGFILE;<\/p>\n
— \u5207\u6362\u4e3b\u5e93\u5907\u5e93\u7684\u89d2\u8272;
\n1.\u5728\u4e3b\u5e93\u8fd0\u884c;
\nALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
\nshutdown immediate;
\nstartup mount;
\nALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
\n2.\u5728\u5907\u5e93\u8fd0\u884c;
\nALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
\nALTER DATABASE OPEN;
\nALTER SYSTEM SWITCH LOGFILE;<\/p>\n
SELECT PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE, SWITCHOVER_STATUS FROM v$database;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u540c\u4e00\u53f0\u673a\u5668\u4e0a\u914d\u7f6eDataGuard 1. \u5b9e\u9a8c\u73af\u5883: 1. ip:192.168.10.11; 2. host […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-1445","post","type-post","status-publish","format-standard","hentry","category-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1445"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1445\/revisions"}],"predecessor-version":[{"id":1446,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1445\/revisions\/1446"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1445"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}