This content has been marked as final. Show 5 replies
If I flashback database to a restore point, do I need to rebuild standby environment?
No, since the standby database should be synchronized to the primary (assumes no delay) it should come along for the ride.
Can I flashback standby to restore point also?
Yes, but the retention period must be greater or equal than the Primary database retention period.
There are very few cases where you would want to do this on the standby.
For example you might use it if a RESETLOGS was used on the Primary.
Guaranteed restore points provide a complementary capability to Flashback Database.
You might set them up during an upgrade.
CREATE RESTORE POINT before_upgrade GUARANTEE FLASHBACK DATABASE;
FLASHBACK DATABASE TO RESTORE POINT before_upgrade;
Section 5 of B14192-03 has some good information on this.
This is worth a look too:
SELECT NAME, SCN, TIME, DATABASE_INCARNATION#, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT;
SELECT NAME, SCN, STORAGE_SIZE FROM V$RESTORE_POINT WHERE GUARANTEE_FLASHBACK_DATABASE = 'YES';
You don't need to recreate your Standby Database if you flashback your Primary (and have flashback logs turned on at Standby also).
(Guaranteed) restore points are not required for this procedure - they just make it easier resp. enforce the presence of the flashback logs you need to flashback to that time.
See an example without restore points here:
You don't need to recreate standby database if flashback is open. But there are many steps to back standby database.
Did you hear about Snapshot standby database? It is very good feature with 11g. And very simple. Yo can convert your physical standby to snapshot and back to physical easily.
DGMGRL> convert database <name> to snapshot standby;
DGMGRL> convert database <name> to physical standby;
Yes and do you know that we have a table tennis in our Ed Center in Utrecht?
Oops, out of topic, you say?
I have indeed heared about Snapshot Standby already - I just fail to see what that has to do with the OPs question :-)
Snapshot Standby was invented to give you a Test Database and after your test is done get you back your Standby Database.
There is no Flashback Database of the Primary involved here.