advertisements
_____________________________________________________________________________________________________________________
Error Description:
RMAN-00571: ===================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
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.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment