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;原創文章，作者：投稿專員，如若轉載，請註明出處：https://www.506064.com/zh-tw/n/280010.html
微信掃一掃 
支付寶掃一掃 
