Versions Compared

Old Version 3

changes.mady.by.user KrupeshD (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user KrupeshD (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

When an error occurs during Graceful Switchover on either the primary or the standby server, processing will stop on both the primary and standby servers. Dbvisit Standby will display the rollback or roll forward action required depending at which checkpoint the processing stopped, but they are also listed below for reference. Only the action associated with the checkpoint needs to be performed, not the actions for the subsequent checkpoints.For example:If Graceful Switchover failed at checkpoint 8 on the primary and standby server, then only the checkpoint action for checkpoint 8 needs to be performed on both the primary and the standby server.<table border=0 cellpadding=0 cellspacing=0 width=556 style='border-collapse:
collapse;table-layout:fixed;width:556pt'>
<col width=148 style='mso-width-source:userset;mso-width-alt:6314;width:148pt'>
<col width=83 style='mso-width-source:userset;mso-width-alt:3541;width:83pt'>
<col width=325 style='mso-width-source:userset;mso-width-alt:13866;width:325pt'>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl65" width=148 style='height:16.0pt;width:148pt'>Server</td>
<td class="xl66" width=83 style='width:83pt'>Checkpoint</td>
<td class="xl67" width=325 style='width:325pt'>Rollback or roll forward action</td>
</tr>
<tr height=31 style='height:31.0pt'>
<td height=31 class="xl68" width=148 style='height:31.0pt;width:148pt'>Primary</td>
<td class="xl69" width=83 style='width:83pt'>1</td>
<td class="xl70" width=325 style='width:325pt'>Database is still primary
database. No rollback needs to be performed. Primary database is not
affected.</td>
</tr>
<tr height=31 style='height:31.0pt'>
<td height=31 class="xl68" width=148 style='height:31.0pt;width:148pt'>Standby</td>
<td class="xl69" width=83 style='width:83pt'>1</td>
<td class="xl70" width=325 style='width:325pt'>Database is still standby
database. No rollback needs to be performed. Standby database is not
affected.</td>
</tr>
<tr height=31 style='height:31.0pt'>
<td height=31 class="xl68" width=148 style='height:31.0pt;width:148pt'>Primary</td>
<td class="xl69" width=83 style='width:83pt'>2</td>
<td class="xl70" width=325 style='width:325pt'>Database is still primary
database. No rollback needs to be performed. Primary database is not
affected.</td>
</tr>
<tr height=31 style='height:31.0pt'>
<td height=31 class="xl68" width=148 style='height:31.0pt;width:148pt'>Standby</td>
<td class="xl69" width=83 style='width:83pt'>2</td>
<td class="xl70" width=325 style='width:325pt'>Database is still standby
database. No rollback needs to be performed. Standby database is not
affected.</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td rowspan=2 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=2 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>3</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open. <font class="font6">Rollback action:</font><font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please restart
primary database in normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=31 style='height:31.0pt'>
<td height=31 class="xl68" width=148 style='height:31.0pt;width:148pt'>Standby</td>
<td class="xl69" width=83 style='width:83pt'>3</td>
<td class="xl70" width=325 style='width:325pt'>Database is still standby
database. No rollback needs to be performed. Standby database is not
affected.</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td rowspan=2 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=2 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>4</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is in restricted mode. <font class="font6">Rollback
action:</font><font class="font5"><span
style="mso-spacerun:yes">&nbsp;</span>Please restart primary database in
normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=3 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=3 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>4</td>
<td class="xl71" width=325 style='width:325pt'>Database is still standby
database. Standby database has been shutdown or started NOMOUNT.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
restart standby database:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td rowspan=2 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=2 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>5</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open. <font class="font6">Rollback action:</font><font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please restart
primary database in normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=5 height=106 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:106.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=5 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>5</td>
<td class="xl71" width=325 style='width:325pt'>Database is still standby
database. Standby database has been shutdown or started NOMOUNT.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
restart standby database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td rowspan=2 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=2 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>6</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open. <font class="font6">Rollback action:</font><font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please restart
primary database in normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=5 height=106 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:106.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=5 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>6</td>
<td class="xl71" width=325 style='width:325pt'>Database is still standby
database. Standby database has been shutdown or started NOMOUNT.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
restart standby database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td rowspan=2 height=61 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:61.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=2 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>7</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open. <font class="font6">Rollback action:</font><font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please restart
primary database in normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=5 height=106 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:106.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=5 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>7</td>
<td class="xl71" width=325 style='width:325pt'>Database is still standby
database. Standby database has been shutdown or started NOMOUNT.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
restart standby database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=3 height=76 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:76.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=3 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>8</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl73" width=325 style='height:30.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
restart primary database in normal mode:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=60 style='height:60.0pt'>
<td rowspan=10 height=241 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:241.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=10 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>8</td>
<td class="xl71" width=325 style='width:325pt'>Database is still standby
database. Convertion of Database &lt;ORACLE_SID&gt; has to the Primary
Database has not been completed. This database has to be rolled back to a
standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>1)
Shutdown database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
stop &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl71" width=325 style='height:45.0pt;width:325pt'>2)
Startup standby instance NOMOUNT and replace controlfiles with backed up
controlfile &lt;filename&gt; using RMAN command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp; </span>RMAN&gt;RESTORE STANDBY
CONTROLFILE FROM ÔfilenameÕ;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>3)
Retart standby database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl77" width=325 style='height:16.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=13 height=271 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:271.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=13 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>9</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
start primary database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl73" width=325 style='height:30.0pt;width:325pt'>Alternatively<font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>this database may
be rolled forward to a standby database.</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Shutdown database
with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'> <font
class="font7">dbv_oraStartStop stop &lt;DDC&gt;</font></td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl78" width=325 style='height:45.0pt;width:325pt'>2.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Startup instance
NOMOUNT and replace controlfiles with a standby controlfile by running RMAN
command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>RESTORE STANDBY CONTROLFILE FROM &lt;filename&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl78" width=325 style='height:30.0pt;width:325pt'>3.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Update DDC file
dbv_&lt;DDC&gt;.env and reverse settings with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>4.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Start standby
database with command:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=18 height=366 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:366.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=18 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>9</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
SQL&gt; <font class="font9">recover database;</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>2.
SQL&gt; <font class="font9">alter system archive log all;</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>3.
SQL&gt; <font class="font9">alter database open;</font></td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>4.
Update DDC file dbv_&lt;DDC&gt;.env and reverse settings with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>5. Drop
and recreate database tempfile [location of tempfile script will be shown] if
needed.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Alternatively
this database may be rolled back to a standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>1)
Shutdown database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
stop &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl71" width=325 style='height:45.0pt;width:325pt'>2)
Startup standby instance NOMOUNT and replace controlfiles with backed up
controlfile &lt;filename&gt; using RMAN command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp; </span>RMAN&gt;RESTORE STANDBY
CONTROLFILE FROM ÔfilenameÕ;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>3)
Retart standby database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=21 style='height:21.0pt'>
<td height=21 class="xl75" width=325 style='height:21.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=13 height=271 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:271.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=13 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>10</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
start primary database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl73" width=325 style='height:30.0pt;width:325pt'>Alternatively<font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>this database may
be rolled forward to a standby database.</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Shutdown database
with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'> <font
class="font7">dbv_oraStartStop stop &lt;DDC&gt;</font></td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl78" width=325 style='height:45.0pt;width:325pt'>2.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Startup instance
NOMOUNT and replace controlfiles with a standby controlfile by running RMAN
command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>RESTORE STANDBY CONTROLFILE FROM &lt;filename&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl78" width=325 style='height:30.0pt;width:325pt'>3.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Update DDC file
dbv_&lt;DDC&gt;.env and reverse settings with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>dbv_oraStartStop update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>4.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Start standby
database with command:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=17 height=351 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:351.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=17 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>10</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
SQL&gt; <font class="font9">alter system archive log all;</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>2.
SQL&gt; <font class="font9">alter database open;</font></td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>3.
Update DDC file dbv_&lt;DDC&gt;.env and reverse settings with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>4. Drop
and recreate database tempfile [location of tempfile script will be shown] if
needed.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Alternatively
this database may be rolled back to a standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>1)
Shutdown database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
stop &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl71" width=325 style='height:45.0pt;width:325pt'>2)
Startup standby instance NOMOUNT and replace controlfiles with backed up
controlfile &lt;filename&gt; using RMAN command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp; </span>RMAN&gt;RESTORE STANDBY
CONTROLFILE FROM ÔfilenameÕ;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>3)
Retart standby database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=21 style='height:21.0pt'>
<td height=21 class="xl75" width=325 style='height:21.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=13 height=271 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:271.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=13 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>11</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
start primary database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl73" width=325 style='height:30.0pt;width:325pt'>Alternatively<font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>this database may
be rolled forward to a standby database.</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Shutdown database
with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'> <font
class="font7">dbv_oraStartStop stop &lt;DDC&gt;</font></td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl78" width=325 style='height:45.0pt;width:325pt'>2.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Startup instance
NOMOUNT and replace controlfiles with a standby controlfile by running RMAN
command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl81" width=325 style='height:15.0pt;width:325pt'>RESTORE
STANDBY CONTROLFILE FROM &lt;filename&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl78" width=325 style='height:30.0pt;width:325pt'>3.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Update DDC file
dbv_&lt;DDC&gt;.env and reverse settings with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl81" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>4.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Start standby
database with command:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=17 height=351 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:351.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=17 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>11</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
SQL&gt; <font class="font9">alter system archive log all;</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>2.
SQL&gt; <font class="font9">alter database open;</font></td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>3.
Update DDC file dbv_&lt;DDC&gt;.env and reverse settings with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>4. Drop
and recreate database tempfile [location of tempfile script will be shown] if
needed.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Alternatively
this database may be rolled back to a standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>1)
Shutdown database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
stop &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl71" width=325 style='height:45.0pt;width:325pt'>2)
Startup standby instance NOMOUNT and replace controlfiles with backed up
controlfile &lt;filename&gt; using RMAN command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp; </span>RMAN&gt;RESTORE STANDBY
CONTROLFILE FROM ÔfilenameÕ;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>3)
Retart standby database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=21 style='height:21.0pt'>
<td height=21 class="xl75" width=325 style='height:21.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td rowspan=13 height=271 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:271.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=13 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>12</td>
<td class="xl71" width=325 style='width:325pt'>Database is still primary
database. Primary database is not open.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:<font class="font5"><span style="mso-spacerun:yes">&nbsp;</span>Please
start primary database:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl73" width=325 style='height:30.0pt;width:325pt'>Alternatively<font
class="font5"><span style="mso-spacerun:yes">&nbsp;</span>this database may
be rolled forward to a standby database.</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Shutdown database
with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'> <font
class="font7">dbv_oraStartStop stop &lt;DDC&gt;</font></td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl78" width=325 style='height:45.0pt;width:325pt'>2.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Startup instance
NOMOUNT and replace controlfiles with a standby controlfile by running RMAN
command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl81" width=325 style='height:15.0pt;width:325pt'>RESTORE
STANDBY CONTROLFILE FROM &lt;filename&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl78" width=325 style='height:30.0pt;width:325pt'>3.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Update DDC file
dbv_&lt;DDC&gt;.env and reverse settings with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl81" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>4.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Start standby
database with command:</font></td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=18 height=376 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:376.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=18 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>12</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
Update DDC file dbv_&lt;DDC&gt;.env with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>dbv_oraStartStop update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>2. Add
database tempfile [location of tempfile script will be shown] if needed.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>3.
Archives may need to be compressed/uncompressed (not essential).</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Alternatively
this database may be rolled back to a standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Rollback
action:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>1)
Shutdown database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
stop &lt;DDC&gt;</td>
</tr>
<tr height=45 style='height:45.0pt'>
<td height=45 class="xl71" width=325 style='height:45.0pt;width:325pt'>2)
Startup standby instance NOMOUNT and replace controlfiles with backed up
controlfile &lt;filename&gt; using RMAN command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp; </span>RMAN&gt;RESTORE STANDBY
CONTROLFILE FROM ÔfilenameÕ;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl71" width=325 style='height:15.0pt;width:325pt'>3)
Retart standby database with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl76" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
restart &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl72" width=325 style='height:16.0pt;width:325pt'>SQL&gt;alter
system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=6 height=91 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:91.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=6 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>13</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
Update DDC file dbv_&lt;DDC&gt;.env with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>2. Start
standby database with command:</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl75" width=325 style='height:16.0pt;width:325pt'>dbv_oraStartStop
start &lt;DDC&gt;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=8 height=171 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:171.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=8 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>13</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>4.
Update DDC file dbv_&lt;DDC&gt;.env with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>dbv_oraStartStop update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>5. Add
database tempfile [location of tempfile script will be shown] if needed.</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>6.
Archives may need to be compressed/uncompressed (not essential).</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit
has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA
run the following command:</td>
</tr>
<tr height=21 style='height:21.0pt'>
<td height=21 class="xl77" width=325 style='height:21.0pt;width:325pt'>7.
SQL&gt;alter system set db_recovery_file_dest = 'xxxxx' scope=both;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=5 height=76 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:76.0pt;border-top:none;width:148pt'>Primary</td>
<td rowspan=5 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>14</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
standby database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl80" width=325 style='height:15.0pt;width:325pt'>1.
Update DDC file dbv_&lt;DDC&gt;.env with command:</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl79" width=325 style='height:15.0pt;width:325pt'>dbv_oraStartStop
update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=16 style='height:16.0pt'>
<td height=16 class="xl82" width=325 style='height:16.0pt;width:325pt'>&nbsp;</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=8 height=166 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:166.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=8 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>14</td>
<td class="xl71" width=325 style='width:325pt'>Database has been converted to
the primary database.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl73" width=325 style='height:15.0pt;width:325pt'>Roll
forward action:<span style="mso-spacerun:yes">&nbsp;</span></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl78" width=325 style='height:15.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Update DDC file
dbv_&lt;DDC&gt;.env with command:</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td height=15 class="xl74" width=325 style='height:15.0pt;width:325pt'><span
style="mso-spacerun:yes">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span>dbv_oraStartStop update_ddc_file &lt;DDC&gt;</td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl83" width=325 style='height:30.0pt;width:325pt'>2.<font
class="font10">&nbsp;&nbsp;&nbsp; </font><font class="font5">Add database
tempfile [location of tempfile script will be shown] if needed.</font></td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl83" width=325 style='height:30.0pt;width:325pt'>3.<font
class="font10">&nbsp;&nbsp;&nbsp; </font><font class="font5">Archives may
need to be compressed/uncompressed (not essential).</font></td>
</tr>
<tr height=30 style='height:30.0pt'>
<td height=30 class="xl71" width=325 style='height:30.0pt;width:325pt'>Dbvisit

