查看保护模式

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个日志

ITPub博客

Oracle DG 日常点检