DG日常檢查命令

--1、主、備庫檢視當前日誌狀況

SELECT SEQUENCE#,STATUS FROM V$LOG;

 

--2、備庫檢視RFS接收日誌和MRP應用日誌同步主庫情況

 

SELECT PROCESS, SEQUENCE#, STATUS, DELAY_MINS FROM V$MANAGED_STANDBY;

 

--3、檢視備庫是否和主庫同步

SELECT SEQUENCE#,STATUS FROM V$LOG;

SELECT ARCHIVED_THREAD#,ARCHIVED_SEQ#,APPLIED_THREAD#,APPLIED_SEQ# FROM V$ARCHIVE_DEST_STATUS;

 

--4、備庫檢視已經歸檔的REDO

 

SELECT REGISTRAR,CREATOR,THREAD#,APPLIED,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE#, COMPLETION_TIME FROM V$ARCHIVED_LOG;

 

--5、備庫檢視已經應用的REDO

 

SELECT THREAD#,SEQUENCE#,FIRST_CHANGE#,NEXT_CHANGE# FROM V$LOG_HISTORY;

 

--6、主、備庫檢視是否有GAP

 

SELECT STATUS,GAP_STATUS FROM V$ARCHIVE_DEST_STATUS WHERE DEST_ID=2;

 

--7、備庫檢視GAP

SELECT * FROM V$ARCHIVE_GAP;

 

--8、主備庫查詢異常資訊

SELECT T.STATUS,T.ERROR FROM V$ARCHIVE_DEST T;