10 Replies Latest reply: Nov 15, 2012 3:34 PM by mseberg RSS

    duplicate database to: end with error: rman-06136 ora-01110

    877440
      OS: Linux REDHAT 5
      DB: 11.2.0.3

      Backuped source db using rman full backup and incremental level 1 twice and scp all the backupsets to the auxiliary hosts.

      I try to do duplicate as following:
      run {
      duplicate database to TST
      UNTIL TIME "TO_DATE('11-12-2012', 'MM/DD/YYYY HH24:MI:SS')"
      backup location '/stage/TST'
      NOFILENAMECHECK;
      }

      Everything ran well and restore all finished, then it proceeded to recover with following error:

      Oracle Error:
      ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
      ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '+DAT/tst/datafile/system.279.799358399'

      Then it kept moving on to the end with following errors;
      ORACLE error from auxiliary database: ORA-19751: could not create the change tracking file
      ORA-19750: change tracking file: '+DAT/prds/changetracking/ctf.906.799250971'
      ORA-17502: ksfdcre:4 Failed to create file +DAT/prds/changetracking/ctf.906.799250971
      ORA-15046: ASM file name '+DAT/prds/changetracking/ctf.906.799250971' is not in single-file creation form

      Ignoring error, reattempt command after duplicate finishes

      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 11/14/2012 22:26:18
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06136: ORACLE error from auxiliary database: ORA-01194: file 1 needs more recovery to be consistent
      ORA-01110: data file 1: '+DAT/tst/datafile/system.279.799358399'

      RMAN>

      WHat I should proceed from here?

      Thanks.