4 Replies Latest reply: May 16, 2013 11:39 AM by RjTan RSS

    ORACLE error from auxiliary database: ORA-01152: file 2 was not restored fr

    RjTan
      Hello,

      i'm trying to clone a database. It is in archive log mode.
      I took a full back using below command
      run {
        backup
           tag 'DAILY_WHOLE'
           format 'FULL_backup_%s_%p_%c.bkp'     database
           plus archivelog
           tag 'DAILY_WHOLE'
           delete all input;
        backup
           current controlfile
           format 'FULL_backup_%s_%p_%c.bkp'     tag 'WHOLE'
           spfile
           format 'FULL_backup_%s_%p_%c.bkp'     tag 'WHOLE';
      }
      then i issue a duplicate database command
      RUN
      {                         
       DUPLICATE DATABASE TO TEST_DB
                NOFILENAMECHECK
                  NOREDO
                 BACKUP LOCATION '/disk10/flash_recovery_area/PROD';
       }
      at the very end I got this error.
      contents of Memory Script:
      {
         Alter clone database open resetlogs;
      }
      executing Memory Script
      
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 05/15/2013 11:59:21
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06136: ORACLE error from auxiliary database: ORA-01152: file 2 was not restored from a sufficiently old backup
      ORA-01110: data file 2: 'sysaux.dbf'
      Can anyone help me? I would appreciate it. thanks