ora11_node_dg（4）主庫當機後，從庫升為主庫，重新搭建DG

fjzcau發表於2015-12-31

主庫當機後，從庫切換為主庫，重新搭建DG過程如下，


  1.
  2. 1、修改primary端初始化引數檔案 （不用修改，目前就是這樣的配置）

  4. alter system set log_archive_config = 'DG_CONFIG=(zzdb,zzdb_dg)' scope=both;
  5. alter system set log_archive_dest_1 = 'LOCATION=/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=zzdb_dg' scope=both;
  6. alter system set log_archive_dest_2 = 'SERVICE=zzdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=zzdb' scope=both;
  7. alter system set log_archive_dest_state_1 = enable;
  8. alter system set log_archive_dest_state_2 = enable;
  9. alter system set fal_server=zzdb scope=both;
  10. alter system set fal_client=zzdb_dg scope=both;
  11. alter system set standby_file_management=AUTO scope=both;
  12. alter system set db_file_name_convert='/oracle/product/oradata/zzdb','/oracle/product/oradata/zzdb' scope=spfile;
  13. alter system set log_file_name_convert='/oracle/product/oradata/zzdb','/oracle/product/oradata/zzdb' scope=spfile;


  16. 2、現primary端pfile引數檔案和密碼檔案，並且複製到standby節點（原primary節點）段相應位置

  18. SQL> create pfile from spfile;
  19. cd $ORACLE_HOME/dbs
  20. scp initzzdb.ora orapwzzdb ora11-node1:$ORACLE_HOME/dbs
  21. cd $ORACLE_BASE
  22. scp -r admin/ diag/ ora11-node1:$ORACLE_BASE


  25. 3、修改standby（原primary節點）的監聽檔案及初始化引數檔案

  27. --複製現primary節點的監聽檔案
  28.   
  29. --啟動監聽
  30. [oracle@ora11-node1 dbs]$ lsnrctl start


  33. --修改引數檔案
  34. [oracle@ora11-node1 ~]$ sqlplus / as sysdba
  35. SQL> startup nomount;
  36. SQL> create spfile from pfile='$ORACLE_HOME/dbs/initzzdb.ora';
  37. SQL> shutdown abort;
  38. SQL> startup nomount;
  39. SQL>
  40. alter system set db_unique_name=zzdb scope=spfile;
  41. alter system set log_archive_config='DG_CONFIG=(zzdb,zzdb_dg)' scope=both;
  42. alter system set log_archive_dest_1 = 'LOCATION=/oracle/archive VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=zzdb' scope=spfile;
  43. alter system set log_archive_dest_2 = 'SERVICE=zzdb_dg LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=zzdb_dg' scope=spfile;
  44. alter system set fal_server=zzdb_dg scope=spfile;
  45. alter system set fal_client=zzdb scope=spfile;

  47. SQL> shutdown abort;
  48. SQL> startup nomount;


  51. 4、在primary端透過Rman建立備庫,在 ora11-node2 上執行如下命令

  53. #primary備份資料庫
  54. mkdir -p /oracle/db_backup
  55. rman target / <<!
  56. run {
  57.   CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
  58.   backup database format '/oracle/db_backup/%d_%s_%p_%t.%T';
  59. }
  60. !

  62. # primary生成備庫控制檔案
  63. rman target / <<!
  64. run {
  65.   allocate channel c1 device type disk format '/oracle/db_backup/CON_%U';
  66.   backup current controlfile for standby;
  67. }
  68. !

  70. # cp備份檔案和控制檔案到standby
  71. cd /oracle/db_backup
  72. scp * ora11-node1:/oracle/db_backup

  74. #standby節點，恢復控制檔案
  75. rman target / <<!
  76. run {
  77.   restore controlfile from '/oracle/db_backup/CON_0bqq71jt_1_1';
  78.   alter database mount;
  79. }
  80. !

  82. #standby節點，透過rman進行恢復
  83. rman target / <<!
  84.   CONFIGURE DEVICE TYPE DISK PARALLELISM 3;
  85.   restore database;
  86. !

  88. #至此已經恢復完成


  91. 5、在 standby 端 檢視standby日誌
  92. SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;

  94. 若沒有新增：

  96. SQL> alter database add standby logfile
  97. group 4 ('/oracle/product/oradata/zzdb/zzdb_dgredo04.log') size 50m,
  98. group 5 ('/oracle/product/oradata/zzdb/zzdb_dgredo05.log') size 50m,
  99. group 6 ('/oracle/product/oradata/zzdb/zzdb_dgredo06.log') size 50m,
  100. group 7 ('/oracle/product/oradata/zzdb/zzdb_dgredo07.log') size 50m;


  103. 6、在standby端開啟實時日誌應用

  105. SQL> alter database recover managed standby database using current logfile disconnect from session;

  107. recover managed standby database disconnect from session;

  109. startup;


來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/22661144/viewspace-1969263/，如需轉載，請註明出處，否則將追究法律責任。

相關文章