Troubleshoot & Fix RMAN Duplicate Database failed with RMAN-11003 & ORA-19906

Error Description:
RMAN-00571: ===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
RMAN-00571: ===================================================
RMAN-03002: failure of Duplicate Db command at 11/03/2011 00:22:39
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile 'xxxx/xxxxx/archivelog/2011_11_02/thread_1_seq_144.527.7
ORA-00283: recovery session canceled due to errors
ORA-19906: recovery target incarnation changed during recovery

Solution
Connect to Auxiliary database using RMAN
rman target /
RMAN> list incarnation;

using target database control file instead of recovery catalog

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       XXXXXX1  2402685278       PARENT  972274     14-JUN-11
2       2       XXXXXX1  2402685278       PARENT  111317244  01-SEP-11
3       3       XXXXXX1  2402685278       CURRENT 118687777  25-SEP-11
4       4       XXXXXX1  2402685278       ORPHAN  118687777  17-OCT-11

RMAN> report obsolete orphan;

Starting implicit crosscheck backup at 03-NOV-11
allocated channel: ORA_DISK_1
Crosschecked 95 objects
Finished implicit crosscheck backup at 03-NOV-11

Starting implicit crosscheck copy at 03-NOV-11
using channel ORA_DISK_1
Crosschecked 14 objects
Finished implicit crosscheck copy at 03-NOV-11

searching for all files in the recovery area
cataloging files...
no files cataloged

Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
…..
….

RMAN> delete obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 5 days
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
….
….
….
Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
….
Deleted 99 objects
Now you can start the database duplication again with noresume option
RMAN> duplicate target database to TESTE1 until scn 152651941 noresume;

Please try and let me know whether it helps.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google