Oracle DG 日常點檢

檢視保護模式

select open_mode,protection_mode from gv$database;

查詢主庫dest是否報錯(主)

col dest_name for a30

col error for a20

select dest_name,status,error,target,process from v$archive_dest where substr(dest_name,-1) in (1,2);

檢視同步狀態。（備）

需要有in memory

select thread#,max(sequence#),applied from v$archived_log group by thread#,applied;

檢視程式

select process,status,thread#,sequence# from v$managed_standby;

取消日誌應用

alter database recover managed standby database cancel;

設定日誌應用

#alter database recover managed standby database disconnect from session;

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

alter database recover managed standby database cancel;

注意主庫表空間擴容，最好切2個日誌