Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

877440Nov 14 2012 — edited Nov 15 2012
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.
This post has been answered by mseberg on Nov 15 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 13 2012
Added on Nov 14 2012
10 comments
4,425 views