6 Replies Latest reply: Jul 23, 2014 9:21 AM by user10341747 RSS

    ORA-01152: file 1 was not restored from a sufficiently old backup ORA-01110: data file 1

    ManishS137

      Hi Guys ,

       

      I am trying to restore a database to new Server , but I have Started getting Error Recently

       

      My Backup Script:

       

      run {

      allocate channel ch00 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';

      allocate channel ch01 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';

      allocate channel ch02 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';

      allocate channel ch03 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';

      allocate channel ch04 type disk format '/orabackup/RMANBKP/SIMUAT/SIMUAT_%T_%U';

      setlimit channel ch00 kbytes 2097150;

      setlimit channel ch01 kbytes 2097150;

      setlimit channel ch02 kbytes 2097150;

      setlimit channel ch03 kbytes 2097150;

      setlimit channel ch04 kbytes 2097150;

      backup incremental level 0 database plus archivelog ;

      backup as copy current controlfile format '/orabackup/RMANBKP/SIMUAT/control__%T_%U.ctl';

      RELEASE CHANNEL ch00;

      RELEASE CHANNEL ch01;

      RELEASE CHANNEL ch02;

      RELEASE CHANNEL ch03;

      RELEASE CHANNEL ch04;

      RELEASE CHANNEL ch05;

      }

       

       

       

      While Restoring on different Server I am following procedure

       

      1: Opening Clone Database in Nomount state (with Pfile)

      2: Recovering controlfile from backup

      3: Mouting Clone Database

      4: Restoring Datafiles with follwing script

       

       

      run {

      catalog start with '/orabackup/RMANBKP/SIMPRD/RMAN_16_Jul_2014';

      CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' CLEAR;

      allocate channel ch00 type disk format '/oradata/SIMPRD/SIMPRD_%T_%U';

      allocate channel ch01 type disk format '/oradata/SIMPRD/SIMPRD_%T_%U';

      restore database;

      switch datafile all;

      RELEASE CHANNEL ch00;

      RELEASE CHANNEL ch01;

      }

       

       

      5: BAcking up controlfile and Recreaing with resetlogs and NOArchivelog mode

       

      6:now Running below command to open database .

      run {

      recover database ;

      alter database open resetlogs;

      }

       

      Now Issue is

       

      1: Open database failing with below Error

      SQL> run {

         recover database ;

         alter database open resetlogs

          }

       

      Starting recover at 16-JUL-14

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=193 device type=DISK

       

      starting media recovery

       

      RMAN-08187: WARNING: media recovery until SCN 6020263420798 complete

      Finished recover at 16-JUL-14

       

      ERROR at line 1:

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

      ORA-01110: data file 1: '/oradata/SIMPRD/system01.dbf'

       

       

      2: WHy Redo logs are not getting created ,Even after recreating controlfile ?

      3: How to create REDO logs if they are not created while recovery

      4: Above Error (ORA-01152:ORA-01110) I am even getting while Cloning Database with RMAN clone method .

       

       

      Please suggest , What i am doing wrong?

       

      Regards,

      Manish