Forum Discussion

manatee's avatar
manatee
Level 6
9 years ago

NBU restore success but RMAN archive errors occur

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?

7.6
Backup and Recovery
Basics
Best Practice
NetBackup
Solaris
Tip-How to
  • Nicolai's avatar
    Nicolai
    9 years ago

    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

     

8 Replies

Sort By
  • Pangal's avatar
    Pangal
    Level 5
    9 years ago

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

     

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago
    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's avatar
    Nicolai
    Moderator
    9 years ago

    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's avatar
    manatee
    Level 6
    9 years ago

    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's avatar
    manatee
    Level 6
    9 years ago

    Dear All,

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

  • Marianne's avatar
    Marianne
    Level 6
    9 years ago
    Please remember to follow up and/or close off all your unresolved forum posts.
  • manatee's avatar
    manatee
    Level 6
    9 years ago

    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.