Database Backup and Recovery (MOSC)

MOSC Banner

Restore of different days datafilecopy and recovery following. Possible?

edited Jul 5, 2015 11:14PM in Database Backup and Recovery (MOSC) 2 commentsAnswered ✓

I am attempting to set up a DR site using AWS.  I am space restricted on my backup volumes and because of transfer speed and volume of data, some of my backups will wash out before I have copied all of them.

The result is that I will be restoring datafilecopies from different dates.  I hope that the range will be three or four days.  I will be able to preserve the archived logs.  My question is 'Once I have restored all the datafiles, will recovery have a problem with the different scn on the datafile headers?'  Since some of the tablespaces are quite large it is possible I will have multiple copy dates on one tablespace.  Is this feasible, or will this cause problems in the recovery?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center