\u4f7f\u7528RMAN\u548cBroker\u5feb\u901f\u642d\u5efaDataGuard\u73af\u5883
\n1. \u4e0d\u9002\u5408\u5728\u751f\u6210\u73af\u5883\u4e2d\u4f7f\u7528,\u5982\u679c\u751f\u6210\u73af\u5883\u4e2d\u642d\u5efadg\u7684\u8bdd\u63a8\u8350\u624b\u52a8\u914d\u7f6e;
\n2. \u5b9e\u9a8c\u73af\u5883:
\n1. \u4e3b\u5e93:
\n1. ip:192.168.10.11;
\n2. hostname:primary.snda.com;
\n2. \u5907\u5e93:
\n1. ip:192.168.10.12;
\n2. hostname:standby.snda.com;
\n3. \u5206\u522b\u8bbe\u7f6e\u4e3b\u5e93\u548c\u5907\u5e93\u7684~\/.bash_profile,$ORACLE_HOME\/network\/admin\/listener.ora\u548c$ORACLE_HOME\/network\/admin\/tnsnames.ora\u6587\u4ef6;
\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,\u5e76\u521b\u5efapfile;
\n5. \u5907\u4efd\u4e3b\u5e93\u7684\u6570\u636e\u6587\u4ef6\u548c\u63a7\u5236\u6587\u4ef6;
\n6. \u62f7\u8d1d\u4e3b\u5e93\u7684\u6587\u4ef6\u5230\u5907\u5e93;
\n7. \u4fee\u6539\u5907\u5e93\u7684pfile,\u521b\u5efaspfile,\u5e76\u542f\u52a8\u5230nomount\u72b6\u6001;
\n8. \u4f7f\u7528rman\u6062\u590d\u5907\u5e93;
\n9. \u4e3b\u5e93\u5907\u5e93\u5206\u522b\u6dfb\u52a0Standby Redo Log Fiels;
\n10. \u5206\u522b\u4fee\u6539\u4e3b\u5e93\u548c\u5907\u5e93\u7684\u521d\u59cb\u5316\u53c2\u6570:dg_broker_start;
\n11. \u5728\u4efb\u610f\u4e00\u53f0\u673a\u5668\u4e0a\u542f\u52a8dgmgrl,\u5e76\u914d\u7f6e\u5f53\u524d\u7684broker\u73af\u5883;
\n12. \u4fee\u6539\u6570\u636e\u5e93\u4e3a\u9ad8\u53ef\u7528\u6a21\u5f0f;
\n13. SWITCHOVER\u548cFAILOVER\u64cd\u4f5c;
\n14. \u5207\u6362\u6570\u636e\u5e93\u7684\u72b6\u6001\u4e3a\u53ea\u8bfb\u6a21\u5f0f\u548c\u5728\u7ebf\u63a5\u6536\u65e5\u5fd7\u72b6\u6001;<\/p>\n
— \u4e3b\u5e93\u548c\u5907\u5e93\u7684~\/.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<\/p>\n
alias sqlplus=’rlwrap sqlplus’
\nalias rman=’rlwrap rman’
\nalias dgmgrl=’rlwrap dgmgrl’<\/p>\n
— \u4e3b\u5e93\u7684$ORACLE_HOME\/network\/admin\/listener.ora\u6587\u4ef6\u5185\u5bb9,\u4fee\u6539\u5b8c\u6210\u540e\u8fd0\u884clsnrctl start\/reload\u91cd\u65b0\u52a0\u8f7d\u76d1\u542c\u6587\u4ef6;
\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=PROD)
\n(ORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0\/db_1)
\n(GLOBAL_DBNAME=PROD_PRI_DGMGRL)
\n)
\n)<\/p>\n
— \u5907\u5e93\u7684$ORACLE_HOME\/network\/admin\/listener.ora\u6587\u4ef6\u5185\u5bb9,\u4fee\u6539\u5b8c\u6210\u540e\u8fd0\u884clsnrctl start\/reload\u91cd\u65b0\u52a0\u8f7d\u76d1\u542c\u6587\u4ef6;
\nLISTENER=
\n(DESCRIPTION=
\n(ADDRESS_LIST=
\n(ADDRESS=(PROTOCOL=tcp)(HOST=standby.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=PROD)
\n(ORACLE_HOME=\/u01\/app\/oracle\/product\/10.2.0\/db_1)
\n(GLOBAL_DBNAME=PROD_SBY_DGMGRL)
\n)
\n)<\/p>\n
— \u4e3b\u5e93\u548c\u5907\u5e93\u7684$ORACLE_HOME\/network\/admin\/tnsnames.ora\u6587\u4ef6
\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)<\/p>\n
PROD_SBY=
\n(DESCRIPTION=
\n(ADDRESS=(PROTOCOL=tcp)(HOST=standby.snda.com)(PORT=1521))
\n(CONNECT_DATA=
\n(SERVICE_NAME=PROD)
\n(SERVER=DEDICATED)
\n)
\n)<\/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,\u5e76\u521b\u5efapfile;
\nALTER SYSTEM SET db_unique_name=PROD_PRI scope=spfile;
\nALTER SYSTEM SET db_recovery_file_dest_size=4G;
\nALTER SYSTEM SET db_recovery_file_dest=’\/u01\/app\/oracle\/flash_recovery_area’;
\nALTER SYSTEM SET log_archive_dest_1=’LOCATION=\/u01\/app\/oracle\/flash_recovery_area’;
\nALTER SYSTEM SET log_archive_dest_2=”;
\nALTER SYSTEM SET local_listener=”;
\nALTER SYSTEM SET dispatchers=”;
\nALTER SYSTEM SET standby_file_management=AUTO;<\/p>\n
SHUTDOWN IMMEDIATE;
\nSTARTUP MOUNT;
\nALTER DATABASE FORCE LOGGING;
\nALTER DATABASE ARCHIVELOG;
\n— ALTER DATABASE FLASHBACK ON;
\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;
\nscp \/u01\/app\/oracle\/flash_recovery_area\/* oracle@standby.snda.com:\/u01\/app\/oracle\/flash_recovery_area\/
\nscp $ORACLE_HOME\/dbs\/initPROD.ora oracle@standby.snda.com:$ORACLE_HOME\/dbs\/
\nscp $ORACLE_HOME\/dbs\/orapwPROD oracle@standby.snda.com:$ORACLE_HOME\/dbs\/<\/p>\n
— \u4fee\u6539\u5907\u5e93\u7684pfile,\u521b\u5efaspfile,\u5e76\u542f\u52a8\u5230nomount\u72b6\u6001;
\n\u4fee\u6539\u5907\u5e93\u7684\u53c2\u6570\u6587\u4ef6,\u53ea\u4fee\u6539db_unique_name=’PROD_SBY’\u5373\u53ef;
\nCREATE SPFILE FROM PFILE;
\nSTARTUP NOMOUNT;<\/p>\n
— \u4f7f\u7528rman\u6062\u590d\u5907\u5e93;
\nrman target sys\/oracle@prod_pri auxiliary \/
\nDUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK;<\/p>\n
— \u4e3b\u5e93\u5907\u5e93\u5206\u522b\u6dfb\u52a0Standby Redo Log Fiels;
\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;<\/p>\n
— \u5206\u522b\u4fee\u6539\u4e3b\u5e93\u5907\u5e93\u7684\u521d\u59cb\u5316\u53c2\u6570;
\nALTER SYSTEM SET dg_broker_start=TRUE;<\/p>\n
— \u5728\u4efb\u610f\u4e00\u53f0\u673a\u5668\u4e0a\u542f\u52a8dgmgrl,\u5e76\u914d\u7f6e\u5f53\u524d\u7684broker\u73af\u5883;
\ndgmgrl sys\/oracle@prod_pri
\nCREATE CONFIGURATION DGCONFIG1 AS PRIMARY DATABASE IS PROD_PRI CONNECT IDENTIFIER IS PROD_PRI;
\nADD DATABASE PROD_SBY AS CONNECT IDENTIFIER IS PROD_SBY MAINTAINED AS PHYSICAL;
\nENABLE CONFIGURATION;
\nSHOW CONFIGURATION;<\/p>\n
— \u4fee\u6539\u6570\u636e\u5e93\u4e3a\u9ad8\u53ef\u7528\u7684\u4fdd\u62a4\u72b6\u6001;
\nEDIT DATABASE PROD_PRI SET PROPERTY LogXptMode=’Sync’;
\nEDIT DATABASE PROD_SBY SET PROPERTY LogXptMode=’Sync’;
\nEDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;<\/p>\n
— \u5207\u6362\u6570\u636e\u5e93\u7684\u4e3b\u5907\u89d2\u8272;
\nSWITCHOVER TO PROD_SBY;
\nSWITCHOVER TO PRDO_PRI;
\nSELECT PROTECTION_MODE, PROTECTION_LEVEL, DATABASE_ROLE, SWITCHOVER_STATUS FROM v$database;<\/p>\n
— FAILOVER\u64cd\u4f5c;
\nFAILOVER TO PROD_PRI;
\nFAILOVER TO PROD_SBY;<\/p>\n
— \u5207\u6362\u6570\u636e\u5e93\u7684\u72b6\u6001\u4e3a\u53ea\u8bfb\u6a21\u5f0f\u548c\u5728\u7ebf\u63a5\u6536\u65e5\u5fd7\u72b6\u6001;
\nEDIT DATABASE PROD_SBY SET STATE=’READ-ONLY’;
\nEDIT DATABASE PROD_SBY SET STATE=’ONLINE’;<\/p>\n
— \u8bbe\u7f6e\u6570\u636e\u5e93\u7684\u5176\u5b83\u5c5e\u6027;
\nEDIT DATABASE db SET PROPERTY StandbyFileManagement=’AUTO’;
\nEDIT DATABASE db SET PROPERTY StandbyArchiveLocation=’\/u01\/app\/oracle\/flash_recovery_area’;<\/p>\n
— \u5220\u9664\u8868\u7a7a\u95f4\u548c\u8868\u7a7a\u95f4\u6240\u6709\u7684\u5185\u5bb9;
\nDROP TABLESPACE tbs INCLUDE CONTENTS CASCADE CONTRAINTS;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4f7f\u7528RMAN\u548cBroker\u5feb\u901f\u642d\u5efaDataGuard\u73af\u5883 1. \u4e0d\u9002\u5408\u5728\u751f\u6210\u73af\u5883\u4e2d\u4f7f\u7528,\u5982\u679c\u751f\u6210\u73af\u5883\u4e2d\u642d\u5efadg […]<\/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":[34],"class_list":["post-1441","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1441","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=1441"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1441\/revisions"}],"predecessor-version":[{"id":1442,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/1441\/revisions\/1442"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1441"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1441"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1441"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}