1、监控恢复进度
1.1、查看进程的活动状态
SELECT PROCESS,CLIENT_PROCESS,SEQUENCE#,STATUS FROM V$MANAGED_STANDBY;
PROCESS CLIENT_P SEQUENCE# STATUS
--------- -------- ---------- ------------
ARCH ARCH 0 CONNECTED
ARCH ARCH 0 CONNECTED
Elapsed: 00:00:00.02
CLIENT_PROCESS 对应 Primary 数据库中的进程如 ARCH\LGWR等
SEQUENCE#:归档序号
STATUS 当前进程状态:
CONNECTED :已连接至 PRIMARY 数据库
ALLOCATED: 正在准备连接PRIMARY数据库
ATTACHED:正在连接PRIMARY数据库
IDLE:空闲中
RECEIVING:正在接收归档文件
OPENNING :正在处理归档文件
CLOSING: 归档文件已处理完,收尾中
WRITING: 正在向归档文件中写入redo数据
WAIT_FOR_LOG :正在等待新的REDO数据
WAIT_FOR_GAP:归档发生中断,正在等待新的REDO 数据
APPLYING_LOG:正在应用REDO数据
1.2 查看REDO应用进度
SELECT DEST_NAME,ARCHIVED_THREAD#,ARCHIVED_SEQ#,APPLIED_THREAD#,APPLIED_SEQ#,DB_UNIQUE_NAME,STATUS FROM V$ARCHIVE_DEST_STATUS
--WHERE STATUS='VALID'
DEST_NAME ARCHIVED_THREAD# ARCHIVED_SEQ# APPLIED_THREAD# APPLIED_SEQ# DB_UNIQUE_NAME STATUS
------------------------- ---------------- ------------- --------------- ------------ ------------------------------ ---------
LOG_ARCHIVE_DEST_1 0 0 0 0 cuuo VALID
LOG_ARCHIVE_DEST_2 0 0 0 0 cuug VALID
LOG_ARCHIVE_DEST_3 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_4 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_5 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_6 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_7 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_8 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_9 0 0 0 0 NONE INACTIVE
LOG_ARCHIVE_DEST_10 0 0 0 0 NONE INACTIVE
STANDBY_ARCHIVE_DEST 0 0 0 0 NONE VALID
11 rows selected.
1.3 查看归档文件的路径及创建信息
15:24:30 > SELECT NAME,CREATOR,THREAD#,SEQUENCE#,APPLIED,ARCHIVED,COMPLETION_TIME FROM V$ARCHIVED_LOG;
NAME CREATOR THREAD# SEQUENCE# APP ARC COMPLETIO
---------------------------------------- ------- ---------- ---------- --- --- ---------
/u01/app/Oracle/oradata/cuuo/arch1_91_78 ARCH 1 91 YES YES 04-JUL-12
7689201.dbf
/u01/app/oracle/oradata/cuuo/arch1_92_78 LGWR 1 92 YES YES 04-JUL-12
7689201.dbf
/u01/app/oracle/oradata/cuuo/arch1_93_78 LGWR 1 93 YES YES 04-JUL-12
7689201.dbf
/u01/app/oracle/oradata/cuuo/arch1_94_78 LGWR 1 94 YES YES 04-JUL-12
7689201.dbf
1.4 查看归档历史
SELECT FIRST_TIME,FIRST_CHANGE#,NEXT_CHANGE#,SEQUENCE# FROM V$LOG_HISTORY;
1.5 查看物理STANDBY数据库未接收的日志文件
SELECT LOCAL.THREAD#,LOCAL.SEQUENCE# FROM
(SELECT THREAD#,SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=1) LOCAL
WHERE LOCAL.SEQUENCE# NOT IN
(SELECT SEQUENCE# FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND THREAD# = LOCAL.THREAD#);
----从primary 数据库获取