dataguard 健康检查-凯发app官方网站

--主库
select sysdate,status,error from gv$archive_dest_status where type='physical' and status!='valid' or error is not null;
select file#, name, unrecoverable_change#, unrecoverable_time from v$datafile where unrecoverable_time > (sysdate - 1);
select sysdate,database_mode,recovery_mode, gap_status from v$archive_dest_status where type='physical' and gap_status !='no gap';
select * from v$dataguard_status where severity in ('error','fatal') and timestamp > (sysdate -1);
select sysdate,protection_mode, synchronized, synchronization_status from v$archive_dest_status where type='physical' and synchronization_status !='ok';
--备库
select name,value,time_computed,datum_time from v$dataguard_stats where name='transport lag' and value > ' 00 00:01:00';
select name,value,time_computed,datum_time from v$dataguard_stats where name='apply lag' and value > ' 00 00:01:00';
select * from v$datafile_header where status ='offline' or error is not null;
select * from v$managed_standby where process like 'mrp%'; --唯一一个期望有结果的
select * from v$dataguard_status where severity in ('error','fatal') and timestamp > (sysdate -1);

阅读(1373) | 评论(0) | 转发(0) |

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们