Difference between revisions of "Use Physical Standby for testing"
From dbawiki
(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 ...") |
|||
| Line 1: | Line 1: | ||
| − | + | 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; | shutdown abort; | ||
startup mount; | startup mount; | ||
Latest revision as of 14:43, 10 November 2012
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;
