Oracle 视图 V$RECOVERY_STATUS 官方解释,作用,如何使用详细说明
本站中文解释
(Oracle视图及用途)
V$RECOVERY_STATUS视图是一个内部视图,用于显示当前实例正在进行的恢复任务的状态。该视图中可以看到恢复任务的进度、待恢复的SCN等其他信息。
V$RECOVERY_STATUS视图可以用于查看当前正在进行数据库恢复的状态。用户可以使用该视图查看当前数据库正在进行的恢复任务的状态,如果正在进行数据库恢复,也可以看到相应的恢复状态。比如正在进行日志恢复的状态,恢复的SCN,用于恢复的日志空间,以及恢复所花费的时间等。
官方英文解释
V$RECOVERY_STATUS
contains statistics of the current recovery process. This view contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager can view the relevant information in this view. V$RECOVERY_STATUS
will be empty to all other Oracle users.
Column | Datatype | Description |
---|---|---|
|
|
Point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts. |
|
|
Number of the redo thread currently being processed |
|
|
Log sequence number of the log needed by the recovery process. The value is |
|
|
Low SCN of the log needed by recovery. The value is |
|
|
Time when the log was created. The value is midnight on 1/1/88 if the time is unknown or if no log is needed. |
|
|
Filename of the log |
|
|
Status of the previous log. Contains one of the following values: |
|
|
Reason recovery is returning control to the user ( |
|
|
The ID of the container to which the data pertains. Possible values include:
|
See Also:
Oracle Database Backup and
Recovery User’s Guide