cancel
Showing results for 
Search instead for 
Did you mean: 

NBU restore success but RMAN archive errors occur

manatee
Level 6

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?

1 ACCEPTED SOLUTION

Accepted Solutions

Nicolai
Moderator
Moderator
Partner    VIP   

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

 

View solution in original post

8 REPLIES 8

Pangal
Level 5

https://www.veritas.com/support/en_US/article.TECH76121 , This technote will resolve your issue . Kindly go through it

 

manatee
Level 6

thanks. will try it.

Marianne
Level 6
Partner    VIP    Accredited Certified
Is this query related to this post? https://www-secure.symantec.com/connect/forums/any-steps-correctly-restore-oracle-archives-using-rman We have asked questions in that post that was never answered.

Nicolai
Moderator
Moderator
Partner    VIP   

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

 

manatee
Level 6

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.

manatee
Level 6

Dear All,

Thanks for the replies. I have compiled everything to show that it's an Oracle issue.

Marianne
Level 6
Partner    VIP    Accredited Certified
Please remember to follow up and/or close off all your unresolved forum posts.

manatee
Level 6

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.