ora11_node_dg（3）ADG做failover切換（主庫當機，從庫升為主庫過程）

fjzcau發表於2015-12-31
AI

  1. # standby 節點檢查狀態

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

  5. # primary 節點 shutdown abort方式人工模擬primary奔潰。

  7. SQL> shutdown abort


  10. # standby 節點
  11. SQL> shutdown immediate
  12. SQL> startup mount;

  14. SQL> alter system flush redo to 'zzdb';

  16. SQL> alter database commit to switchover to primary;
  17. alter database commit to switchover to primary
  18. *
  19. ERROR at line 1:
  20. ORA-16139: media recovery required

  22. SQL> recover managed standby database disconnect from session;

  24. --檢視gap，如果沒有發現明顯的gap現象，說明此次的failover不會有資料損失情況。
  25. SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;

  27. --停止redo應用
  28. SQL> alter database recover managed standby database cancel;

  30. --完成redo應用
  31. SQL> alter database recover managed standby database finish;

  33. SQL> alter database commit to switchover to primary;

  35. SQL> alter database open;

  37. Database altered.

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

  41. DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL OPEN_MODE SWITCHOVER_STATUS
  42. -------------------- ------------------------------ ---------------------------------------- ---------------------------------------- -------------------- ------------------------------
  43. ZZDB_DG PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE READ WRITE RESOLVABLE GAP

  45. SQL> archive log list;
  46. Database log mode Archive Mode
  47. Automatic archival Enabled
  48. Archive destination /oracle/archive
  49. Oldest online log sequence 1
  50. Next log sequence to archive 1
  51. Current log sequence 1

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

相關文章