V$RECOVERY_STATUS

Columns
   ___________________________
 
   RECOVERY_CHECKPOINT
   THREAD
   SEQUENCE_NEEDED
   SCN_NEEDED
   TIME_NEEDED
   PREVIOUS_LOG_NAME
   PREVIOUS_LOG_STATUS
   REASON

Related:

V$ARCHIVE 
V$ARCHIVED_LOG 
V$ARCHIVE_DEST 
V$ARCHIVE_PROCESSES 
V$BACKUP 
V$BACKUP_ASYNC_IO 
V$BACKUP_CORRUPTION 
V$BACKUP_DATAFILE 
V$BACKUP_DEVICE 
V$BACKUP_PIECE 
V$BACKUP_REDOLOG 
V$BACKUP_SET 
V$DELETED_OBJECT 
V$RECOVERY_FILE_STATUS 
V$RECOVERY_LOG 
V$RECOVERY_PROGRESS
V$RECOVER_FILE