5 D ata Guard Scenarios - Using Oracle Enterprise Manager< /title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <meta http-equiv="Content-Language" content="en" /> <me ta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta na me="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="doctitle" content="Oracle® Data Guard Broker 10g Rele ase 1 (10.1)" /> <meta name="partno" content="B10822-01" /> <meta name="docid" content="DGBKR" /> <link rel="Start" href="../../index .htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/doccd.css" title="Default" type="text/css" /> <link rel="Contents" href="toc.htm" tit le="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Glossary" href="glo ssary.htm" title="Glossary" type="text/html" /> <link rel="Prev" href="siteresource.htm" title="Previous" type="text/html" /> <link r el="Next" href="cli.htm" title="Next" type="text/html" /> <link rel="alternate" href="../b10822.pdf" title="PDF version" type="applic ation/pdf" /> </head> <body> <div class="header"> <p><a name="top" id="top" href="#BEGIN">Skip Headers</a></p> <table summary="" cell spacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><font color="#330099" face="Helvetica, Arial, sans-serif "><strong>Oracle® Data Guard Broker<br /> 10<i>g</i> Release 1 (10.1)</strong><br /> Part Number B10822-01</font></td> <td valig n="bottom" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a href ="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0" /><br /> <font size="-2">Home </font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt="Go to Book List" border="0" /><br /> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img sr c="../../dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0" /><br /> <font size="-2">Contents</font></a></td> <td al ign="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0" /><br /> <font size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs/m ix.gif" alt="Go to Master Index" border="0" /><br /> <font size="-2">Master Index</font></a></td> <td align="center" valign="top "><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0" /><br /> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table> <hr /> <table summary="layout table" cellspacing="0" cellpadd ing="0" width="100%"> <tr> <td align="left" valign="top"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="90"> <tr> <td align="center" valign="top"><a href="siteresource.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previ ous page" border="0" /><br /> <font size="-2">Previous</font></a></td> <td align="center" valign="top"><a href="cli.htm"><img src=".. /../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0" /><br /> <font size="-2">Next</font></a></td></tr></table></td> <td ali gn="right" valign="top"><a href="../b10822.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN" id="BEGIN"></a> </div> <div class="IND"> <script type="text/javascript" xml:space="preserve">  </script><script type="text/javascript" xml:space="preserve"> // <![CDATA[ function footdisplay(footnum,footnote) { va r msg = window.open('', 'NewWindow' + footnum, 'directories=no,height=120,location=no,menubar=no,resizable=yes,' + 's crollbars=yes,status=no,toolbar=no,width=598'); msg.document.open('text/html'); msg.document.write('<!DOCTYPE html '); ms g.document.write('PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" '); msg.document.write('"http://www.w3.org/TR/xhtml1/DTD/xhtml 1-transitional.dtd">'); msg.document.write('<html xmlns="http://www.w3.org/1999/xhtml" '); msg.document.write('xml:lang="en" lang="en"><head><title>'); msg.document.write('Footnote ' + footnum); msg.document.write('<\/title><meta http-equiv="Content- Type" '); msg.document.write('content="text/html; charset=utf-8" />'); msg.document.write('<meta http-equiv="Content-Script-T ype" '); msg.document.write('content="text/javascript" />'); msg.document.write('<style type="text/css"> <![CDATA[ '); ms g.document.write('h1 {text-align: center; font-size: 14pt;}'); msg.document.write('fieldset {border: none;}'); msg.document.w rite('form {text-align: center;}'); msg.document.write(' ]]\u003e <\/style>'); msg.document.write('<\/head><body><h1>Footnote ' + footnum + '<\/h1><p>'); msg.document.write(footnote); msg.document.write('<\/p><form action="" method="post"><fieldset>' ); msg.document.write('<input type="button" value="OK" '); msg.document.write('onclick="window.close();" />'); msg.docume nt.write('<\/fieldset><\/form><\/body><\/html>'); msg.document.close(); msg.focus(); } // ]]> </script><noscript> <p>The scri pt content on this page is for navigation purposes only and does not alter the content in any way.</p></noscript><a id="g1062576" nam e="g1062576"></a><a id="i1007917" name="i1007917"></a> <h1><font face="arial, helvetica, sans-serif" color="#330099"><span class="se cnum">5</span> D<a name="DGBKR400" id="DGBKR400"></a>ata Guard Scenarios - Using Oracle Enterprise Manager</font></h1> <p>This chapte r provides several scenarios that show how to use the Oracle Data Guard graphical user interface (GUI) to create, manage, and monitor a Data Guard configuration.</p> <p>This chapter contains the following scenarios:</p> <ul> <li type="disc"> <p><a href="#i1005615">S cenario 1: Starting the Data Guard GUI</a></p></li> <li type="disc"> <p><a href="#i1005702">Scenario 2: Creating a Configuration or A dding an Additional Standby Database</a></p></li> <li type="disc"> <p><a href="#i1025470">Scenario 3: Adding an Existing RAC Standby Database</a></p></li> <li type="disc"> <p><a href="#i1013645">Scenario 4: Performing Routine Maintenance</a></p></li> <li type="disc" > <p><a href="#i1006161">Scenario 5: Performing a Switchover Operation</a></p></li> <li type="disc"> <p><a href="#i1017859">Scenario 6: Performing a Failover Operation</a></p></li> <li type="disc"> <p><a href="#i1018803">Scenario 7: Monitoring a Data Guard Configura tion</a></p></li> <li type="disc"> <p><a href="#i1014496">Scenario 8: Using Metrics</a></p></li> <li type="disc"> <p><a href="#i10430 40">Scenario 9: Removing a Standby Database and Configuration</a></p></li></ul> <a id="i1005615" name="i1005615"></a> <div class="se ct1"><a id="sthref584" name="sthref584"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.1< /span> <a name="DGBKR405" id="DGBKR405"></a>Scenario 1: Starting the Data Guard GUI</font></h2> <p><a id="sthref585" name="sthref585" ></a><a id="sthref586" name="sthref586"></a><a id="sthref587" name="sthref587"></a>Start the Data Guard GUI through the Oracle Enterp rise Manager Grid Control using the following steps:</p> <ol type="1" start="1"> <li> <p>Click the <strong>Targets</strong> tab to go to the Targets page.</p></li> <li> <p>Click <strong>Databases</strong> to go to the Databases page.</p></li> <li> <p>On the Database s page, you see a listing of all discovered databases including the primary database (in this scenario the primary database is called North_Sales). Click the primary database to go to the primary database home page.</p></li> <li> <p>Click <strong>Administration</str ong>.</p></li> <li> <p>Under the High Availability section, click <strong>Data Guard</strong> and log in.</p> <div class="inftblnote" ><br /> <table class="note" summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="lt r" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face ="arial, helvetica, sans-serif"><strong>Note:</strong></font></p> If you log in as a user with SYSDBA privileges, you will have acces s to all Data Guard functionality, including all monitoring and management features. If you log in as a non-SYSDBA user, you will hav e access to monitoring functions only; features such as standby creation, switchover, and failover will not be available.</td></tr></ tbody></table> <br /></div>  </li></ol> <p>If the primary database is not already in a broker configuration , clicking Data Guard in Step 5 will go to the page shown in <a href="#i1033319">Figure 5-1</a>. From this page you can create a brok er configuration and add a standby database.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="notealso" summ ary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="h sides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif"><s trong>See Also:</strong></font></p> <a href="#i1005702">Section 5.2, "Scenario 2: Creating a Configuration or Adding an Additional St andby Database"</a></td></tr></tbody></table> <br /></div>  </div> <div class="figure"><a id="i1033319" name="i1033319"></a><a id="sthref588" name="sthref588"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-1 Cre ate a Broker Configuration</font></em></strong></p> <img src="./dboverviewemptypage.gif" alt="Description of dboverviewemptypage.gif follows" /><br /> <a id="sthref589" name="sthref589" href="./img_text/dboverviewemptypage.htm">Description of the illustration dbover viewemptypage.gif</a><br /> <br /></div>  <p>If the primary database is already part of a broker configuration , clicking Data Guard in Step 5 will go to the Data Guard Overview page as shown in <a href="#i1052552">Figure 5-2</a>.</p> <div clas s="figure"><a id="i1052552" name="i1052552"></a><a id="sthref590" name="sthref590"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-2 Data Guard Overview Page</font></em></strong></p> <img src="./dgoverview.gif" alt="Description of dgoverview. gif follows" /><br /> <a id="sthref591" name="sthref591" href="./img_text/dgoverview.htm">Description of the illustration dgoverview. gif</a><br /> <br /></div>  <p>On the Data Guard Overview page, you can:</p> <ul> <li type="disc"> <p>Edit the protection mode—click <strong>Protection Mode</strong> in the Data Guard Overview section to view the current protection mode setting and, if necessary, change the protection mode.</p></li> <li type="disc"> <p>View a summary of standby progress—this c hart shows the amount of data that each standby database has not yet received and applied.</p></li> <li type="disc"> <p>Retrieve info rmation about the primary database—click <strong>Name</strong>, <strong>Host</strong>, <strong>Status</strong>, <strong>Curren t Log</strong>, or <strong>Related Link (Edit)</strong> to view pertinent information about the primary database.</p> <p>If you click <strong>Status</strong> or <strong>Edit</strong>, you are taken to the Edit Properties page where you can view and change the curren t state or properties of the primary database.</p></li> <li type="disc"> <p>View or change information on the standby databases:</p> <ul> <li type="circle"> <p>Add a standby database to the broker configuration—click <strong>Add Standby Database</strong> to a dd a physical or logical standby database.</p></li> <li type="circle"> <p>Change the state or properties—click <strong>Edit</s trong> to go to the Edit Properties page to view and change the current state or properties of the standby database.</p></li> <li typ e="circle"> <p>Discontinue Data Guard broker control—click <strong>Remove</strong> to remove the selected standby database fro m Data Guard broker control.</p></li> <li type="circle"> <p>Switch the role from standby to primary—click <strong>Switchover</ strong> to switch the database roles from standby to primary.</p></li> <li type="circle"> <p>Transition the standby database to the r ole of primary database— click <strong>Failover</strong> when a catastrophic failure occurs on the primary database, and there is no possibility of recovering the primary database in a timely manner. The target standby database assumes the primary role, and t he failed primary database is disabled by the broker. See <a href="siteresource.htm#i1010215">Section 4.2.5</a> for steps to re-creat e the failed primary database as a standby database to the new primary database.</p></li></ul></li> <li type="disc"> <p>View performa nce information for the configuration and status of online redo log files for each standby database:</p> <ul> <li type="circle"> <p>C lick <strong>Performance Overview</strong> to view information about data archived and applied, a summary of standby progress, and a summary of log services.</p></li> <li type="circle"> <p>Click <strong>Log File Details</strong> to view the status of online redo log files that were generated on the primary database but not received by the standby, and for online redo log files that were received but not applied to the standby database</p></li></ul></li> <li type="disc"> <p>Perform additional administrative activities:</p> <ul> <li type="circle"> <p>Click <strong>Verify</strong> to check the protection mode and properties, confirm that standby redo log files are present, and verify log switch.</p></li> <li type="circle"> <p>Click <strong>Remove Data Guard Configuration</strong> to remove the broker configuration from Data Guard broker control.</p></li></ul></li> <li type="disc"> <p>Search for information about any Data Guard GUI or Enterprise Manager topic—<a id="sthref592" name="sthref592"></a>Click <strong>Help</strong> to display the Welco me to Oracle Data Guard GUI help topic. Once in the help system, you can use the Contents page or Search page to locate help topics o f interest.</p></li></ul></div>  <a id="i1005702" name="i1005702"></a> <div class="sect1"><a id="sthref593" na me="sthref593"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.2</span> <a name="DGBKR410" id="DGBKR410"></a><a id="sthref594" name="sthref594"></a><a id="sthref595" name="sthref595"></a><a id="sthref596" name="sthref596">< /a><a id="sthref597" name="sthref597"></a>Scenario 2: Creating a Configuration or Adding an Additional Standby Database</font></h2> < p>Creating<a id="sthref598" name="sthref598"></a><a id="sthref599" name="sthref599"></a><a id="sthref600" name="sthref600"></a><a id= "sthref601" name="sthref601"></a> a broker configuration is the first thing you must do before you can manage and monitor the databas es. The Data Guard GUI provides the <a id="sthref602" name="sthref602"></a><a id="sthref603" name="sthref603"></a><a id="sthref604" n ame="sthref604"></a>Add Standby Database wizard to create a broker configuration that includes a primary database and one standby dat abase. (You can use the Add Standby Database wizard later to add more databases. See <a href="#i1025470">Section 5.3</a>.) To start t he Add Standby Database wizard, click <strong>Add Standby Database</strong> as shown in <a href="#i1030562">Figure 5-3</a>.</p> <div class="figure"><a id="i1030562" name="i1030562"></a><a id="sthref605" name="sthref605"></a> <p><strong><em><font face="arial, helvet ica, sans-serif">Figure 5-3 Create a Configuration</font></em></strong></p> <img src="./dboverviewemptypage.gif" alt="Description of dboverviewemptypage.gif follows" /><br /> <a id="sthref606" name="sthref606" href="./img_text/dboverviewemptypage.htm">Description of the illustration dboverviewemptypage.gif</a><br /> <br /></div>  <p>After clicking <strong>Add Standby Databa se</strong>, select one of the three available options:</p> <ul> <li type="disc"> <p>Create a new physical standby database (single-i nstance only)</p></li> <li type="disc"> <p>Create a new logical standby database (single-instance only)</p></li> <li type="disc"> <p> Add an existing (physical or logical) standby database (single-instance or RAC)</p></li></ul> <p>You will need to connect to the prim ary database using SYSDBA credentials, if you haven't already.</p> <div align="center"> <div class="inftblnotealso"><br /> <table cla ss="notealso" summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" wi dth="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helveti ca, sans-serif"><strong>See Also:</strong></font></p> <em><a class="xlinkSRC SBYDB01700" href="../../server$101/b10823/rac_support.ht m#SBYDB01700">Oracle Data Guard Concepts and Administration</a></em> for the steps about how to create a RAC standby database</td></t r></tbody></table> <br /></div>  </div> <p><a href="#i1049164">Figure 5-4</a> show the introductory pag e of the create configuration process.</p> <div class="figure"><a id="i1049164" name="i1049164"></a><a id="sthref607" name="sthref607 "></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-4 Add Standby Database Wizard - Introductory Page</font></e m></strong></p> <img src="./addstandbyintro.gif" alt="Description of addstandbyintro.gif follows" /><br /> <a id="sthref608" name="st href608" href="./img_text/addstandbyintro.htm">Description of the illustration addstandbyintro.gif</a><br /> <br /></div>  <p>The Add Standby Database wizard takes you through the following steps:</p> <ol type="1" start="1"> <li> <p><a href="# i1036637">Determine the backup type.</a></p></li> <li> <p><a href="#BGBCCGAJ">Set up the backup options.</a></p></li> <li> <p><a href ="#BGBJHDIH">Select the Oracle home in which to create the standby database.</a></p></li> <li> <p><a href="#BGBBJFCA">Set up the loca tion for standby database files.</a></p></li> <li> <p><a href="#BGBDIJIC">Provide standby database configuration parameters.</a></p>< /li> <li> <p><a href="#BGBJEHBF">Review the information before clicking Finish.</a></p></li></ol> <p>The following steps create a bro ker configuration and create a new physical standby database. It shows how the wizard takes you through additional steps to select th e Oracle home for the database and to copy datafiles to the standby database.</p> <a id="i1036637" name="i1036637"></a><br /> <p><str ong><font face="arial, helvetica, sans-serif">Step 1 Determine the backup type.</font></strong></p> <p>The Data Guard GUI uses Oracle Recovery Manager (RMAN) to create a single-instance standby database from a new or existing backup of the primary database. You can select one of two backup operations to use for the standby database creation:</p> <ul> <li type="disc"> <p>Perform a live backup of t he primary database</p></li> <li type="disc"> <p>Use an existing backup of the primary database</p></li></ul> <p><a href="#i1005839"> Figure 5-5</a> shows Step 1 of 6 of the configuration process if you are adding a physical standby database.</p> <div class="figure"> <a id="i1005839" name="i1005839"></a><a id="sthref609" name="sthref609"></a> <p><strong><em><font face="arial, helvetica, sans-serif ">Figure 5-5 Add Standby Database Wizard - Backup Type (Physical Standby Database)</font></em></strong></p> <img src="./addphy_step1_ a.gif" alt="Description of addphy_step1_a.gif follows" /><br /> <a id="sthref610" name="sthref610" href="./img_text/addphy_step1_a.ht m">Description of the illustration addphy_step1_a.gif</a><br /> <br /></div>  <p>You can click <strong>Restart Add Standby Database</strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p><a href="#i1049481">Figure 5-6</a> shows additional screen content that appears if you are adding a logical standby da tabase.</p> <div class="figure"><a id="i1049481" name="i1049481"></a><a id="sthref611" name="sthref611"></a> <p><strong><em><font fa ce="arial, helvetica, sans-serif">Figure 5-6 Add Standby Database Wizard - Backup Type (Logical Standby Database)</font></em></strong ></p> <img src="./addlogstep1b.gif" alt="Description of addlogstep1b.gif follows" /><br /> <a id="sthref612" name="sthref612" href=". /img_text/addlogstep1b.htm">Description of the illustration addlogstep1b.gif</a><br /> <br /></div>  <a id="BG BCCGAJ" name="BGBCCGAJ"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 2 Set up the backup options.</font></strong>< /p> <p>A working directory is needed to store the primary database backup files. It can optionally be retained and used to create add itional standby databases in the future. Specify a location on the primary host in which the working directory can be created.</p> <p >Primary host credentials are required for this step. Enter the credentials of the owner of the primary database Oracle server instal lation. These credentials can be saved by checking the box marked <strong>Save as Preferred Credential</strong>.</p> <p>You can click <strong>Restart Add Standby Database</strong> to terminate the current process and begin again at the introductory page of the Add S tandby Database wizard.</p> <p><a href="#i1033957">Figure 5-7</a> shows Step 2 of 6 of the configuration process.</p> <div class="fig ure"><a id="i1033957" name="i1033957"></a><a id="sthref613" name="sthref613"></a> <p><strong><em><font face="arial, helvetica, sans- serif">Figure 5-7 Add Standby Database Wizard - Backup Options</font></em></strong></p> <img src="./addphysstep2.gif" alt="Descriptio n of addphysstep2.gif follows" /><br /> <a id="sthref614" name="sthref614" href="./img_text/addphysstep2.htm">Description of the illu stration addphysstep2.gif</a><br /> <br /></div>  <a id="BGBJHDIH" name="BGBJHDIH"></a> <p><strong><font face ="arial, helvetica, sans-serif">Step 3 Select the Oracle home in which to create the standby database.</font></strong></p> <p>The sta ndby database can be created in any Oracle home that was discovered by Oracle Enterprise Manager. Only Oracle homes on hosts that mat ch the operating system of the primary host are shown. You must select a discovered Oracle home and provide a unique instance name fo r the standby database. Standby host credentials are required to continue.</p> <p><a href="#i1016063">Figure 5-8</a> shows Step 3 of 6 of the configuration process.</p> <div class="figure"><a id="i1016063" name="i1016063"></a><a id="sthref615" name="sthref615"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-8 Add Standby Database Wizard - Standby Oracle Home</font></em></s trong></p> <img src="./addphysstep3_a.gif" alt="Description of addphysstep3_a.gif follows" /><br /> <a id="sthref616" name="sthref616 " href="./img_text/addphysstep3_a.htm">Description of the illustration addphysstep3_a.gif</a><br /> <br /></div>  <a id="BGBBJFCA" name="BGBBJFCA"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 4 Set up the location for standb y database files.</font></strong></p> <p>Part of the create broker configuration process involves making the datafiles for the primar y database available to the standby host. You have the option of customizing the location for the standby database files. Standby hos t credentials are required to continue. The following list describes your options:</p> <ul> <li type="disc"> <p>Specify the backup fi le access method</p> <p>Choose the method by which you want to make the primary database backup files accessible to the standby host. The two options are:</p> <ul> <li type="circle"> <p>Transfer files from the primary host working directory to a standby host working directory</p></li> <li type="circle"> <p>Directly access the primary host working directory location from the standby host using a n etwork path name</p></li></ul></li> <li type="disc"> <p>Specify the standby database file location</p> <p>Choose the locations for th e standby database files. You have two options:</p> <ul> <li type="circle"> <p>Convert to Oracle OFA (Optimal Flexible Architecture)< /p></li> <li type="circle"> <p>Keep file names and locations the same as the primary database</p></li></ul></li> <li type="disc"> <p> Specify the network configuration file location</p> <p>Data Guard will add configuration information for the standby database to the network configuration files (listener.ora and tnsnames.ora) in the specified directory on the standby host.</p></li></ul> <p>You can click <strong>Restart Add Standby Database</strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p><a href="#BGBGCGCE">Figure 5-9</a> shows Step 4 of 6 of the configuration process.</p> <div class ="figure"><a id="BGBGCGCE" name="BGBGCGCE"></a><a id="sthref617" name="sthref617"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-9 Add Standby Database Wizard - File Locations</font></em></strong></p> <img src="./addphysstep4.gif" alt="Descr iption of addphysstep4.gif follows" /><br /> <a id="sthref618" name="sthref618" href="./img_text/addphysstep4.htm">Description of the illustration addphysstep4.gif</a><br /> <br /></div>  <a id="BGBDIJIC" name="BGBDIJIC"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 5 Provide standby database configuration parameters.</font></strong></p> <p>Standby databas e configuration parameters must be set. These parameters include the instance name (SID), database unique name, target name, and stan dby archive location. The standby archive location can be a regular directory or a flash recovery area. The default values are based on corresponding primary database settings.</p> <p>You can click <strong>Restart Add Standby Database</strong> to terminate the curre nt process and begin again at the introductory page of the Add Standby Database wizard.</p> <p><a href="#i1005919">Figure 5-10</a> sh ows Step 5 of 6 of the configuration process.</p> <div class="figure"><a id="i1005919" name="i1005919"></a><a id="sthref619" name="st href619"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-10 Add Standby Database Wizard - Standby Configurati on</font></em></strong></p> <img src="./addphysstep5_a.gif" alt="Description of addphysstep5_a.gif follows" /><br /> <a id="sthref620 " name="sthref620" href="./img_text/addphysstep5_a.htm">Description of the illustration addphysstep5_a.gif</a><br /> <br /></div> <!- - class="figure" --> <a id="BGBJEHBF" name="BGBJEHBF"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 6 Review the in formation before clicking Finish.</font></strong></p> <p>The Add Standby Database wizard allows one last review of the data you input for the configuration and standby database. Click <strong>Finish</strong> when you are certain all of the information is correct.</p > <p>You can click <strong>Restart Add Standby Database</strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p><a href="#i1036626">Figure 5-11</a> shows Step 6 of 6 of the configuration process.< /p> <div class="figure"><a id="i1036626" name="i1036626"></a><a id="sthref621" name="sthref621"></a> <p><strong><em><font face="aria l, helvetica, sans-serif">Figure 5-11 Add Standby Database Wizard - Review</font></em></strong></p> <img src="./addphysstep6_a.gif" a lt="Description of addphysstep6_a.gif follows" /><br /> <a id="sthref622" name="sthref622" href="./img_text/addphysstep6_a.htm">Descr iption of the illustration addphysstep6_a.gif</a><br /> <br /></div>  <p>By clicking <strong>Standby Database File Locations</strong>, you can see additional information about all the standby database file locations.</p> <p>Once you click <str ong>Finish</strong>, the standby database creation process runs as an Oracle Enterprise Manager job. You can cancel the standby creat ion at any point before the job submission. <a href="#i1035392">Figure 5-12</a> shows the standby database creation process.</p> <div class="figure"><a id="i1035392" name="i1035392"></a><a id="sthref623" name="sthref623"></a> <p><strong><em><font face="arial, helve tica, sans-serif">Figure 5-12 Add Standby Database Wizard - Processing</font></em></strong></p> <img src="./addphysprocess.gif" alt=" Description of addphysprocess.gif follows" /><br /> <a id="sthref624" name="sthref624" href="./img_text/addphysprocess.htm">Descripti on of the illustration addphysprocess.gif</a><br /> <br /></div>  <p>After the job is submitted, you will be r eturned to the Data Guard Overview page. In the Status column of the Standby Databases table, you will see <em>Creation in progress</ em> listed. If you click that link, you can monitor the progress of the standby database creation. <a href="#i1036630">Figure 5-13</a > shows the Data Guard Overview page with this link.</p> <p>To add additional standby databases after the initial creation of the con figuration, click <strong>Add Standby Database</strong> to run the Add Standby Database wizard again.</p> <div class="figure"><a id=" i1036630" name="i1036630"></a><a id="sthref625" name="sthref625"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figur e 5-13 Data Guard Overview Page - Creation in Progress</font></em></strong></p> <img src="./dgoverviewprogress.gif" alt="Description of dgoverviewprogress.gif follows" /><br /> <a id="sthref626" name="sthref626" href="./img_text/dgoverviewprogress.htm">Description o f the illustration dgoverviewprogress.gif</a><br /> <br /></div>  </div>  <a id="i102547 0" name="i1025470"></a> <div class="sect1"><a id="sthref627" name="sthref627"></a> <h2><font face="arial, helvetica, sans-serif" co lor="#330099"><span class="secnum">5.3</span> <a name="DGBKR415" id="DGBKR415"></a>Scenario 3: Adding an Existing RAC Standby Databas e</font></h2> <p>Although the Add Standby Database wizard will not create a RAC standby database, you can <a id="sthref628" name="sth ref628"></a><a id="sthref629" name="sthref629"></a><a id="sthref630" name="sthref630"></a>add <a id="sthref631" name="sthref631"></a> an existing RAC standby database into a Data Guard configuration. Click <strong>Add Standby Database</strong> to run the Add Standby Database wizard and select <strong>Add an existing standby database</strong>.</p> <p><a href="#i1049421">Figure 5-14</a> shows the Ad d Standby Database introductory page.</p> <div class="figure"><a id="i1049421" name="i1049421"></a><a id="sthref632" name="sthref632" ></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-14 Adding an Existing RAC Standby Database to the Data Guard Configuration</font></em></strong></p> <img src="./add_rac_intro.gif" alt="Description of add_rac_intro.gif follows" /><br /> <a id= "sthref633" name="sthref633" href="./img_text/add_rac_intro.htm">Description of the illustration add_rac_intro.gif</a><br /> <br /></ div>  <p>The Add Standby Database wizard takes you through the following steps:</p> <ol type="1" start="1"> <l i> <p><a href="#i1049614">Select an existing standby database.</a></p></li> <li> <p><a href="#BGBDJHBJ">Set the standby archive locat ion setting.</a></p></li> <li> <p><a href="#BGBCAFAC">Review the configuration settings.</a></p></li></ol> <a id="i1049614" name="i10 49614"></a><br /> <p><strong><font face="arial, helvetica, sans-serif">Step 1 Select an existing standby database.</font></strong></p > <p>In this step, select the RAC standby database you want to add to the configuration. All discovered databases in your environment (both RAC and non-RAC databases) will be shown in the list. In the example shown in <a href="#i1049425">Figure 5-15</a> (Step 1 of 3 ), one of the databases in the list (RAC10<em>g</em>) is a RAC standby database.</p> <p>You can click <strong>Restart Add Standby Dat abase</strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p>I f you wish to continue, click <strong>Next</strong>.</p> <div class="figure"><a id="i1049425" name="i1049425"></a><a id="sthref634" n ame="sthref634"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-15 Select an Existing Standby Database</font> </em></strong></p> <img src="./add_rac_step1.gif" alt="Description of add_rac_step1.gif follows" /><br /> <a id="sthref635" name="sth ref635" href="./img_text/add_rac_step1.htm">Description of the illustration add_rac_step1.gif</a><br /> <br /></div>  <a id="BGBDJHBJ" name="BGBDJHBJ"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 2 Set the standby archive lo cation setting.</font></strong></p> <p>You can optionally change the Standby Archive Location setting of the existing standby cluster database, as shown in <a href="#i1049433">Figure 5-16</a> (Step 2 of 3).</p> <p>You can click <strong>Restart Add Standby Database</ strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p>If you w ish to continue, click <strong>Next</strong>.</p> <div class="figure"><a id="i1049433" name="i1049433"></a><a id="sthref636" name="st href636"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-16 Add Standby Database: Standby Configuration</font ></em></strong></p> <img src="./add_rac_step2.gif" alt="Description of add_rac_step2.gif follows" /><br /> <a id="sthref637" name="st href637" href="./img_text/add_rac_step2.htm">Description of the illustration add_rac_step2.gif</a><br /> <br /></div>  <a id="BGBCAFAC" name="BGBCAFAC"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 3 Review the configuration settings.</font></strong></p> <p>Review the data for the configuration and standby database, as shown in <a href="#i1049441">Figure 5 -17</a> (Step 3 of 3).</p> <p>You can click <strong>Restart Add Standby Database</strong> to terminate the current process and begin again at the introductory page of the Add Standby Database wizard.</p> <p>If you wish to complete the operation, click <strong>Finish </strong>.</p> <div class="figure"><a id="i1049441" name="i1049441"></a><a id="sthref638" name="sthref638"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-17 Add Standby Database: Review</font></em></strong></p> <img src="./add_rac_step3.gif" alt="Description of add_rac_step3.gif follows" /><br /> <a id="sthref639" name="sthref639" href="./img_text/add_rac_step3.htm">Descr iption of the illustration add_rac_step3.gif</a><br /> <br /></div>  </div>  <a id="i101 3645" name="i1013645"></a> <div class="sect1"><a id="sthref640" name="sthref640"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.4</span> <a name="DGBKR420" id="DGBKR420"></a>Scenario 4: Performing Routine Maintenance</fon t></h2> <p><a id="sthref641" name="sthref641"></a>The Data Guard GUI can help simplify some of the routine maintenance tasks you must perform in the configuration. The following examples, provided in the following sections, show:</p> <ul> <li type="disc"> <p><a href ="#i1006103">Changing the State of a Database</a></p></li> <li type="disc"> <p><a href="#i1049627">Changing the Properties of a Datab ase</a></p></li> <li type="disc"> <p><a href="#i1023502">Changing the Database Protection Mode</a></p></li></ul> <a id="i1006103" nam e="i1006103"></a> <div class="sect2"><a id="sthref642" name="sthref642"></a> <h3><font face="arial, helvetica, sans-serif" color="# 330099"><span class="secnum">5.4.1</span> <a name="DGBKR425" id="DGBKR425"></a>Changing the State of a Database</font></h3> <p>This s ection describes how to set the standby database to Log Apply Off.</p> <p>To <a id="sthref643" name="sthref643"></a><a id="sthref644" name="sthref644"></a><a id="sthref645" name="sthref645"></a><a id="sthref646" name="sthref646"></a>change the state of the standby d atabase to Log Apply Off, follow these steps:</p> <ol type="1" start="1"> <li> <p>From the Data Guard Overview page, select the stand by database you want to change to the Log Apply Off state.</p></li> <li> <p>Click <strong>Edit</strong> to go to the Edit Properties page.</p></li> <li> <p>Select <strong>Log Apply Off</strong>.</p></li> <li> <p>Click <strong>Apply</strong>.</p></li> <li> <p>When th e process completes, a message indicating success is returned.</p></li></ol> <p><a href="#i1038913">Figure 5-18</a> shows the Edit Pr operties page from where you can change the state of a database.</p> <div class="figure"><a id="i1038913" name="i1038913"></a><a id=" sthref647" name="sthref647"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-18 Changing the State or Properti es of a Database</font></em></strong></p> <img src="./editstandbystateoffline.gif" alt="Description of editstandbystateoffline.gif fo llows" /><br /> <a id="sthref648" name="sthref648" href="./img_text/editstandbystateoffline.htm">Description of the illustration edit standbystateoffline.gif</a><br /> <br /></div>  <p>When you change the state of the standby database to Log Ap ply Off, it stops log apply services from applying the archived redo log files to the standby database. However, log transport servic es are unaffected.</p> <p>After completing your maintenance tasks, you can follow the same sequence of steps to bring the database on line again.</p></div>  <a id="i1049627" name="i1049627"></a> <div class="sect2"><a id="sthref649" name="sthref 649"></a> <h3><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.4.2</span> <a name="DGBKR430" id="DGB KR430"></a>Changing the Properties of a Database</font></h3> <p>The Data Guard GUI divides the database <a id="sthref650" name="sthre f650"></a><a id="sthref651" name="sthref651"></a><a id="sthref652" name="sthref652"></a>properties into primary, standby, and common properties.</p> <p>To view or change properties:</p> <ol type="1" start="1"> <li> <p>Click either <strong>Edit</strong> from the Prim ary Database section or click <strong>Edit</strong> from the Standby Databases section of the Data Guard Overview page.</p></li> <li> <p>Click one of the following:</p> <ul> <li type="disc"> <p>Standby Role Properties</p></li> <li type="disc"> <p>Common Properties</ p></li></ul></li> <li> <p>Make the appropriate change and click <strong>Apply</strong>.</p></li> <li> <p>When the process completes, a message indicating success is returned.</p></li></ol> <p><a href="#i1038913">Figure 5-18</a> shows the Edit Properties page from wh ere you can alter a property of a database.</p> <p><a href="#i1039029">Figure 5-19</a> shows properties specific to the standby datab ase.</p> <div class="figure"><a id="i1039029" name="i1039029"></a><a id="sthref653" name="sthref653"></a> <p><strong><em><font face= "arial, helvetica, sans-serif">Figure 5-19 Standby Role Properties</font></em></strong></p> <img src="./editstandby-standby.gif" alt= "Description of editstandby-standby.gif follows" /><br /> <a id="sthref654" name="sthref654" href="./img_text/editstandby-standby.htm ">Description of the illustration editstandby-standby.gif</a><br /> <br /></div>  <p>By clicking <strong>Show Advanced Properties</strong>, you can view additional properties specific to the standby database, as shown in <a href="#i1039033">Fi gure 5-20</a>.</p> <div class="figure"><a id="i1039033" name="i1039033"></a><a id="sthref655" name="sthref655"></a> <p><strong><em>< font face="arial, helvetica, sans-serif">Figure 5-20 Standby Advanced Properties</font></em></strong></p> <img src="./standby_role_pr op.gif" alt="Description of standby_role_prop.gif follows" /><br /> <a id="sthref656" name="sthref656" href="./img_text/standby_role_ prop.htm">Description of the illustration standby_role_prop.gif</a><br /> <br /></div>  <p><a href="#CBBDICDA" >Figure 5-21</a> shows properties common to both the primary database and the standby database.</p> <div class="figure"><a id="CBBDIC DA" name="CBBDICDA"></a><a id="sthref657" name="sthref657"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-21 Common Properties</font></em></strong></p> <img src="./editstandby-common.gif" alt="Description of editstandby-common.gif follows" / ><br /> <a id="sthref658" name="sthref658" href="./img_text/editstandby-common.htm">Description of the illustration editstandby-commo n.gif</a><br /> <br /></div>  </div>  <a id="i1023502" name="i1023502"></a> <div class= "sect2"><a id="sthref659" name="sthref659"></a> <h3><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5 .4.3</span> <a name="DGBKR435" id="DGBKR435"></a>Changing the Database Protection Mode</font></h3> <p>You can <a id="sthref660" name= "sthref660"></a><a id="sthref661" name="sthref661"></a><a id="sthref662" name="sthref662"></a>change the broker configuration's overa ll protection mode with the Data Guard GUI.</p> <p>When the configuration was first created it was placed in the maximum performance mode by default. This section describes the process for upgrading to the maximum protection mode. The maximum protection mode guarant ees that no data loss will occur if the primary database fails.</p> <p>To set the maximum protection mode:</p> <ol type="1" start="1" > <li> <p>Click <strong>Maximum Performance</strong> under the Overview section on the Data Guard Overview page.</p></li> <li> <p>Sel ect <strong>Maximum Protection</strong> and click <strong>Continue</strong>.</p> <p><a href="#i1040389">Figure 5-22</a> shows the Edi t Protection Mode page.</p> <div class="figure"><a id="i1040389" name="i1040389"></a><a id="sthref663" name="sthref663"></a> <p><str ong><em><font face="arial, helvetica, sans-serif">Figure 5-22 Edit Protection Mode Page</font></em></strong></p> <img src="./editprot -mode.gif" alt="Description of editprot-mode.gif follows" /><br /> <a id="sthref664" name="sthref664" href="./img_text/editprot-mode. htm">Description of the illustration editprot-mode.gif</a><br /> <br /></div>  </li> <li> <p>Select one or mor e of the standby databases listed in <a href="#i1049643">Figure 5-23</a> that you want to support the maximum protection mode. The lo g transport mode (and <code>LogXptMode</code> property) will automatically be set to <code>SYNC</code> for the primary database and t he selected standby databases.</p> <p>Data Guard broker automatically determines the correct number and size of standby redo log file s needed for all databases in the configuration and adds those log files using the directory locations you specify. Click <strong>OK< /strong> to continue.</p> <div class="figure"><a id="i1049643" name="i1049643"></a><a id="sthref665" name="sthref665"></a> <p><stron g><em><font face="arial, helvetica, sans-serif">Figure 5-23 Edit Protection Mode - Standby Databases and Online Redo Log Files</font> </em></strong></p> <img src="./editprot-standbys_srls.gif" alt="Description of editprot-standbys_srls.gif follows" /><br /> <a id="st href666" name="sthref666" href="./img_text/editprot-standbys_srls.htm">Description of the illustration editprot-standbys_srls.gif</a> <br /> <br /></div>  </li> <li> <p>Confirm that you want to change the protection mode. Click <strong>Yes</str ong> to continue or <strong>No</strong> to cancel. <a href="#CBBBAADC">Figure 5-24</a> shows this confirmation page.</p> <div class=" figure"><a id="CBBBAADC" name="CBBBAADC"></a><a id="sthref667" name="sthref667"></a> <p><strong><em><font face="arial, helvetica, sa ns-serif">Figure 5-24 Edit Protection Mode - Confirmation</font></em></strong></p> <img src="./editprot-conf.gif" alt="Description of editprot-conf.gif follows" /><br /> <a id="sthref668" name="sthref668" href="./img_text/editprot-conf.htm">Description of the illust ration editprot-conf.gif</a><br /> <br /></div>  </li> <li> <p>Once the protection mode is successfully update d, the Data Guard Overview page is displayed as shown in <a href="#i1040373">Figure 5-25</a>.</p> <div class="figure"><a id="i1040373 " name="i1040373"></a><a id="sthref669" name="sthref669"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-25 P rotection Mode Successfully Changed</font></em></strong></p> <img src="./editprot-after.gif" alt="Description of editprot-after.gif f ollows" /><br /> <a id="sthref670" name="sthref670" href="./img_text/editprot-after.htm">Description of the illustration editprot-aft er.gif</a><br /> <br /></div>  </li></ol></div>  </div>  <a id="i1 006161" name="i1006161"></a> <div class="sect1"><a id="sthref671" name="sthref671"></a> <h2><font face="arial, helvetica, sans-seri f" color="#330099"><span class="secnum">5.5</span> <a name="DGBKR440" id="DGBKR440"></a>Scenario 5: Performing a Switchover Operation </font></h2> <p>There may be occasions when you might want to perform a switchover between the primary database and standby databases . This scenario steps you through the process of using the <a id="sthref672" name="sthref672"></a><a id="sthref673" name="sthref673"> </a><a id="sthref674" name="sthref674"></a>switchover operation to switch roles between the primary database and a standby database.< /p> <p>To execute a switchover, perform the following steps:</p> <ol type="1" start="1"> <li> <p>Select the standby database that you want to become the primary database.</p></li> <li> <p>Click <strong>Switchover</strong>.</p></li> <li> <p>Click <strong>Yes</strong> to continue with the switchover. Click <strong>No</strong> to cancel.</p></li></ol> <p><a href="#CBBCEAEI">Figure 5-26</a> shows the Switchover Confirmation page.</p> <div class="figure"><a id="CBBCEAEI" name="CBBCEAEI"></a><a id="sthref675" name="sthref675"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-26 Switchover Operation</font></em></strong></p> <img src="./so-con f.gif" alt="Description of so-conf.gif follows" /><br /> <a id="sthref676" name="sthref676" href="./img_text/so-conf.htm">Description of the illustration so-conf.gif</a><br /> <br /></div>  <p>The Switchover operation performs the following st eps:</p> <ol type="1" start="1"> <li> <p>Ensures that the primary database and standby database are not currently in an error status condition and verifies that broker management of the primary database is enabled and online.</p></li> <li> <p>If the switchover targe t is a physical standby database, you can view any active user sessions connected to the primary using the Browse Primary Database Se ssions link. These sessions will be closed automatically during the switchover.</p></li> <li> <p>Performs the switchover by first cha nging the primary database to the standby role, and then the standby database to the primary role, displaying a progress indicator as the switchover progresses.</p></li> <li> <p>If the switchover target is a physical standby database, both it and the primary databas e will be restarted.</p></li></ol> <p><a href="#CBBHFHDA">Figure 5-27</a> shows the Processing page during the switchover.</p> <div c lass="figure"><a id="CBBHFHDA" name="CBBHFHDA"></a><a id="sthref677" name="sthref677"></a> <p><strong><em><font face="arial, helveti ca, sans-serif">Figure 5-27 Processing Page During Switchover</font></em></strong></p> <img src="./switch_process.gif" alt="Descripti on of switch_process.gif follows" /><br /> <a id="sthref678" name="sthref678" href="./img_text/switch_process.htm">Description of the illustration switch_process.gif</a><br /> <br /></div>  <p><a href="#CBBCDFBC">Figure 5-28</a> shows the Data Guard Overview page after a successful switchover.</p> <div class="figure"><a id="CBBCDFBC" name="CBBCDFBC"></a><a id="sthref679" na me="sthref679"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-28 New Primary Database After Switchover</font ></em></strong></p> <img src="./post_switch_all.gif" alt="Description of post_switch_all.gif follows" /><br /> <a id="sthref680" name ="sthref680" href="./img_text/post_switch_all.htm">Description of the illustration post_switch_all.gif</a><br /> <br /></div>  </div>  <a id="i1017859" name="i1017859"></a> <div class="sect1"><a id="sthref681" name="sthr ef681"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.6</span> <a name="DGBKR445" id="DGB KR445"></a>Scenario 6: Performing a <a id="sthref682" name="sthref682"></a><a id="sthref683" name="sthref683"></a><a id="sthref684" n ame="sthref684"></a>Failover Operation</font></h2> <p>This scenario steps you through the process of using the Failover operation to transition one of the physical standby databases, in this case <code>DR_Sales</code>, into the primary role. You should perform a fai lover only in the event of a software or system failure that results in the loss of the primary database. The failed primary database is disabled by the broker and must be re-created, and the standby database assumes the primary database role. See <a href="siteresou rce.htm#i1010215">Section 4.2.5</a> for steps to re-create the failed primary database as a standby database to the new primary datab ase.</p> <p>In <a href="#CBBFHGFB">Figure 5-29</a> the Data Guard Overview page shows the ORA-16625 error status that indicates probl ems accessing the primary database.</p> <div class="figure"><a id="CBBFHGFB" name="CBBFHGFB"></a><a id="sthref685" name="sthref685">< /a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-29 Data Guard Overview Page Showing ORA-16625 Error</font></em ></strong></p> <img src="./16625_error.gif" alt="Description of 16625_error.gif follows" /><br /> <a id="sthref686" name="sthref686" href="./img_text/16625_error.htm">Description of the illustration 16625_error.gif</a><br /> <br /></div>  <p>T o transition <code>DR_Sales</code> into the primary role, select <code>DR_Sales</code> in the Standby Databases table and click <stro ng>Failover</strong>. <a href="#CBBDHJIE">Figure 5-30</a> shows the Failover Confirmation page.</p> <div class="figure"><a id="CBBDHJ IE" name="CBBDHJIE"></a><a id="sthref687" name="sthref687"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-30 Failover Confirmation Page</font></em></strong></p> <img src="./failover_confirmation.gif" alt="Description of failover_confirmation .gif follows" /><br /> <a id="sthref688" name="sthref688" href="./img_text/failover_confirmation.htm">Description of the illustration failover_confirmation.gif</a><br /> <br /></div>  <p>If you determine that a failure occurred on the primary database and there is no possibility of recovering the primary database in a timely manner, you can start the Failover operation. Ora cle recommends that you choose a physical standby database (instead of a logical standby database) as the target of a failover.</p> < p>The Failover operation enables you to choose one of the following two types of failover operations:</p> <ul> <li type="disc"> <p>Co mplete—attempts to minimize data loss by applying all available redo on the standby database.</p></li> <li type="disc"> <p>Imm ediate—no additional data will be applied on the standby database; data may be lost. This is the fastest type of failover.</p> </li></ul> <p><a href="#CBBFCGJI">Figure 5-31</a> shows the progress of the failover operation.</p> <div class="figure"><a id="CBBFCG JI" name="CBBFCGJI"></a><a id="sthref689" name="sthref689"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-31 Failover Progress Page</font></em></strong></p> <img src="./failover_progress.gif" alt="Description of failover_progress.gif follows " /><br /> <a id="sthref690" name="sthref690" href="./img_text/failover_progress.htm">Description of the illustration failover_progre ss.gif</a><br /> <br /></div>  <p>During the failover, the selected standby database transitions into the prim ary role. If the failover target is a physical standby database, it is restarted. When completed, the Data Guard Overview page reflec ts the updated configuration, as shown in <a href="#CBBCFCGJ">Figure 5-32</a>.</p> <div class="figure"><a id="CBBCFCGJ" name="CBBCFCG J"></a><a id="sthref691" name="sthref691"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-32 Data Guard Overv iew Page After a Failover Operation Completes</font></em></strong></p> <img src="./post_failover.gif" alt="Description of post_failov er.gif follows" /><br /> <a id="sthref692" name="sthref692" href="./img_text/post_failover.htm">Description of the illustration post_ failover.gif</a><br /> <br /></div>  <p>In the figure, the Status column indicates that the original primary d atabase (<code>North_Sales</code>) is disabled and can no longer be managed through the Data Guard GUI until it has been re-created.< /p> <div align="center"> <div class="inftblnotealso"><br /> <table class="notealso" summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspa cing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif"><strong>See Also:</strong></font></p> <a href=" siteresource.htm#i1010215">Section 4.2.5</a> for more information about post-failover re-creation steps</td></tr></tbody></table> <br /></div>  </div></div>  <a id="i1018803" name="i1018803"></a> <div class="sect1 "><a id="sthref693" name="sthref693"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.7</sp an> <a name="DGBKR450" id="DGBKR450"></a>Scenario 7: Monitoring a Data Guard Configuration</font></h2> <p>The Data Guard GUI <a id="s thref694" name="sthref694"></a><a id="sthref695" name="sthref695"></a><a id="sthref696" name="sthref696"></a>provides ways to monitor the status of a configuration as well as the online redo log file activity of the primary and standby databases. At the most basic l evel, the Data Guard Overview page for the configuration not only displays information about the configuration, but it also includes summary information about its databases.</p> <div align="center"> <div class="inftblnote"><br /> <table class="note" summary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame="hsides" rul es="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif"><strong>Note :</strong></font></p> You can access the monitoring functions of Data Guard even if you are logged in as a non-SYSDBA user. However, all management features, such as standby creation, switchover, and failover, require a SYSDBA connection.</td></tr></tbody></table> < br /></div>  </div> <p>For example, the summary information on the Data Guard Overview page shows the statu s for all of the databases in the configuration. If you want more information about why log apply services are off for a specific sta ndby database, select the Status link of the database in the Standby Databases table and view the property pages. Any Data Guard spec ific database properties that are incorrect, inconsistent, or known to be in conflict with other parameters will be flagged with a wa rning in the Edit Properties page for the database. A variety of icons indicating the status condition can appear next to the Status link. A green check mark appears if the primary database is functioning normally; a yellow triangle containing an exclamation mark ap pears if there is a warning; and a red X appears if there is an error condition.</p> <ul> <li type="disc"> <p>To check the primary da tabase status, select <strong>Status</strong> under the Primary Database section of the Data Guard Overview page.</p></li> <li type=" disc"> <p>To check the status of a standby database listed in the Standby Databases table, select the link under the Status column.</ p> <p>For example, a yellow warning icon may display the message "A yellow warning indicates an inconsistent property has been detect ed. The value for this property is inconsistent between Data Guard and the database, Data Guard and the server parameter file, or Dat a Guard and both the database and server parameter file."</p></li></ul> <p><a href="#CBBCGGFD">Figure 5-33</a> shows the Data Guard O verview page in the case where the configuration has a log transport error.</p> <div class="figure"><a id="CBBCGGFD" name="CBBCGGFD"> </a><a id="sthref697" name="sthref697"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-33 Data Guard Overview Page Showing Log Transport Error</font></em></strong></p> <img src="./log_transport_error.gif" alt="Description of log_transport_err or.gif follows" /><br /> <a id="sthref698" name="sthref698" href="./img_text/log_transport_error.htm">Description of the illustration log_transport_error.gif</a><br /> <br /></div>  <p>The following sections provide information on ways to moni tor the status and health of a configuration:</p> <ul> <li type="disc"> <p><a href="#i1023501">Section 5.7.1, "Verifying a Broker Con figuration"</a></p></li> <li type="disc"> <p><a href="#i1025913">Section 5.7.2, "Viewing Log File Details"</a></p></li> <li type="dis c"> <p><a href="#i1049690">Section 5.7.3, "Monitoring Configuration Performance"</a></p></li></ul> <a id="i1023501" name="i1023501">< /a> <div class="sect2"><a id="sthref699" name="sthref699"></a> <h3><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.7.1</span> <a name="DGBKR455" id="DGBKR455"></a>Verifying a Broker Configuration</font></h3> <p>Another <a id="sthre f700" name="sthref700"></a><a id="sthref701" name="sthref701"></a><a id="sthref702" name="sthref702"></a>way to quickly check the ove rall health of a broker configuration is to run the Verify operation. The Verify operation performs a series of validation checks on the broker configuration, including a health check of each database in the configuration. The checks include:</p> <ol type="1" start= "1"> <li> <p>Shows the current data protection mode setting, including the current log transport mode settings for each database and whether or not the standby redo log files are configured properly. If standby redo log files are needed for any database, the Verify results will allow you to automatically configure them.</p></li> <li> <p>Validates each database for the current status.</p></li> <li > <p>Performs a log switch on the primary database and then verifies that the log file was applied on each standby database.</p></li> <li> <p>Shows the results of the Verify operation, including errors, if any. The Verify operation completes successfully if there ar e no errors and an online redo log file was successfully applied to at least one standby database.</p></li> <li> <p>Shows any databas es or RAC instances that are not discovered. Undiscovered databases and instances could prevent a failover or switchover from complet ing successfully.</p></li> <li> <p>Detects inconsistencies between database properties and their corresponding values in the database itself. It also provides a mechanism for resolving these inconsistencies.</p> <div class="inftblnote"><br /> <table class="note" sum mary="This is a layout table to format a note" title="This is a layout table to format a note" dir="ltr" border="1" width="80%" frame ="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif" ><strong><strong>Note</strong>:</strong></font></p> You can click <strong>Cancel</strong> at any time to stop the Verify operation.</ td></tr></tbody></table> <br /></div>  </li></ol> <p>To verify the configuration, click <strong>Verify</str ong> under the Additional Administration section of the Data Guard Overview page. See <a href="#CBBCGECC">Figure 5-34</a>. The Verify command displays a progress indicator. When the Verify operation completes successfully, the broker configuration is healthy, guardi ng the data, and ready for a switchover or failover.</p> <div class="figure"><a id="CBBCGECC" name="CBBCGECC"></a><a id="sthref703" n ame="sthref703"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-34 Verifying the Configuration</font></em></s trong></p> <img src="./verifyprocess.gif" alt="Description of verifyprocess.gif follows" /><br /> <a id="sthref704" name="sthref704" href="./img_text/verifyprocess.htm">Description of the illustration verifyprocess.gif</a><br /> <br /></div>  <p><a href="#CBBECHCC">Figure 5-35</a> shows the results of running the Verify operation.</p> <div class="figure"><a id="CBBECHCC" na me="CBBECHCC"></a><a id="sthref705" name="sthref705"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-35 Resul ts of the Verify Command</font></em></strong></p> <img src="./verifyresults.gif" alt="Description of verifyresults.gif follows" /><br /> <a id="sthref706" name="sthref706" href="./img_text/verifyresults.htm">Description of the illustration verifyresults.gif</a><br / > <br /></div>  </div>  <a id="i1025913" name="i1025913"></a> <div class="sect2"><a id= "sthref707" name="sthref707"></a> <h3><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.7.2</span> <a name="DGBKR460" id="DGBKR460"></a>Viewing Log File Details</font></h3> <p>For each <a id="sthref708" name="sthref708"></a><a id="sth ref709" name="sthref709"></a><a id="sthref710" name="sthref710"></a>standby database in the configuration, there is a table that show s the status of archived redo log files that were generated on the primary database but not received by the standby database, and for archived redo log files that were received but not applied to the standby database. This Log File Details page is useful to determin e log file information when log transport or log apply services are stopped. Under normal operations, each standby table is empty.</p > <p>For example, if log transport services go offline unexpectedly, the primary database continues to generate archived redo log fil es, but log transport services will not send the archived redo log files to the standby databases. You can view the Log File Details page to find out which log files have not yet been received for each standby database.</p> <p>On the Log File Details page, there is a <em>Primary Current Log</em> entry that indicates the log sequence number of the current log file on the primary.</p> <p>For each s tandby database, log transport and log apply information is displayed to help diagnose any log file buildup. <a href="#g1057980">Tabl e 5-1</a> describes the columns for the standby table:</p> <div class="tblruleformal"><a id="sthref711" name="sthref711"></a><a id="g 1057980" name="g1057980"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Table 5-1 Log File Details Page</font></em></ strong></p> <table class="ruleformal" title="Log File Details Page" summary="a description of the columns of the standby table shown when viewing log file details" dir="ltr" border="1" width="100%" frame="border" rules="all" cellpadding="3" cellspacing="0"> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t8"><font face="Arial, Helvetica, sans-serif"><strong>Column Title</strong></font></th> <th align="left" valign="bottom" id="r1c2-t8"><font face="Arial, Helvetica, sans-serif"><strong>Descripti on</strong></font></th></tr></thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t8" headers="r1c1-t8">Log</td> <td align="left" headers="r2c1-t8 r1c2-t8">The log sequence number.</td></tr> <tr align="left" valign="top"> <td align="left" id="r3c 1-t8" headers="r1c1-t8">Status</td> <td align="left" headers="r3c1-t8 r1c2-t8">The status of the log file.</td></tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t8" headers="r1c1-t8">Not Received</td> <td align="left" headers="r4c1-t8 r1c2-t8">The log f ile has not been received.</td></tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t8" headers="r1c1-t8">Not Applied</td> <td align="left" headers="r5c1-t8 r1c2-t8">The log file has not been applied.</td></tr> <tr align="left" valign="top"> <td align="lef t" id="r6c1-t8" headers="r1c1-t8">First Change # (SCN)</td> <td align="left" headers="r6c1-t8 r1c2-t8">The first system change number .</td></tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t8" headers="r1c1-t8">Last Change # (SCN)</td> <td align="left" headers="r7c1-t8 r1c2-t8">The last system change number.</td></tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t8" heade rs="r1c1-t8">Size (KB)</td> <td align="left" headers="r8c1-t8 r1c2-t8">The size, in kilobytes, of the log file.</td></tr> <tr align=" left" valign="top"> <td align="left" id="r9c1-t8" headers="r1c1-t8">Time Generated</td> <td align="left" headers="r9c1-t8 r1c2-t8">Th e time when the log file was generated.</td></tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t8" headers="r1c1-t8">Tim e Completed</td> <td align="left" headers="r10c1-t8 r1c2-t8">The time at which the log file was completed.</td></tr></tbody></table> <br /></div>  <p>Click <strong>Log File Details</strong> from the Data Guard Overview page to see the p age shown in <a href="#CBBEAAJG">Figure 5-36</a>.</p> <div class="figure"><a id="CBBEAAJG" name="CBBEAAJG"></a><a id="sthref712" name ="sthref712"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-36 Viewing Log File Details</font></em></strong> </p> <img src="./logfiledetails.gif" alt="Description of logfiledetails.gif follows" /><br /> <a id="sthref713" name="sthref713" href ="./img_text/logfiledetails.htm">Description of the illustration logfiledetails.gif</a><br /> <br /></div>  </ div>  <a id="i1049690" name="i1049690"></a> <div class="sect2"><a id="sthref714" name="sthref714"></a> <h3><f ont face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.7.3</span> <a name="DGBKR465" id="DGBKR465"></a>Monito ring Configuration Performance</font></h3> <p>For <a id="sthref715" name="sthref715"></a><a id="sthref716" name="sthref716"></a><a id ="sthref717" name="sthref717"></a>more in-depth performance and monitoring, you can display detailed performance statistics for a bro ker configuration using performance charts that provide a graphical summary of all online redo log file activity in the configuration . The charts are refreshed based on a collection interval (the rate at which data is sampled from the primary database) that you can specify. The default collection interval is 30 seconds, which can be changed. See the online Help for detailed information about perf ormance sampling rates.</p> <p>For example, <a href="#CBBEAEJD">Figure 5-37</a> shows performance information for all of the objects in the configuration.</p> <div class="figure"><a id="CBBEAEJD" name="CBBEAEJD"></a><a id="sthref718" name="sthref718"></a> <p><stron g><em><font face="arial, helvetica, sans-serif">Figure 5-37 Performance Page</font></em></strong></p> <img src="./performance-overvie w.gif" alt="Description of performance-overview.gif follows" /><br /> <a id="sthref719" name="sthref719" href="./img_text/performance -overview.htm">Description of the illustration performance-overview.gif</a><br /> <br /></div>  <p>The Perform ance Overview page begins charting information as soon as the page is displayed. Data will not be collected for any offline or disabl ed databases.</p></div>  </div>  <a id="i1014496" name="i1014496"></a> <div class="sect1 "><a id="sthref720" name="sthref720"></a> <h2><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.8</sp an> <a name="DGBKR470" id="DGBKR470"></a>Scenario 8: Using Metrics</font></h2> <p>In addition to monitoring the status and log file a ctivity using <a id="sthref721" name="sthref721"></a><a id="sthref722" name="sthref722"></a><a id="sthref723" name="sthref723"></a>th e Data Guard GUI, Oracle Enterprise Manager automatically monitors the status and archived redo log file activity on the primary and standby databases.</p> <p><a href="#g1058042">Table 5-2</a> describes the five Data Guard metrics.</p> <div class="tblformal"><a id=" sthref724" name="sthref724"></a><a id="g1058042" name="g1058042"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Table 5-2 Data Guard Metrics</font></em></strong></p> <table class="formal" title="Data Guard Metrics" summary="a description of the Data Guard metrics" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <thead> <tr align="le ft" valign="top"> <th align="left" valign="bottom" id="r1c1-t9"><font face="Arial, Helvetica, sans-serif"><strong>Metric</strong></fo nt></th> <th align="left" valign="bottom" id="r1c2-t9"><font face="Arial, Helvetica, sans-serif"><strong>Description</strong></font>< /th></tr></thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t9" headers="r1c1-t9">Data Guard Status</td> <td a lign="left" headers="r2c1-t9 r1c2-t9">Checks the status of each database in the broker configuration.</td></tr> <tr align="left" vali gn="top"> <td align="left" id="r3c1-t9" headers="r1c1-t9">Data Not Applied (MB)<a id="CBBHEHCD" name="CBBHEHCD" href="#CBBHEHCD" oncl ick='footdisplay(1,"For Oracle Database 10\u003cem\u003eg\u003c/em\u003e database only.")'><sup><font size="-3">Foot </font>1&nb sp;</sup></a></td> <td align="left" headers="r3c1-t9 r1c2-t9">Measures the difference (in megabytes) between the last log file receiv ed and the last log file applied on each standby database.</td></tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t9" hea ders="r1c1-t9">Data Not Applied (log files)</td> <td align="left" headers="r4c1-t9 r1c2-t9">Measures the difference (in number of arc hived redo log files) between the last log file received and the last log file applied on each standby database.</td></tr> <tr align= "left" valign="top"> <td align="left" id="r5c1-t9" headers="r1c1-t9">Data Not Received (MB)<a id="sthref725" name="sthref725" href="# sthref725" onclick='footdisplay(1,"For Oracle Database 10\u003cem\u003eg\u003c/em\u003e database only.")'><sup><font size="-3">Footre f </font>1</sup></a></td> <td align="left" headers="r5c1-t9 r1c2-t9">Measures the difference (in megabytes) between the current log file on the primary database and the last log file received on each standby database.</td></tr> <tr align="left" valign="top"> <t d align="left" id="r6c1-t9" headers="r1c1-t9">Data Not Received (log files)</td> <td align="left" headers="r6c1-t9 r1c2-t9">Measures the difference (in number of archived redo log files) between the current log file on the primary database and the last log file rece ived on each standby database.</td></tr></tbody></table> <br /></div>  <font size="-1"><sup><font size="1"> Footnote </font>1 </sup>For Oracle Database 10<em>g</em> database only.<br /></font> <p>You can set up Email Services to n otify you through your e-mail if any of the metrics are triggered.</p> <div align="center"> <div class="inftblnotealso"><br /> <table class="notealso" summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1 " width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, hel vetica, sans-serif"><strong>See Also:</strong></font></p> Oracle Enterprise Manager help and documentation for more information about registering metrics and using Email Services</td></tr></tbody></table> <br /></div>  </div> <div class ="sect2"><a id="sthref726" name="sthref726"></a> <h3><font face="arial, helvetica, sans-serif " color="#330099"><span class="secnum">5.8.1</span> U<a name="DGBKR471" id="DGBKR471"></a>nderstanding the <a id="sthref727" name="st href727"></a>Data Guard Metrics</font></h3> <p>The following sections provide additional information about the Data Guard metrics.</p > <div class="sect3"><a id="sthref728" name="sthref728"></a> <h4><font face="arial, helvetica , sans-serif" color="#330099"><span class="secnum">5.8.1.1</span> Data <a id="sthref729" name="sthref729"></a><a id="sthref730" name= "sthref730"></a>Guard Status</font></h4> <p>The Data Guard Status metric checks the status of each database in the broker configurati on and triggers a warning or critical alert if necessary.</p></div>  <div class="sect3"><a id="sthref731" name="sthref731"></a> <h4><font face="arial, helvetica, sans-serif" color="#330099"><span class="s ecnum">5.8.1.2</span> Data <a id="sthref732" name="sthref732"></a><a id="sthref733" name="sthref733"></a>Not Applied (MB)</font></h4> <p>The broker computes the highest applied SCN and uses its value to find the last continuous log that was successfully archived to the standby database. The size of redo data in all subsequent log files are counted as data not applied. If the primary database goes down at this point, these logs can be applied on the standby database. If there is a gap in the logs received on the standby databas e, any logs received after the gap cannot be applied. See the <em><a class="xlinkSRC SBYDB00535" href="../../server$101/b10823/log_tr ansport.htm#SBYDB00535">Oracle Data Guard Concepts and Administration</a></em> for information about archive gaps.</p> <p>For example , if logs 1, 2, 3, 6, 7, and 9 are received on the standby database and log apply services is currently applying log 1, log apply ser vices can continue to apply up to log 3. Log apply services cannot apply any more logs because log 4 is missing. Even though logs 6, 7, and 9 are received, they cannot be applied and they will not be counted as data not applied. In this case, the total size of logs 1, 2, and 3 is the size of Data Not Applied.</p> <p>If all the archived log files on the standby database are continuous, and standby redo logs are used, the standby redo logs are also counted as data not applied, unless real-time apply is turned on and log apply se rvices is already working on the standby redo logs. The size of an archived log file is its file size. However, the size of a standby redo log is the size of the actual redo in the log and not the file size.</p> <p>If the standby redo logs are multithreaded, the bro ker computes the highest applied SCN for every thread and totals the numbers. If there are multiple incarnations and the standby data base is in a different incarnation from the primary database, each incarnation is computed separately and the results are then totale d.</p></div>  <div class="sect3"><a id="sthref734" name="sthref734"></a> <h4><font face="arial, helvetica, sans-serif" color="#330099"><span class="secnum">5.8.1.3</span> Data <a id="sthref735" name="sthr ef735"></a><a id="sthref736" name="sthref736"></a>Not Applied (Log Files)</font></h4> <p>The broker computes the highest applied SCN and uses its value to find the last continuous log that was successfully archived to the standby database. Redo data in all subsequen t log files are counted as logs not applied. If the primary database goes down at this point, these logs can be applied on the standb y database. If there is a gap in the logs received on the standby database, any logs received after the gap cannot be applied. See th e <em><a class="xlinkSRC SBYDB00535" href="../../server$101/b10823/log_transport.htm#SBYDB00535">Oracle Data Guard Concepts and Admin istration</a></em> for information about archive gaps.</p> <p>For example, if logs 1, 2, 3, 6, 7, and 9 are received on the standby d atabase and log apply services is currently applying log 1, log apply services can continue to apply up to log 3. Log apply services cannot apply any more logs because log 4 is missing. Even though logs 6, 7, and 9 are received, they cannot be applied and they will not be counted as data not applied.</p> <p>If all the archived log files on the standby database are continuous, and standby redo log s are used, the standby redo logs are also counted as data not applied, unless real-time apply is turned on and log apply services is already working on the standby redo logs.</p> <p>If the standby redo logs are multithreaded, the broker computes the highest applied SCN for every thread and totals the numbers. If there are multiple incarnations and the standby database is in a different incarnati on from the primary database, each incarnation is computed separately and the results are then totaled.</p></div>  <div class="sect3"><a id="sthref737" name="sthref737"></a> <h4><font face="arial, helveti ca, sans-serif" color="#330099"><span class="secnum">5.8.1.4</span> Data <a id="sthref738" name="sthref738"></a><a id="sthref739" nam e="sthref739"></a>Not Received (MB)</font></h4> <p>The broker computes the highest applied SCN and uses its value to find the last co ntinuous log that was successfully archived to the standby database. The size of redo data in all subsequent log files, including the current online redo log file, are counted as data for potential data loss and will be unrecoverable if the primary database goes dow n at this point. The size of an archived log file is its file size, and the size of the online redo log file is the size of the actua l redo in the online log, not the file size of the online redo log file.</p> <p>For example, if logs 1, 2, 3, 6, 7, and 9 are receive d on the standby database, and if log 10 is the current online log file, and if log apply services is currently applying log 1, the l ast continuous log after the highest applied SCN is log 3. All logs after log 3, that is logs 4 through 10, are counted as data not r eceived and the total size of redo data in these logs is the size of Data Not Received.</p> <p>If the primary database is multithread ed (in a RAC database), the broker computes the highest applied SCN for every thread and totals the numbers. If the primary database has multiple incarnations (for example, due to a flashback operation) and the standby database is in a different incarnation from the primary database, the computation is done on each incarnation and the results are then totaled.</p></div>  <di v class="sect3"><a id="sthref740" name="sthref740"></a> <h4><font face="arial, helvetica, san s-serif" color="#330099"><span class="secnum">5.8.1.5</span> Data <a id="sthref741" name="sthref741"></a><a id="sthref742" name="sthr ef742"></a>Not Received (Log Files)</font></h4> <p>The broker computes the highest applied SCN and uses its value to find the last co ntinuous log that was successfully archived to the standby database. Redo data in all subsequent log files, including the current onl ine redo log file, are counted as logs for potential data loss and will be unrecoverable if the primary database goes down at this po int.</p> <p>For example, if logs 1, 2, 3, 6, 7, and 9 are received on the standby database, and if log 10 is the current online log f ile, and if log apply services is currently applying log 1, the last continuous log after the highest applied SCN is log 3. All logs after log 3, that is logs 4 through 10, are counted as data not received. If the primary database goes down at this point, all redo d ata in logs 4 through 10 are lost on the standby database.</p> <p>If the primary database is multithreaded (in a RAC database), the b roker computes the highest applied SCN for every thread and totals the numbers. If the primary database has multiple incarnations (fo r example, due to a flashback operation) and the standby database is in a different incarnation from the primary database, the comput ation is done on each incarnation and the results are then totaled.</p></div>  </div>  <d iv class="sect2"><a id="sthref743" name="sthref743"></a> <h3><font face="arial, helvetica, sans-serif" color="#330099"><span class=" secnum">5.8.2</span> <a name="DGBKR475" id="DGBKR475"></a>Managing Data Guard Metrics</font></h3> <p>The <a id="sthref744" name="sthr ef744"></a><a id="sthref745" name="sthref745"></a><a id="sthref746" name="sthref746"></a>example in this section describes Data Guard metrics and how to set up for notification through e-mail when a metric is triggered. Take the following steps to manage Data Guard metrics:</p> <ol type="1" start="1"> <li> <p><a href="#i1049698">Set up to receive metric notification by e-mail.</a></p></li> <li> < p><a href="#BGBCDIAA">View the All Metrics page.</a></p></li> <li> <p><a href="#BGBCFEBB">Set or change metric thresholds for Data Gu ard thresholds.</a></p></li> <li> <p><a href="#BGBCFHBJ">View triggered metrics.</a></p></li></ol> <a id="i1049698" name="i1049698">< /a><br /> <a id="CBBGAABF" name="CBBGAABF"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 1 Set up to receive metric notification by e-mail.</font></strong></p> <p>You can set up the Notification Methods to notify you through e-mail if any of the me trics are triggered. To set up Notification Methods, take the following steps:</p> <ol type="a"> <li> <p>Click <strong>Setup</strong> at the bottom of the Database Home page.</p></li> <li> <p>Click <strong>Notification Methods</strong> on the Setup page.</p></li> <l i> <p>Set up the required mail server information.</p> <div class="inftblnotealso"><br /> <table class="notealso" summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="g roups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif"><strong>See Also: </strong></font></p> Oracle Enterprise Manager documentation and help for a complete description of Email Services</td></tr></tbody>< /table> <br /></div>  </li></ol> <a id="BGBCDIAA" name="BGBCDIAA"></a> <p><strong><font face="arial, h elvetica, sans-serif">Step 2 View the All Metrics page.</font></strong></p> <p>You can view all of the metrics for Oracle Enterprise Manager, including Data Guard, by clicking <strong>All Metrics</strong> at the bottom of the Database Home page.</p> <p><a href="#CBB JDCJI">Figure 5-38</a> shows the All Metrics page for the primary database with the Data Guard metrics expanded.</p> <div class="figu re"><a id="CBBJDCJI" name="CBBJDCJI"></a><a id="sthref747" name="sthref747"></a> <p><strong><em><font face="arial, helvetica, sans-s erif">Figure 5-38 Data Guard Metrics</font></em></strong></p> <img src="./allmetricspage.gif" alt="Description of allmetricspage.gif follows" /><br /> <a id="sthref748" name="sthref748" href="./img_text/allmetricspage.htm">Description of the illustration allmetricsp age.gif</a><br /> <br /></div>  <a id="BGBCFEBB" name="BGBCFEBB"></a> <p><strong><font face="arial, helvetica , sans-serif">Step 3 Set or change metric thresholds for Data Guard thresholds.</font></strong></p> <p>There are five metrics for Dat a Guard. These metrics can be changed from the Manage Metrics page.</p> <ul> <li type="disc"> <p>Data Guard Status</p> <p>If the Data Guard Status metric contains Warning, a warning alert is triggered. If the metric contains Error, a critical alert is triggered.</p> </li> <li type="disc"> <p>Data Not Applied (MB)</p> <p>There is no default value. If you want to receive alerts for these metrics, yo u need to set these thresholds from the Manage Metrics link from the bottom of the Database Home page.</p></li> <li type="disc"> <p>D ata Not Applied (log files)</p> <p>The default values for log files are 1 for the warning threshold and 3 for the critical threshold. If the number of log files is greater than 1, a warning alert is triggered. If the number of log files is greater than 3, a critical alert is triggered. You can change these values from the Manage Metrics link from the bottom of the Database Home page.</p></li> <li type="disc"> <p>Data Not Received (MB)</p> <p>There is no default value. If you want to receive alerts for these metrics, you need t o set these thresholds from the Manage Metrics link from the bottom of the Database Home page.</p></li> <li type="disc"> <p>Data Not Received (log files)</p> <p>The default values for log files are 1 for the warning threshold and 3 for the critical threshold. If the number of log files is greater than 1, a warning alert is triggered. If the number of log files is greater than 3, a critical alert is triggered. You can change these values from the Manage Metrics link from the bottom of the Database Home page.</p></li></ul> <a id ="BGBCFHBJ" name="BGBCFHBJ"></a> <p><strong><font face="arial, helvetica, sans-serif">Step 4 View triggered metrics.</font></strong> </p> <p>If a metric condition is triggered or a threshold value is exceeded, an alert is issued. Click <strong>Data Guard</strong> fr om the All Metrics page to view triggered metrics.</p> <p><a href="#CBBJEIDD">Figure 5-39</a> is an example of what is shown when the Data Guard Status metric triggers after a log transport error is detected in the configuration. The table shows the status of each d atabase in the configuration. The status of the primary database shows the ORA-16778 error.</p> <div class="figure"><a id="CBBJEIDD" name="CBBJEIDD"></a><a id="sthref749" name="sthref749"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-39 Dat a Guard Triggered Metrics</font></em></strong></p> <img src="./allmetricsdg.gif" alt="Description of allmetricsdg.gif follows" /><br /> <a id="sthref750" name="sthref750" href="./img_text/allmetricsdg.htm">Description of the illustration allmetricsdg.gif</a><br /> < br /></div>  <p>Because Email Services was set up, DBAs are also notified by an e-mail message.</p> <p>After a metric condition is fixed, the metric is cleared automatically.</p></div>  </div>  <a id ="i1043040" name="i1043040"></a> <div class="sect1"><a id="sthref751" name="sthref751"></a> <h2><font face="arial, helvetica, sans- serif" color="#330099"><span class="secnum">5.9</span> <a name="DGBKR480" id="DGBKR480"></a>Scenario 9: Removing a Standby Database a nd Configuration</font></h2> <p>You can remove a standby database or broker configuration so that it is no longer controlled by the D ata Guard broker.</p> <div class="sect2"><a id="sthref752" name="sthref752"></a> <h3><font face="arial, helvetica, sans-serif" color ="#330099"><span class="secnum">5.9.1</span> <a name="DGBKR485" id="DGBKR485"></a>Remove a Standby Database</font></h3> <p>Removing a <a id="sthref753" name="sthref753"></a><a id="sthref754" name="sthref754"></a><a id="sthref755" name="sthref755"></a>standby databas e from Data Guard broker control does not permanently delete the database itself. This operation permanently removes the profile of t he standby database from the broker configuration file.</p> <p>By default, the standby destination is also removed from the primary d atabase so that log files are no longer archived to that standby database.</p> <div align="center"> <div class="inftblnotewarn"><br / > <table class="notewarn" summary="This is a layout table to format a warning" title="This is a layout table to format a warning" dir ="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <tbody> <tr> <td align="left"> <p><font face="arial, helvetica, sans-serif"><strong>Caution:</strong></font></p> <p><strong>The Oracle9<em>i</em> Data Guard Manager default was to preserve the standby destination on the primary database.</strong></p></td></tr></tbody></table> <br /></div>  </div> <p>To remove a standby database from the broker configuration, click <strong>Remove</strong> in the Standby Dat abases section of the Data Guard Overview page. Data Guard GUI will ask you to confirm that you really want to remove the standby dat abase from the configuration. Click <strong>Yes</strong> to continue or <strong>No</strong> to cancel.</p> <p><a href="#CBBDCEIB">Fig ure 5-40</a> shows removing a standby database.</p> <div class="figure"><a id="CBBDCEIB" name="CBBDCEIB"></a><a id="sthref756" name=" sthref756"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-40 Removing a Standby Database</font></em></strong ></p> <img src="./remove-standby.gif" alt="Description of remove-standby.gif follows" /><br /> <a id="sthref757" name="sthref757" hre f="./img_text/remove-standby.htm">Description of the illustration remove-standby.gif</a><br /> <br /></div>  < /div>  <div class="sect2"><a id="sthref758" name="sthref758"></a> <h3><font face="arial, helvetica, sans-serif " color="#330099"><span class="secnum">5.9.2</span> <a name="DGBKR490" id="DGBKR490"></a>Remove the Data Guard Configuration</font></ h3> <p>To <a id="sthref759" name="sthref759"></a><a id="sthref760" name="sthref760"></a><a id="sthref761" name="sthref761"></a>remove the broker configuration, you must be connected to the configuration through the primary database. Click <strong>Remove Data Guard C onfiguration</strong> under the Additional Administration section. The Data Guard GUI will ask you to confirm that you want to remove the configuration. Click <strong>Yes</strong> to continue or <strong>No</strong> to cancel.</p> <p><a href="#CBBJCIDA">Figure 5-41</ a> shows removing a Data Guard broker configuration.</p> <div class="figure"><a id="CBBJCIDA" name="CBBJCIDA"></a><a id="sthref762" n ame="sthref762"></a> <p><strong><em><font face="arial, helvetica, sans-serif">Figure 5-41 Removing a Data Guard Broker Configuration </font></em></strong></p> <img src="./remove-config.gif" alt="Description of remove-config.gif follows" /><br /> <a id="sthref763" na me="sthref763" href="./img_text/remove-config.htm">Description of the illustration remove-config.gif</a><br /> <br /></div>  <p>When you choose this option, the Data Guard GUI removes (deletes) the selected broker configuration permanently. Wh en you permanently remove a configuration, the remove operation:</p> <ul> <li type="disc"> <p>Does not affect the underlying operatio ns of the standby databases or log apply services if you check the box to preserve all standby destinations. Operations such as log t ransport services and log apply services continue to run; however, these services are no longer manageable through the Data Guard GUI .</p></li> <li type="disc"> <p>By default, all standby database profiles are removed from the broker configuration, and log transport services to all standby databases in the configuration are stopped.</p></li> <li type="disc"> <p>Destroys all broker configuration p rofile information maintained for each database; the configuration is then unknown to the broker and can no longer be managed from th e Data Guard GUI.</p></li></ul> <p>Although the configuration information is not recoverable once you delete a broker configuration p ermanently, you can easily re-create the configuration with the Add Standby Database wizard.</p></div>  </div>  </div> <div class="footer"> <hr /> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td st yle="width: 33%;" align="left"> <table summary="layout table" cellspacing="0" cellpadding="0" align="left" width="90"> <tr> <td align ="center" valign="top"><a href="siteresource.htm"><img src="../../dcommon/gifs/larrow.gif" alt="Go to previous page" border="0" /><br /> <font size="-2">Previous</font></a></td> <td align="center" valign="top"><a href="cli.htm"><img src="../../dcommon/gifs/rarrow.gi f" alt="Go to next page" border="0" /><br /> <font size="-2">Next</font></a></td></tr></table></td> <td style="width: 34%;" align="ce nter"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> <a href="../../dcommon/html/cpyr.htm"><font size="-2">Copyright& nbsp;© 2000, 2003 Oracle Corporation</font></a><br /> <font size="-2">All Rights Reserved.</font></td> <td style= "width: 33%;" align="right"> <table summary="" cellspacing="0" cellpadding="0" width="270"> <tr> <td align="center" valign="top"><a h ref="../../index.htm"><img src="../../dcommon/gifs/prodicon.gif" alt="Go to Documentation Home" border="0" /><br /> <font size="-2">H ome</font></a></td> <td align="center" valign="top"><a href="../../nav/portal_3.htm"><img src="../../dcommon/gifs/bookicon.gif" alt=" Go to Book List" border="0" /><br /> <font size="-2">Book List</font></a></td> <td align="center" valign="top"><a href="toc.htm"><img src="../../dcommon/gifs/conticon.gif" alt="Go to Table of Contents" border="0" /><br /> <font size="-2">Contents</font></a></td> <td align="center" valign="top"><a href="index.htm"><img src="../../dcommon/gifs/indxicon.gif" alt="Go to Index" border="0" /><br /> <fo nt size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gif s/mix.gif" alt="Go to Master Index" border="0" /><br /> <font size="-2">Master Index</font></a></td> <td align="center" valign=" top"><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" alt="Go to Feedback page" border="0" /><br /> <font size="-2">Feedback</font></a></td></tr></table></td></tr></table></div> </body> </html>