Use Physical Standby for testing

From dbawiki
Revision as of 14:43, 10 November 2012 by Stuart (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Assuming a guaranteed restore point was used, after the Standby has been Primary for a while, this will return it to being a Standby

shutdown abort;
startup mount;
select name from v$restore_point;
flashback database to restore point DRTEST;
alter database convert to physical standby;
shutdown abort;
startup nomount;
alter database mount standby database;
alter database recover managed standby database disconnect;