V$RECOVERY_STATUS

Columns
   ___________________________
 
   SCN_NEEDED
   SEQUENCE_NEEDED
   THREAD
   TIME_NEEDED
   PREVIOUS_LOG_NAME
   PREVIOUS_LOG_STATUS
   REASON
   RECOVERY_CHECKPOINT

Related Commands: