Skip to Main Content
  • Questions
  • When does RMAN validate archived redo logs are available during a duplicate?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: October 11, 2017 - 11:51 pm UTC

Last updated: October 16, 2017 - 1:26 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Does RMAN validate all archived redo logs are available at the beginning of a duplication or once it starts restoring the logs after the backup data files have been restored?

and Connor said...

The sequence of steps is not too dissimilar from what you would do if perform this manually, ie

a- set newnames for target datafiles
b- restore datafiles
c- create a new controlfile
d- restore archivelogs
e- do media recovery to a point in time

So you may get to (d) before finding you don't have the logs you need. But, the DUPLICATE command can always be "restarted" if it fails in the sense that when you re-run the *same* duplicate, the database should work out where it got up on last run, and work from that point. So if archivelogs were missing, you can retrieve them and re-run the duplicate.

If the archivelogs are gone forever, then you would need to duplicate from a backup/point in time at which you *did* have them.

Rating

  (2 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, October 16, 2017 - 3:29 am UTC


A reader, October 16, 2017 - 11:09 pm UTC


More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.