Database Backup and Recovery (MOSC)

MOSC Banner

Finding the Most Recent Point in time for restore ( without access to source db).

edited May 10, 2010 7:55PM in Database Backup and Recovery (MOSC) 3 commentsAnswered
 I recently, had to restore two rman databases and was interested in restoring them to the same point in time.


I was allegedly given a full backupset.


In order to find the most recent time I could restore to, I

a)  Restored the controlfile

b) Queried v$archived_log from the latest completion_time the controlfile was aware of.

c)  I then attempted a restore using a set until until that point in time.

d) The restore went fine.

e) The recovery did not and wanted archivelogs past that point that I could not access.

f)  For a given set of rman files: 

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