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!

How to resume/re-initiate a failed RMAN DUPLICATE ?

Mark82Aug 21 2022

Oracle RDBMS version : 19C
OS platform : Oracle Linux 8.4

Lets say I run a RMAN DUPLICATE and it fails with the following error.

The auxiliary instance is in MOUNT state now.
After restoring the requested archivelog, Is there a way I can resume/re-initiate the previously failed RMAN DUPLICATE ?

Or do I have to cleanup the ASM diskgroup, shutdown the mounted instance and rerun RMAN DUPLICATE from scratch ?

channel ch4: starting archived log restore to default destination
channel ch4: restoring archived log
archived log thread=2 sequence=55521
channel ch4: reading from backup piece xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
channel ch5: ORA-19870: error while restoring backup piece xxxxxxxxxxxxxxxxxxxxxxxx
ORA-19507: failed to retrieve sequential file, handle=xxxxxxxxxxxxxxxxxxx, parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: non RMAN, but media manager or vendor specific failure, error text:
  Vendor specific error: OB2_StartObjectRestoreFullName() f
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/20/2022 20:02:13
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-20506: no backup of archived log found
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 55520 and starting SCN of 589193398905 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 63183 and starting SCN of 589193398733 found to restore

RMAN>

Recovery Manager complete.
Comments
Post Details
Added on Aug 21 2022
0 comments
1,092 views