ora11_node_dg（2）ADG做(switchover)切換測試

fjzcau發表於2015-12-31

  1. # primary節點

  3. --切換為standby
  4. SQL> alter database commit to switchover to physical standby;

  6. SQL> shutdown immediate;

  8. SQL> startup;

  10. --開啟redo應用
  11. SQL> alter database recover managed standby database using current logfile disconnect from session;

  13. SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;


  16. # standby 節點

  18. --切換為primary
  19. SQL> alter database commit to switchover to primary;

  21. SQL> shutdown immediate

  23. SQL> startup
  24. SQL> alter system switch logfile;

  26. SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;

  28. 升為主庫後，SWITCHOVER_STATUS 狀態依次為：
  29. 1）RESOLVABLE GAP
  30. 2）TO STANDBY
  31. 3）SESSIONS ACTIVE


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

相關文章