Check if any Oracle Data Files Needed for Recovery

You have issue while bringing up the Oracle database and you suspect that there are some data files missing or corrupted. In order to find the missing or corrupted data files for recovery, use the following command,

SELECT * from V$RECOVER_FILE;