This discussion is archived
10 Replies Latest reply: Nov 15, 2012 1:34 PM by mseberg RSS

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

user301176 Explorer
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points