Dynamic Performance (V$) Views, 118 of 179
This view displays the status of files needing media recovery.
FILE#
NUMBER
File identifier number
ONLINE
VARCHAR2
Online status: ONLINE, OFFLINE
ERROR
Why the file needs to be recovered: NULL if reason unknown, or OFFLINE NORMAL if recovery not needed
CHANGE#
SCN where recovery must start
TIME
DATE
Time of SCN when recovery must start