11-20-2015 03:03 AM
NBU 7.6.0.3
we did a restore from RMAN yesterday and everything was status 0 as per the activity monitor. however, in RMAN we got the below error messages which is strange considering there were no errors logged in the activity monitor.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 11/19/2015 23:41:55
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 2 with sequence 22632 and starting SCN of 5451
3798693 found to restore
RMAN-06025: no backup of archived log for thread 2 with sequence 22631 and starting SCN of 5451
2912325 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 23725 and starting SCN of 5451
3797845 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 23724 and starting SCN of 5451
3401931 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 23723 and starting SCN of 5451
2912331 found to restore
how does one fix this?
Solved! Go to Solution.
11-20-2015 05:15 AM
Ask the dba to run a "rman crosscheck"
https://blogs.oracle.com/sysdba/entry/rman_backup_error_what_to_do_i
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint002.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta015.htm
11-20-2015 03:13 AM
https://www.veritas.com/support/en_US/article.TECH76121 , This technote will resolve your issue . Kindly go through it
11-20-2015 03:43 AM
thanks. will try it.
11-20-2015 04:00 AM
11-20-2015 05:15 AM
Ask the dba to run a "rman crosscheck"
https://blogs.oracle.com/sysdba/entry/rman_backup_error_what_to_do_i
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/maint002.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta015.htm
11-22-2015 12:10 AM
um, yes. i have pointed that out.
i'm just collecting information to show to them that it's an Oracle issue.
thanks for the replies though.
11-22-2015 12:11 AM
Dear All,
Thanks for the replies. I have compiled everything to show that it's an Oracle issue.
11-22-2015 12:15 AM
11-22-2015 05:36 AM
hi all,
as mentioned in other post, https://www-secure.symantec.com/connect/forums/any-steps-correctly-restore-oracle-archives-using-rman
the problem is RMAN. during a restore, somehow the archive log is synching with the current control file hence it can't find the archive logs coz the control file is current. i don't know why but that's what i got from our DBA.
here's the thing, when restores are done to make sure that the archive logs are processed by NBU after 11:30pm, it would be successful. but if during the restore of the archive logs it falls within 11pm and 11:30pm the restore would be unsuccessful. *shrugs*
anyhow, it all points to RMAN.
thanks to everyone who helped.