1 Reply Latest reply: Aug 25, 2013 9:04 PM by Hemant K Chitale RSS

    ORA-01190: control file or data file 6 is from before the last RESETLOGS

    flighting_sky

      condition:

      oracle 11.2g&&windows7(32bit)



      When I open the database,I meet with such problem:

       

      SQL> alter database open;

       

      alter database open

       

      *

       

      ERROR at line 1:

       

      ORA-01190: control file or data file 6 is from before the last RESETLOGS

       

      ORA-01110: data file 6: 'D:\APP\ASUS\ORADATA\TEST\TEST01.DBF'

       

      And I can't recover the datafile 6 with the flowing statement:

       

      SQL>  recover datafile 6;

       

      ORA-00283: recovery session canceled due to errors

       

      ORA-19909: datafile 6 belongs to an orphan incarnation

       

      ORA-01110: data file 6: 'D:\APP\ASUS\ORADATA\TEST\TEST01.DBF'

       

      Then I recall that I ever made the datafile 6 offline ,before I made the database resetlogs.Now what can I do to deal with this problem?Thanks!

        • 1. Re: ORA-01190: control file or data file 6 is from before the last RESETLOGS
          Hemant K Chitale

          >I recall that I ever made the datafile 6 offline ,before I made the database resetlogs

          There would have been a reason *why* you made the datafile offline.   If you don't need the datafile and all the data in this datafile you could DROP it.

           

          Note that a table / index in a tablespace can span multiple datafiles in a tablespace so if this is one of two or more datafile in a single tablespace, you might have read errors accessing tables / indexes in that tablespace.

           

           

          Hemant K Chitale