2 Replies Latest reply: Jun 14, 2013 7:21 AM by saurabh RSS

    fail to open after incomplete media recovery

    928704

      hi,

       

      i am using oracle 11.2.0.1.0. We have configured rman using repository catalog configure in another database. We have perform incomplete recovery to restore database to previous scn, but the database fail to open shown error message, how to open the database?

       

      RMAN-00571, RMAN-00569,RMAN-03002,

      ORA-01139: RESETLOGS option only valid after an incomplete database recovery

       

      [code]

       

      sql ) startup mount;

      RMAN> run {

          set until scn 1812690;

           restore database;

           recover database;

         }

       

      SQL>

       

      recover database until cancel;

      alter database open resetlogs;

      alter database open resetlogs

      *

      ERROR at line 1:

      ORA-01152: file 2 was not restored from a sufficiently old backup

      ORA-01110: data file 2: 'C:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF'

       

      [code]

        • 1. Re: fail to open after incomplete media recovery
          Hemant K Chitale

          >set until scn 1812690

           

          >ORA-01152: file 2 was not restored from a sufficiently old backup

           

          You need to have database datafile backups created before the target SCN.

           

           

          Hemant K Chitale

           


          • 2. Re: fail to open after incomplete media recovery
            saurabh

            According to this error your controlfile is old and you are restoring your datafiles from backup. If still you want to open the database in resetlogs, then what you can do is backup your controlfile as trace using "alter database backup controlfile to trace as "LOCATION";. Then recreate your controlfile from trace. But before take backup of controlfile and then re-create it using create controlfile script from the trace you have generated. Then try open in resetlogs. It will open.