ServerCheckpointRollback or Rollforward Action
Primary1Database is still primary database. No rollback needs to be performed. Primary database is not affected.
Standby1Database is still standby database. No rollback needs to be performed. Standby database is not affected.
Primary2Database is still primary database. No rollback needs to be performed. Primary database is not affected.
Standby2Database is still standby database. No rollback needs to be performed. Standby database is not affected.
Primary3Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby3Database is still standby database. No rollback needs to be performed. Standby database is not affected.
Primary4Database is still primary database. Primary database is in restricted mode. Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby4Database is still standby database. Standby database has been shutdown or started NOMOUNT.
Rollback action: Please restart standby database:
dbv_oraStartStop restart <DDC>
Primary5Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby5Database is still standby database. Standby database has been shutdown or started NOMOUNT.
Rollback action: Please restart standby database:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary6Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby6Database is still standby database. Standby database has been shutdown or started NOMOUNT.
Rollback action: Please restart standby database:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA

...

run the following command:

...

SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both

...

;
Primary7Database is still primary database. Primary database is not open. Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby7Database is still standby database. Standby database has been shutdown or started NOMOUNT.
Rollback action: Please restart standby database:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary8Database is still primary database. Primary database is not open.
Rollback action: Please restart primary database in normal mode:
dbv_oraStartStop restart <DDC>
Standby8Database is still standby database. Convertion of Database <ORACLE_SID> has to the Primary Database has not been completed. This database has to be rolled back to a standby database.
Rollback action: 
1) Shutdown database with command:
dbv_oraStartStop stop <DDC>
2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command:
    RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’;
