#主機(jī)重啟過程
#關(guān)閉順序：1:先關(guān)閉主庫,? ?2:暫停備庫redo應(yīng)用,? ? 3:后關(guān)閉備庫
#啟動順序：1:先啟動備庫,? ?2:后啟動主庫,? ? ? ? ? ? ? ? ?3:啟動備庫redo應(yīng)用
#具體步驟如下
#關(guān)閉順序
#1:關(guān)閉主庫
[oracle@DB196 ~]$ sqlplus / as sysdba
SQL> SHUTDOWN IMMEDIATE;
SQL> exit
[oracle@DB196 ~]$?lsnrctl stop
[oracle@DB196 ~]$ systemctl poweroff -i
2:暫停備庫redo應(yīng)用
[oracle@DB197 ~]$?sqlplus / as sysdba
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
3:后關(guān)閉備庫
SQL> SHUTDOWN IMMEDIATE;
SQL> exit
[oracle@DB197 ~]$?lsnrctl stop
[oracle@DB197?~]$?systemctl poweroff -i
#啟動順序：
1:先啟動備庫
[oracle@DB197 ~]$ lsnrctl start
[oracle@DB197 ~]$ sqlplus / as sysdba
SQL> STARTUP
2:后啟動主庫
[oracle@DB196 ~]$?lsnrctl start
[oracle@DB196?~]$?sqlplus / as sysdba
SQL>?STARTUP
3:啟動備庫應(yīng)用
[oracle@DB197?~]$?sqlplus / as sysdba
#開啟實(shí)時日誌應(yīng)用
SQL> alter database recover managed standby database using current logfile disconnect from session;
#check,查看歸檔是否及時應(yīng)用 （備庫）
SQL> SELECT sequence#,applied FROM v$archived_log;
#如果發(fā)現(xiàn)全部都是YES，證明歸檔日志已經(jīng)在同步
