Data Guard 检查二
检查dataguard是否与备用数据库同步。
select thread#,max(sequence#) from v$archived_log where applied=‘YES’ group by thread#;
MRP 进程检查
select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby
停止MRP进程
alter database recover managed standby database cancel;
应该看不到了
启动MRP进程
alter database recover managed standby database disconnect from session;
select process,status,client_process,thread#,sequence#,block#,blocks,delay_mins from v$managed_standby;
查看已应用的归档日志
SELECT SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;
查看报错
select message, to_char(timestamp,‘HH:MI:SS’) timestamp
from v$dataguard_status
where severity in (‘Error’,‘Fatal’)
order by timestamp;
select dest_name,status,error from v$archive_dest where status=‘ERROR’;
SELECT MESSAGE FROM V$DATAGUARD_STATUS;