RECOVERY_CHECKPOINT
|
DATE
|
The point in time to which the recovery has occurred. If no logs have been applied, this is the point in time the recovery starts.
|
THREAD
|
NUMBER
|
The number of the redo thread currently being processed
|
SEQUENCE_NEEDED
|
NUMBER
|
Log sequence number of the log needed by the recovery process. The value is 0 if no log is needed.
|
SCN_NEEDED
|
VARCHAR2(16)
|
The low SCN of the log needed by recovery. The value is 0 if unknown or no log is needed.
|
TIME_NEEDED
|
DATE
|
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.
|
PREVIOUS_LOG_NAME
|
VARCHAR2(257)
|
The filename of the log
|
PREVIOUS_LOG_STATUS
|
VARCHAR2(13)
|
The status of the previous log. Contains one of the following values: RELEASE; WRONG NAME; MISSING NAME; UNNEEDED NAME; NONE
|
REASON
|
VARCHAR2(13)
|
The reason recovery is returning control to the user (NEED LOG|LOG REUSED|THREAD DISABLED )
|