3) Retart standby database with command:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary9Database is still primary database. Primary database is not open.
Rollback action: Please start primary database:
dbv_oraStartStop start <DDC>
Alternatively this database may be rolled forward to a standby database.
Roll forward action:
1.    Shutdown database with command:
 dbv_oraStartStop stop <DDC>
2.    Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command:
        RESTORE STANDBY CONTROLFILE FROM <filename>
3.    Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
4.    Start standby database with command:
dbv_oraStartStop start <DDC>
Standby9Database has been converted to the primary database.
Roll forward action: 
1. SQL> recover database;
2. SQL> alter system archive log all;
3. SQL> alter database open;
4. Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
5. Drop and recreate database tempfile [location of tempfile script will be shown] if needed.

...

Alternatively this database may be rolled back to a standby database.
Rollback action:
1) Shutdown database with command:
dbv_oraStartStop stop <DDC>
2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command:
    RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’;
3) Retart standby database with command:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To

...

enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary10Database is still primary database. Primary database is not open.
Rollback action: Please start primary database:
dbv_oraStartStop start <DDC>
Alternatively this database may be rolled forward to a standby database.
Roll forward action:
1.    Shutdown database with command:
 dbv_oraStartStop stop <DDC>
2.    Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command:
        RESTORE STANDBY CONTROLFILE FROM <filename>
