../E40402-16.epub /> ../E40402-16.mobi />

V$RECOVER_FILE

V$RECOVER_FILE displays the status of files needing media recovery.

Column Datatype Description
FILE# NUMBER File identifier number
ONLINE VARCHAR2(7) This column is obsolete and maintained for backward compatibility. The value of this column is always equal to the value in ONLINE_STATUS.
ONLINE_STATUS VARCHAR2(7) Online status (ONLINE, OFFLINE)
ERROR VARCHAR2(18) Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed
CHANGE# NUMBER SCN where recovery must start
TIME DATE Time of SCN when recovery must start