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.
V$RECOVERY_PROGRESS
is a subview of V$SESSION_LONGOPS
.
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:
Oracle Database Backup and Recovery User's Guide for more information about performing database recovery