3.    Update DDC file dbv_<DDC>.env and reverse settings with command:
       dbv_oraStartStop update_ddc_file <DDC>
4.    Start standby database with command:
dbv_oraStartStop start <DDC>
Standby10Database has been converted to the primary database.
Roll forward action: 
1. SQL> alter system archive log all;
2. SQL> alter database open;
3. Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
4. Drop and recreate database tempfile [location of tempfile script will be shown] if needed.
Alternatively this database may be rolled back to a standby database.
Rollback action:
1) Shutdown database with command:
dbv_oraStartStop stop <DDC>
2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command:
    RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’;
3) Retart standby database with command:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary11Database is still primary database. Primary database is not open.
Rollback action: Please start primary database:
dbv_oraStartStop start <DDC>
Alternatively this database may be rolled forward to a standby database.
Roll forward action:
1.    Shutdown database with command:
 dbv_oraStartStop stop <DDC>
2.    Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command:
RESTORE STANDBY CONTROLFILE FROM <filename>
3.    Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
4.    Start standby database with command:
dbv_oraStartStop start <DDC>
Standby11Database has been converted to the primary database.
Roll forward action: 
1. SQL> alter system archive log all;
2. SQL> alter database open;
3. Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
4. Drop and recreate database tempfile [location of tempfile script will be shown] if needed.
Alternatively this database may be rolled back to a standby database.
Rollback action:
1) Shutdown database with command:
dbv_oraStartStop stop <DDC>
2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command:
    RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’;
