Script to find Files needing media recovery

SQL> select file#, error from v$recover_file;


FILE# ERROR
---------- -------------------------
3 FILE NOT FOUND

The V$RECOVER_FILE reads from the control file