# standby 节点检查状态
SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;
# primary 节点 shutdown abort方式人工模拟primary奔溃。
SQL> shutdown abort
# standby 节点
SQL> shutdown immediate
SQL> startup mount;
SQL> alter system flush redo to 'zzdb';
SQL> alter database commit to switchover to primary;
alter database commit to switchover to primary
*
ERROR at line 1:
ORA-16139: media recovery required
SQL> recover managed standby database disconnect from session;
--查看gap，如果没有发现明显的gap现象，说明此次的failover不会有数据损失情况。
SQL> select thread#, low_sequence#, high_sequence# from v$archive_gap;
--停止redo应用
SQL> alter database recover managed standby database cancel;
--完成redo应用
SQL> alter database recover managed standby database finish;
SQL> alter database commit to switchover to primary;
SQL> alter database open;
Database altered.
SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;
DB_UNIQUE_NAME DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL OPEN_MODE SWITCHOVER_STATUS
-------------------- ------------------------------ ---------------------------------------- ---------------------------------------- -------------------- ------------------------------
ZZDB_DG PRIMARY MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE READ WRITE RESOLVABLE GAP
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /oracle/archive
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1

ITPub博客

ora11_node_dg（3）ADG做failover切换（主库宕机，从库升为主库过程）

最新文章