V$RECOVERY_FILE_STATUS

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: `IN RECOVERY` `CURRENT` `NOT RECOVERED`