V$RECOVER_FILE

Lists datafiles that need recovery. Join FILE# with v$datafile to see filenames.

Columns
   ___________________________
 
   FILE#
   ONLINE
   ONLINE_STATUS
   ERROR
   CHANGE#
   TIME

Related:

V$ARCHIVE 
V$ARCHIVED_LOG 
V$ARCHIVE_DEST 
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$DATAFILE 
V$DELETED_OBJECT 
V$RECOVERY_FILE_STATUS 
V$RECOVERY_LOG 
V$RECOVERY_PROGRESS 
V$RECOVERY_STATUS


© Copyright SS64.com 1999-2014
Some rights reserved