-- 监视主数据库和备用数据库 ---
-- 动态性能视图(固定视图)---
-- 监控流程活动
SELECT PROCESS, CLIENT_PROCESS, SEQUENCE#, STATUS FROM V$MANAGED_STANDBY;
-- 确定重做申请的进度
SELECT ARCHIVED_THREAD#, ARCHIVED_SEQ#, APPLIED_THREAD#, APPLIED_SEQ#
FROM V$ARCHIVE_DEST_STATUS;
-- 确定存档重做日志文件的位置和创建者
SELECT NAME, CREATOR, SEQUENCE#, APPLIED, COMPLETION_TIME
FROM V$ARCHIVED_LOG;
-- 在OPEN RESETLOGS之前和之后查看数据库化身
SELECT INCARNATION#, RESETLOGS_ID, STATUS FROM V$DATABASE_INCARNATION ;
SELECT RESETLOGS_ID,THREAD#,SEQUENCE#,STATUS,ARCHIVED FROM V$ARCHIVED_LOG
ORDER BY RESETLOGS_ID,SEQUENCE# ;
-- 查看存档的重做日志历史记录
SELECT FIRST_TIME, FIRST_CHANGE#, NEXT_CHANGE#, SEQUENCE# FROM V$LOG_HISTORY;
-- 确定哪些日志文件应用于备用数据库
SELECT THREAD#, MAX(SEQUENCE#) AS "LAST_APPLIED_LOG"
FROM V$LOG_HISTORY
GROUP BY THREAD#;
SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG;
-- 确定备用站点未收到哪些日志文件
-- (结果包含恢复数据库时的归档文件,可查询已应用于备库数据库的日志文件,,如果已被应用,则可忽略。)
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#);