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