Monitor Data Guard Log Shipping

最新推荐文章于 2024-02-07 22:09:49 发布

Honcho

最新推荐文章于 2024-02-07 22:09:49 发布

阅读量431

点赞数

分类专栏： Script 文章标签： database query

本文链接：https://blog.youkuaiyun.com/sweethouse1128/article/details/6886480

版权

Script 专栏收录该内容

3 篇文章

订阅专栏

本文提供了一段用于查询Oracle数据库归档日志状态的SQL脚本，通过该脚本可以获取数据库名称、主机名、已归档日志数量、已应用日志数量及最后应用时间等关键信息。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Note: This query needs to be run on the Primary database.

SET PAGESIZE 124
COL DB_NAME FORMAT A8
COL HOSTNAME FORMAT A12
COL LOG_ARCHIVED FORMAT 999999
COL LOG_APPLIED FORMAT 999999
COL LOG_GAP FORMAT 9999
COL APPLIED_TIME FORMAT A12
SELECT DB_NAME, HOSTNAME, LOG_ARCHIVED, LOG_APPLIED,APPLIED_TIME,
LOG_ARCHIVED-LOG_APPLIED LOG_GAP
FROM
(
SELECT NAME DB_NAME
FROM V$DATABASE
),
(
SELECT UPPER(SUBSTR(HOST_NAME,1,(DECODE(INSTR(HOST_NAME,'.'),0,LENGTH(HOST_NAME),
(INSTR(HOST_NAME,'.')-1))))) HOSTNAME
FROM V$INSTANCE
),
(
SELECT MAX(SEQUENCE#) LOG_ARCHIVED
FROM V$ARCHIVED_LOG WHERE DEST_ID=1 AND ARCHIVED='YES'
),
(
SELECT MAX(SEQUENCE#) LOG_APPLIED
FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED='YES'
),
(
SELECT TO_CHAR(MAX(COMPLETION_TIME),'DD-MON/HH24:MI') APPLIED_TIME
FROM V$ARCHIVED_LOG WHERE DEST_ID=2 AND APPLIED='YES'
);

DB_NAME HOSTNAME     LOG_ARCHIVED LOG_APPLIED APPLIED_TIME LOG_GAP
--------------   -----------------   -----------------------   -------------------- --------------------- --------------
PRIM            HONCHO         170                        170                     18-OCT/23:19      0