Use Physical Standby for testing

From dbawiki
Revision as of 19:37, 22 November 2011 by Shb (talk | contribs) (Created page with "This assumes the Primary has failed and the Standby must be brought up to replace it. shutdown abort; startup mount; select name from v$restore_point; flashback database to ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

This assumes the Primary has failed and the Standby must be brought up to replace it.

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;