3) Retart standby database with command:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA

...

run the following command:

...

SQL>alter system set db_recovery_file_dest = 'xxxxx

...

' scope=both;
Primary12Database is still primary database. Primary database is not open.
Rollback action: Please start primary database:
dbv_oraStartStop start <DDC>
Alternatively this database may be rolled forward to a standby database.
Roll forward action:
1.    Shutdown database with command:
 dbv_oraStartStop stop <DDC>
2.    Startup instance NOMOUNT and replace controlfiles with a standby controlfile by running RMAN command:
RESTORE STANDBY CONTROLFILE FROM <filename>
3.    Update DDC file dbv_<DDC>.env and reverse settings with command:
dbv_oraStartStop update_ddc_file <DDC>
4.    Start standby database with command:
dbv_oraStartStop start <DDC>
Standby12Database has been converted to the primary database.
Roll forward action: 
1. Update DDC file dbv_<DDC>.env with command:
        dbv_oraStartStop update_ddc_file <DDC>
2. Add database tempfile [location of tempfile script will be shown] if needed.
3. Archives may need to be compressed/uncompressed (not essential).
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Alternatively this database may be rolled back to a standby database.
Rollback action:
1) Shutdown database with command:
dbv_oraStartStop stop <DDC>
2) Startup standby instance NOMOUNT and replace controlfiles with backed up controlfile <filename> using RMAN command:
    RMAN>RESTORE STANDBY CONTROLFILE FROM ‘filename’;
