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