Oracle教程

Oracle 视图 V$LOGSTDBY_PROGRESS 官方解释，作用，如何使用详细说明

本站中文解释

V$LOGSTDBY_PROGRESS视图显示Streams应用程序当前进度百分比和其他参数，用于展示日志传播的进度。

1. 使用V$LOGSTDBY_PROGRESS视图：

假设您正在使用Oracle Streams来建立和维护一个数据库standby，那么您可以使用此视图来跟进复制和应用过程的进度。

例如，您可以使用以下查询检查standby实例是否已经准备就绪：

SELECT PROCESS, PARAMETER, TOTAL_AMOUNT, PROGRESS, NEWEST_TIME
FROM V$LOGSTDBY_PROGRESS
WHERE PROCESS IN (‘Analzye’,’Apply’,’Replicate’)
AND PARAMETER IN (‘REDO_LOGFILES’,’REDO_CHANGES’);

上述查询可以更好地展示分析，应用和复制过程的进度，以便您可以更有效地监控日志同步复制过程。

官方英文解释

V$LOGSTDBY_PROGRESS displays the progress of log apply services on the logical standby database. This view is for logical standby databases only.

Column Datatype Description

APPLIED_SCN

NUMBER

All the transactions with COMMIT SCN lower than or equal to this SCN have been applied

APPLIED_TIME

DATE

The time and date of APPLIED_SCN

RESTART_SCN

NUMBER

During an apply restart, LogMiner does not read any log file with a NEXT_CHANGE# lower than this SCN.

RESTART_TIME

DATE

The time and date of RESTART_SCN

LATEST_SCN

NUMBER

The highest SCN of all redo records that Logical Standby has encountered

LATEST_TIME

DATE

The time and date of LATEST_SCN

MINING_SCN

NUMBER

The SCN of the latest redo record processed by the builder process

MINING_TIME

DATE

The time and date of MINING_SCN

RESETLOGS_ID

NUMBER

A redo branch is identified by resetlogs SCN and resetlogs timestamp. The RESETLOGS_ID column contents are the same as resetlogs timestamp converted to a number.

CON_ID

NUMBER

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


数据运维技术 » Oracle 视图 V$LOGSTDBY_PROGRESS 官方解释，作用，如何使用详细说明
分享到：

相关推荐