8.159 V$RECOVERY_PROGRESS
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 of the recovery operation |
|
|
|
Type of recovery operation being performed:
|
|
|
|
Item being measured. When TYPE is CRASH RECOVERY or INSTANCE RECOVERY, the possible values are:
When TYPE is MEDIA RECOVERY, the possible values are:
|
|
|
|
The units of measurement for each item |
|
|
|
Amount of work done so far |
|
|
|
Total amount of work expected |
|
|
|
Timestamp of the last redo record applied |
|
|
|
Miscellaneous notes; currently displays the SCN for the last applied redo |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
-
"Background Processes" for more information about the MRP0 process
-
Oracle Database Backup and Recovery User’s Guide for more information about performing database recovery