10 Replies Latest reply: Jul 9, 2013 8:28 AM by Mark D Powell RSS

    ORA-01122: database file 7 failed verification check

    PugazhS

      Hi..

       

      am trying to Recover my DB, these are the errors i got , while doing so.

       

      please suggest some solution. Thank you .

       

      PS : i deleted the GDEFAULT1_OID.DBF file, while creating my schemas through RCU. but schema creation failed.. so restored back the GDEFAULT1_OID.DBF file to location.

       

      SQL> recover database

      ORA-00283: recovery session canceled due to errors

      ORA-01110: data file 7: 'C:\ORACLE\ORACLE11G\ORADATA\ORCL\GDEFAULT1_OID.DBF'

      ORA-01122: database file 7 failed verification check

      ORA-01110: data file 7: 'C:\ORACLE\ORACLE11G\ORADATA\ORCL\GDEFAULT1_OID.DBF'

      ORA-01204: file number is 12 rather than 7 - wrong file