oracle數據庫怎么使用（分享oracle數據庫應用指南)

oracle數據庫切換DG步驟

備注：應用服務要先停止對外服務

1.先將主庫切換成備庫，然后將原主庫啟動到物理庫的狀態

SQL> Alter database commit to switchover to physical standby with session shutdown;

2.關閉主庫

SQL> shutdown immediate;

3.打開數據庫nomount

SQL> startup nomount;

4.更改主庫為備庫

SQL> alter database mount standby database;
SQL> alter database recover managed standby database disconnect from session;

如果配置了 standby redo log 并需要啟用實時同步則執行以下代碼

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

5.將備庫切換成主庫

SQL> select switchover_status from v$database;
SQL> select * from v$version where rownum<2;
SQL> alter database commit to switchover to primary with session shutdown;

如果備庫還有未應用的日志則執行

SQL>alter database recover managed standby database disconnect from session;
SQL> shutdown immediate;
SQL> startup;

切換日志進行檢查

SQL> select max(sequence#) from v$log;
SQL>select sequence#,applied from v$archived_log;
SQL> alter system switch logfile;