Database Administration (MOSC)

MOSC Banner

How to confirm a guaranteed restore point is viable after switch to copy

edited Jul 22, 2016 3:32PM in Database Administration (MOSC) 3 commentsAnswered ✓

Hi

This is 11.2.0.4 RAC on Oracle Linux 6.  We created a guaranteed restore point and have been managing our FRA to hold the flashback logs.  Today, I used RMAN to copy the database to a new disk group (backup as copy database format '+DATA_DBD17'), and switched to the copy.  I ran recover database, then open database.  The database incarnation did not change.  I also updated db_create_file_dest to a different FRA.

I can view the restore point in v$restore_point, and I have the same number of records in v$flashback_database_logfile as before.  I read the note FLASHBACK LOGS STREAMED TO TWO LOCATIONS AFTER CHANGING DB_RECOVERY_FILE_DEST (

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