9 Replies Latest reply: May 12, 2011 4:40 PM by 835273 RSS

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

    656500
      hi
      i want to make a copy from a databse to new host by rman (hot backup).
      first i do a backup from primary db (with controlfile autobackup ) :

      printing stored script: full_db
      {
      allocate channel c1 type disk format '/home/oracle/backup/%s%d.bck';
      backup archivelog all delete input filesperset=10 ;
      backup full database filesperset =4 ;
      }

      then i copy this files to secondary host and then :

      1- $./rman
      2- RMAN>connect target /
      3- RMAN>startup nomount ;
      4- RMAN>restore spfile from '/.......' ;
      5- RMAN>startup force nomount ;
      6- RMAN>restore controlfile from '/.......' ;
      7- RMAN>shutdown ;
      8- RMAN>exit ;
      9- $./rman target /
      10- RMAN>startup mount ;
      11- RMAN>restore databse ;


      and here , when i issue this command : "alter databse open resetlogs;" rman display this error :

      RMAN> alter database open resetlogs ;

      using target database control file instead of recovery catalog
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of alter db command at 08/24/2008 17:40:48
      ORA-01152: file 1 was not restored from a sufficiently old backup
      ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'


      what's means this error ?

      thx in adv.