Thursday, November 24, 2011

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

No comments:

Post a Comment