Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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
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=3 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=3 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>15</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=31 style='height:31.0pt'>
<td height=31 class="xl82" width=325 style='height:31.0pt;width:325pt'>1.<font
class="font8">&nbsp;&nbsp;&nbsp; </font><font class="font5">Archives may need
to be compressed/uncompressed (not essential).</font></td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=6 height=136 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:136.0pt;border-top:none;width:148pt'>Standby</td>
<td rowspan=6 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>15</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=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>1. 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'>2.
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=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=15 style='height:15.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'>Primary</td>
<td rowspan=3 class="xl85" width=83 style='border-bottom:1.0pt solid black;
border-top:none;width:83pt'>16</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=31 style='height:31.0pt'>
<td height=31 class="xl84" width=325 style='height:31.0pt;width:325pt'>1.
Archives may need to be compressed/uncompressed (not essential).</td>
</tr>
<tr height=15 style='height:15.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'>16</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=30 style='height:30.0pt'>
<td height=30 class="xl80" width=325 style='height:30.0pt;width:325pt'>1.
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=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=3 height=46 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:46.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'>17</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=16 style='height:16.0pt'>
<td height=16 class="xl82" width=325 style='height:16.0pt;width:325pt'>No
further roll forward action required.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=5 height=91 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:91.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'>17</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'>No
further roll forward action required.</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=3 height=46 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:46.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'>18</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=16 style='height:16.0pt'>
<td height=16 class="xl82" width=325 style='height:16.0pt;width:325pt'>No
further roll forward action required.</td>
</tr>
<tr height=15 style='height:15.0pt'>
<td rowspan=5 height=91 class="xl85" width=148 style='border-bottom:1.0pt solid black;
height:91.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'>18</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'>No
further roll forward action required.</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>
</table>

</body>

</html> 

Excel
gridfalse
nameWorkbook15.xlsx
row229

...