Dynamic Performance (V$) Views, 147 of 237
This view displays the status of files needing media recovery.
FILE#
NUMBER
File identifier number
ONLINE
VARCHAR2(7)
This column is obsolete and maintained only for compatibility reasons. The value of this column is always equal to the value in ONLINE_STATUS.
ONLINE_STATUS
Online status (ONLINE, OFFLINE)
OFFLINE
ERROR
VARCHAR2(18)
Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed
OFFLINE NORMAL
CHANGE#
SCN where recovery must start
TIME
DATE
Time of SCN when recovery must start