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

本站中文解释

Oracle视图V$RECOVERY_PROGRESS存储有关归档日志文件归档操作进度的信息。它在使用自动归档模式激活时由ARCH进程所创建。由Arch进程填充的代码称为一个快照。

每一次ARCH进程收集数据都会在V$RECOVERY_PROGRESS视图中插入一行信息,直到数据文件有足够的归档日志文件被归档。

使用自动归档模式激活时,可以使用V$RECOVERY_PROGRESS视图检查数据库归档转换的当前状态。V$RECOVERY_PROGRESS视图包括如下列:

– FILE# 当前正在归档的数据文件号
– THREAD# 对应每个数据文件有一个线程
– LOW_KBYTE 这个线程归档从数据文件起始开始的字节数
– HIGH_KBYTE 这个线程归档从数据文件结束的字节数
– LOW_SEQUENCE 线程归档的最小归档序列号
– HIGH_SEQUENCE 线程归档的最大归档序列号
– START_TIME 创建V$RECOVERY_PROGRESS视图的时间
– END_TIME 归档完毕的时间

官方英文解释

V$RECOVERY_PROGRESS can be used to track database recovery operations to ensure that they are not stalled, and also to estimate the time required to complete the operation in progress.

On non-coordinator instances, V$RECOVERY_PROGRESS is not populated.

On the coordinator instance (the instance where MRP0 was started to start recovery), V$RECOVERY_PROGRESS has the same set of rows as before, except the following rows in the ITEM column are always 0 (not used) with Multi-Instance Redo Apply:

  • Active Apply

  • Maximum Apply Rate

  • Apply Time per Log

  • Checkpoint Time per Log

  • Recovery ID

V$RECOVERY_PROGRESS is a subview of V$SESSION_LONGOPS.

Note:

This view is populated on the instance where the MRP0 process is started if recovery is running in Multi-Instance Redo Apply mode. Not all the columns will be populated.

Column Datatype Description

START_TIME

DATE

Start time of the recovery operation

TYPE

VARCHAR2(64)

Type of recovery operation being performed:

  • CRASH RECOVERY

  • INSTANCE RECOVERY

  • MEDIA RECOVERY

ITEM

VARCHAR2(32)

Item being measured.

When TYPE is CRASH RECOVERY or INSTANCE RECOVERY, the possible values are:

  • Log Files

  • Redo Blocks

When TYPE is MEDIA RECOVERY, the possible values are:

  • Active Apply Rate

  • Average Apply Rate

  • Maximum Apply Rate

  • Redo Applied

  • Log Files

  • Last Applied Redo

  • Active Time

  • Elapsed Time

  • Apply Time per Log

  • Checkpoint Time per Log

  • Standby Apply Lag

  • Recovery ID

UNITS

VARCHAR2(32)

The units of measurement for each item

SOFAR

NUMBER

Amount of work done so far

TOTAL

NUMBER

Total amount of work expected

TIMESTAMP

DATE

Timestamp of the last redo record applied

COMMENTS

VARCHAR2(248)

Miscellaneous notes; currently displays the SCN for the last applied redo

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

See Also:

  • “V$SESSION_LONGOPS”

  • “Background Processes” for more information about the MRP0 process

  • Oracle Database Backup and
    Recovery User’s Guide
    for more information about performing database recovery


数据运维技术 » Oracle 视图 V$RECOVERY_PROGRESS 官方解释,作用,如何使用详细说明