3) Retart standby database with command:
dbv_oraStartStop restart <DDC>
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary13Database has been converted to standby database.
Roll forward action: 
1. Update DDC file dbv_<DDC>.env with command:
dbv_oraStartStop update_ddc_file <DDC>
2. Start standby database with command:
dbv_oraStartStop start <DDC>
Standby13Database has been converted to the primary database.
Roll forward action: 
4. Update DDC file dbv_<DDC>.env with command:
        dbv_oraStartStop update_ddc_file <DDC>
5. Add database tempfile [location of tempfile script will be shown] if needed.
6. Archives may need to be compressed/uncompressed (not essential).
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA

...

run the following command

...

:

...

7. SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;

...

Primary14Database has been converted to standby database.
Roll forward action: 
1. Update DDC file dbv_<DDC>.env with command:
dbv_oraStartStop update_ddc_file <DDC>
 
Standby14Database has been converted to the primary database.
Roll forward action: 
1.    Update DDC file dbv_<DDC>.env with command:
        dbv_oraStartStop update_ddc_file <DDC>
2.    Add database tempfile [location of tempfile script will be shown] if needed.
3.    Archives may need to be compressed/uncompressed (not essential).
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary15Database has been converted to standby database.
Roll forward action: 
1.    Archives may need to be compressed/uncompressed (not essential).
Standby15Database has been converted to the primary database.
Roll forward action: 
1. Add database tempfile [location of tempfile script will be shown] if needed.
2. Archives may need to be compressed/uncompressed (not essential).
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary16Database has been converted to standby database.
Roll forward action: 
1. Archives may need to be compressed/uncompressed (not essential).
Standby16Database has been converted to the primary database.
Roll forward action: 
1. Archives may need to be compressed/uncompressed (not essential).
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary17Database has been converted to standby database.
Roll forward action: 
No further roll forward action required.
Standby17Database has been converted to the primary database.
Roll forward action: 
No further roll forward action required.
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA run the following command:
SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;
Primary18Database has been converted to standby database.
Roll forward action: 
No further roll forward action required.
Standby18Database has been converted to the primary database.
Roll forward action: 
No further roll forward action required.
Dbvisit has disabled Flash Recovery Area prior to Graceful Switchover. To enable FRA

...

run the following command:

...

SQL>alter system set db_recovery_file_dest = 'xxxxx' scope=both;

...

</body>

</html>

...

Note

1. The above steps are indicative only and may vary from version to version.

2. For Oracle 8. "SQL>" should be "SVRMGR>"

3. If using Dbvisit Standby to keep the new standby database in synch, please run Dbvisit Standby once manually with the -R option to synchronise on the new primary database.

Example: dbvisit -R <DDC>