https://mailnest.com/dbawiki/index.php?action=history&feed=atom&title=Use_Physical_Standby_for_testing 2026-04-04T23:41:13Z Revision history for this page on the wiki MediaWiki 1.29.3 https://mailnest.com/dbawiki/index.php?title=Use_Physical_Standby_for_testing&diff=205&oldid=prev 2012-11-10T14:43:58Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='en'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Older revision</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Revision as of 14:43, 10 November 2012</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1" >Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del class="diffchange diffchange-inline">This assumes </del>the Primary <del class="diffchange diffchange-inline">has failed and the </del>Standby <del class="diffchange diffchange-inline">must be brought up to replace it.</del></div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">Assuming a guaranteed restore point was used, after </ins>the <ins class="diffchange diffchange-inline">Standby has been </ins>Primary <ins class="diffchange diffchange-inline">for a while, this will return it to being a </ins>Standby</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>&#160;</div></td><td colspan="2">&#160;</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; shutdown abort;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; shutdown abort;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; startup mount;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>&#160; startup mount;</div></td></tr> </table>

Stuart https://mailnest.com/dbawiki/index.php?title=Use_Physical_Standby_for_testing&diff=16&oldid=prev 2011-11-22T19:37:14Z

<p>Created page with &quot;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 ...&quot;</p> <p><b>New page</b></p><div>This assumes the Primary has failed and the Standby must be brought up to replace it.<br /> <br /> shutdown abort;<br /> startup mount;<br /> select name from v$restore_point;<br /> flashback database to restore point DRTEST;<br /> alter database convert to physical standby;<br /> shutdown abort;<br /> startup nomount;<br /> alter database mount standby database;<br /> alter database recover managed standby database disconnect;</div>

Shb