Can flashback database be used with a Snapshot Standby
edited Feb 26, 2015 1:01AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 6 commentsAnswered
I have a Data Guard configuration with a Physical standby. I would like to be able to convert the database to a Snapshot Standby and Flashback Database to an older point-in-time.
I have not enabled "apply delay", instead I have configured Flashback on the Physical database, sufficient to go back 48 hours in time.
So far testing was not successful with :
- Converting to Snapshot
- Restart and mount
- Attempting to Flashback database to an older point-in-time (for example 4 hours back)
It is complaining about not finding the right archive redo log file.
Is there something wrong in the approach? or is it just not possible?
2