V$RECOVERY_FILE_STATUS contains one row for each datafile for each RECOVER statement. This view contains useful information only for the Oracle process doing the recovery. When Recovery Manager directs a server process to perform recovery, only Recovery Manager is able to view the relevant information in this view. V$RECOVERY_FILE_STATUS will be empty to all other Oracle users.
| Column | Datatype | Description |
|---|---|---|
FILENUM |
NUMBER |
Number of the file being recovered |
FILENAME |
VARCHAR2(513) |
Filename of the datafile being recovered |
STATUS |
VARCHAR2(13) |
Status of the recovery:
|