2 Getting Started with Data Guard</tit le> <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1"> <meta http-equiv="Content-Language" content="EN"> <meta http-equiv="Content-Style-Type" content="text/css"> <meta http-equiv="Content-Script-Type" content="text/javascript"> <meta name="rob ots" content="all" scheme="http://www.robotstxt.org/"> <meta name="doctitle" content="Oracle® Data Guard Concepts and Administrat ion 10g Release 1 (10.1)"> <meta name="partno" content="B10823-01"> <meta name="docid" content="SBYDB"> <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="Prev" href="concepts.ht m" title="Previous" type="text/html"> <link rel="Next" href="create_ps.htm" title="Next" type="text/html"> <link rel="alternate" href ="../b10823.pdf" title="PDF version" type="application/pdf"> </head> <body> <div class="header"> <p><a name="top" id="top" href="#BEG IN">Skip Headers</a></p> <table summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><font col or="#330099" face="Helvetica, Arial, sans-serif"><strong>Oracle® Data Guard Concepts and Administration<br> 10<i>g</i> Release 1 (10.1)</strong><br> Part Number B10823-01</font></td> <td valign="bottom" align="right"> <table summary="" cellspacing="0" cellpaddi ng="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/porta l_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/indxic on.gif" alt="Go to Index" border="0"><br> <font size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix.10 1/b12039/toc.htm"><img src="../../dcommon/gifs/mix.gif" alt="Go to Master Index" border="0"><br> <font size="-2">Master Index</f ont></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img src="../../dcommon/gifs/feedback.gif" al t="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" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table summary="layout table" cellspa cing="0" cellpadding="0" align="left" width="90"> <tr> <td align="center" valign="top"><a href="concepts.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="create_ps.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 align="right" valign="top"><a href="../b10823.pdf"><font size="-2">View PDF</font></a></td></tr></table> <a name="BEGIN"></a></div> <div class="IND"> <a name="50949"></a>  <h1 class="Title"><fon t face="Arial, Helvetica, sans-serif" color="#330099">2<br> <a name="SBYDB00100">Getting Started with Data Guard</a></font></h1> <!- -/TOC=Title--> <a name="61360"></a> <p class="BP">A Data Guard configuration contains a primary database and up to nine associated s tandby databases. This chapter describes the following considerations for getting started with Data Guard:</p> <ul class="LB1"> <li c lass="LB1" type="disc"><a name="52145"></a><a href="standby.htm#52114">Standby Database Types</a></li> <li class="LB1" type="disc"><a name="52126"></a><a href="standby.htm#52164">User Interfaces for Administering Data Guard Configurations</a></li> <li class="LB1" ty pe="disc"><a name="52130"></a><a href="standby.htm#52221">Data Guard Operational Prerequisites</a></li> <li class="LB1" type="disc">< a name="62374"></a><a href="standby.htm#64472">Standby Database Directory Structure Considerations</a></li> <li class="LB1" type="dis c"><a name="72458"></a><a href="standby.htm#72302">Online Redo Logs, Archived Redo Logs, and Standby Redo Logs</a></li></ul> <a name= "52114"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">2.1 Standby Database Type s</font></h2>  <a name="51980"></a> <p class="BP">A <strong class="Bold">standby database</strong> is a transactionall y consistent copy of an Oracle production database that is initially created from a backup copy of the primary database. Once the sta ndby database is created and configured, Data Guard automatically maintains the standby database by transmitting primary database red o data to the standby system, where the redo data is applied to the standby database.</p> <a name="54786"></a> <p class="BP">A stand by database can be one of two types: a physical standby database or a logical standby database. If needed, either type of standby dat abase can assume the role of the primary database and take over production processing. A Data Guard configuration can include physica l standby databases, logical standby databases, or a combination of both types.</p> <a name="72628"></a> <p class="BP">The following sections describe standby databases in more detail. See <em class="Italic"><a class="olinkSRC MAXAV" href="../../server$101/b10726/t oc.htm">Oracle High Availability Architecture and Best Practices</a></em> for information that can help you determine which type is m ost appropriate for your business.</p> <a name="50961"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-s erif" color="#330099">2.1.1 Physical Standby Databases</font></h3>  <a name="57138"></a> <p class="BP">A physical stan dby database is physically identical to the primary database, with on disk database structures that are identical to the primary data base on a block-for-block basis. The database schema, including indexes, are identical.</p> <a name="59493"></a> <p class="BP">Data Guard maintains a physical standby database by performing Redo Apply. When it is not performing recovery, a physical standby database can be open in read-only mode.</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="59495"></a><strong class="Bold">R</strong>< strong class="Bold">edo Apply</strong> <p><a name="59497"></a></p> <p class="BP1">The physical standby database is maintained by app lying redo data from the archived redo log files or directly from standby redo log files on the standby system using the Oracle recov ery mechanism. The recovery operation applies changes block for block using the data block address. The database cannot be opened whi le redo is being applied.</p></li> <li class="LB1" type="disc"><a name="50966"></a><strong class="Bold">Open read-</strong><strong cl ass="Bold">only</strong> <p><a name="50967"></a></p> <p class="BP1">The physical standby database can be open in read-only mode so t hat you can execute queries on the database. While opened in read-only mode, the standby database can continue to receive redo data, but application of the redo data from the log files is deferred until the database resumes Redo Apply.</p></li></ul> <a name="61443"> </a> <p class="BP">Although the physical standby database cannot perform both Redo Apply and be opened in read-only mode at the same time, you can switch between them. For example, you can run a physical standby database to perform Redo Apply, then open it in read- only mode for applications to run reports, and then change it back to perform Redo Apply to apply any outstanding archived redo log f iles. You can repeat this cycle, alternating between Redo Apply and read-only, as necessary.</p> <a name="61408"></a> <p class="BP"> In either case, the physical standby database is available to perform backups. Furthermore, the physical standby database will contin ue to receive redo data even if archived redo log files or standby redo log files are not being applied at that moment.</p> <a name=" 51025"></a> <h5 class="SH2"><font face="Arial, Helvetica, sans-serif">Benefits of a Physical Standby Database</font></h5> <a name="6 1585"></a> <p class="BP">A physical standby database provides the following benefits:</p> <ul class="LB1"> <li class="LB1" type="dis c"><a name="61586"></a>Disaster recovery and high availability <p><a name="61587"></a></p> <p class="BP1">A physical standby databas e enables a robust and efficient disaster recovery and high availability solution. Easy-to-manage switchover and failover capabilitie s allow easy role reversals between primary and physical standby databases, minimizing the downtime of the primary database for plann ed and unplanned outages.</p></li> <li class="LB1" type="disc"><a name="61588"></a>Data protection <p><a name="61589"></a></p> <p cl ass="BP1">Using a physical standby database, Data Guard can ensure no data loss, even in the face of unforeseen disasters. A physical standby database supports all datatypes, and DDL and DML operations that the primary database can support. It also provides a safegu ard against data corruptions and user errors. Storage level physical corruptions on the primary database do not propagate to the stan dby database. Similarly, logical corruptions or user errors that cause the primary database to be permanently damaged can be resolved . Finally, the redo data is validated when it is applied to the standby database.</p></li> <li class="LB1" type="disc"><a name="61591 "></a>Reduction in primary database workload <p><a name="61663"></a></p> <p class="BP1">Oracle Recovery Manager (RMAN) can use physi cal standby databases to off-load backups from the primary database saving valuable CPU and I/O cycles. The physical standby database can also be opened in read-only mode for reporting and queries.</p></li> <li class="LB1" type="disc"><a name="61594"></a>Performance <p><a name="61580"></a></p> <p class="BP1">The Redo Apply technology used by the physical standby database applies changes using lo w-level recovery mechanisms, which bypass all SQL level code layers; therefore, it is the most efficient mechanism for applying chang es. This makes the Redo Apply technology an efficient mechanism to propagate changes among databases.</p></li></ul> <a name="50976">< /a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">2.1.2 Logical Standby Databases</f ont></h3>  <a name="59744"></a> <p class="BP">A logical standby database is initially created as an identical copy of the primary database, but it later can be altered to have a different structure. The logical standby database is updated by executing SQL statements. This allows users to access the standby database for queries and reporting at any time. Thus, the logical standby da tabase can be used concurrently for data protection and reporting operations.</p> <a name="50978"></a> <p class="BP">Data Guard auto matically applies information from the archived redo log file or standby redo log file to the logical standby database by transformin g the data in the log files into SQL statements and then executing the SQL statements on the logical standby database. Because the lo gical standby database is updated using SQL statements, it must remain open. Although the logical standby database is opened in read/ write mode, its target tables for the regenerated SQL are available only for read-only operations. While those tables are being updat ed, they can be used simultaneously for other tasks such as reporting, summations, and queries. Moreover, these tasks can be optimize d by creating additional indexes and materialized views on the maintained tables.</p> <a name="59475"></a> <p class="BP">A logical s tandby database has some restrictions on datatypes, types of tables, and types of DDL and DML operations. <a href="create_ls.htm#7690 3">Section 4.1.1</a> describes the unsupported datatypes and storage attributes for tables.</p> <a name="51044"></a> <h5 class= "SH2"><font face="Arial, Helvetica, sans-serif">Benefits of a Logical Standby Database</font></h5> <a name="61602"></a> <p class="BP ">A logical standby database provides similar disaster recovery, high availability, and data protection benefits as a physical standb y database. It also provides the following specialized benefits:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="61603"></a >Efficient use of standby hardware resources <p><a name="61604"></a></p> <p class="BP1">A logical standby database can be used for o ther business purposes in addition to disaster recovery requirements. It can host additional database schemas beyond the ones that ar e protected in a Data Guard configuration, and users can perform normal DDL or DML operations on those schemas any time. Because the logical standby tables that are protected by Data Guard can be stored in a different physical layout than on the primary database, ad ditional indexes and materialized views can be created to improve query performance and suit specific business requirements.</p></li> <li class="LB1" type="disc"><a name="61605"></a>Reduction in primary database workload <p><a name="61606"></a></p> <p class="BP1">A logical standby database can remain open at the same time its tables are updated from the primary database, and those tables are sim ultaneously available for read access. This makes a logical standby database an excellent choice to do queries, summations, and repor ting activities, thereby off-loading the primary database from those tasks and saving valuable CPU and I/O cycles.</p></li></ul> <a n ame="52164"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">2.2 <a name="SBYDB000 65">User Interface</a>s for Administering Data Guard Configurations</font></h2>  <a name="52165"></a> <p class="BP">Yo u can use the following interfaces to configure, implement, and manage a Data Guard configuration:</p> <a name="74609"></a> <ul clas s="LB1"> <li class="LB1" type="disc"><a name="72835"></a>Oracle Enterprise Manager <p><a name="72836"></a></p> <p class="BP1">Enterp rise Manager provides a GUI interface for the Data Guard broker that automates many of the tasks involved in creating, configuring, a nd monitoring a Data Guard environment. See <em class="Italic"><a class="olinkSRC DGBKR" href="../../server$101/b10822/toc.htm">Oracl e Data Guard Broker</a></em> and the Oracle Enterprise Manager online help for information about the GUI and its wizards.</p></li> <l i class="LB1" type="disc"><a name="52166"></a>Command-line interface: <ul class="LD2"> <li class="LD2" type="CIRCLE"><a name="52167" ></a>SQL*Plus</li></ul> <a name="72653"></a> <p class="BP1">Several SQL*Plus statements use the <code>STANDBY</code> keyword to spec ify operations on a standby database. Other SQL statements do not include standby-specific syntax, but they are useful for performing operations on a standby database. See <a href="sql_stmts.htm#1005574">Chapter 13</a> for a list of the relevant statements.</p> </li></ul> <a name="74614"></a> <div style="margin-left: 2em"> <ul class="LD2"> <li class="LD2" type="CIRCLE"><a name="57575"></a>In itialization parameters</li></ul> <a name="72664"></a> <p class="BP1">Several initialization parameters are used to define the Data Guard environment. See <a href="init_params.htm#87877">Chapter 11</a> for a list of the relevant initialization parameters.</p>< /div> <a name="74619"></a> <ul class="LB1"> <li class="LB1" type="disc"><a name="52189"></a>Data Guard broker command-line interface </li></ul> <a name="74624"></a> <div style="margin-left: 2em"><a name="52190"></a> <p class="BP1">The Data Guard broker command-lin e interface is an alternative to using the Enterprise Manager GUI. The command-line interface is useful if you want to use the broker to manage a Data Guard configuration from batch programs or scripts. See <em class="Italic"><a class="olinkSRC DGBKR" href="../../se rver$101/b10822/toc.htm">Oracle Data Guard Broker</a></em> for complete information.</p></div> <a name="74629"></a> <a name="52221">< /a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">2.3 <a name="SBYDB00067">Data Guar d Operational Prerequisites</a></font></h2>  <a name="72029"></a> <p class="BP">The following sections describe operat ional requirements for using Data Guard:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="72033"></a><a href="standby.htm#72 054">Hardware and Operating System Requirements</a></li> <li class="LB1" type="disc"><a name="72045"></a><a href="standby.htm#72074"> Oracle Software Requirements</a></li></ul> <a name="72054"></a>  <h3 class="H2"><font face="Arial, Helvetica, sa ns-serif" color="#330099">2.3.1 Hardware and Operating System Requirements</font></h3>  <a name="72051"></a> <p class= "BP">The following list describes hardware and operating system requirements for using Data Guard:</p> <ul class="LB1"> <li class="LB 1" type="disc"><a name="72006"></a>The operating system and platform architecture on the primary and standby locations must be the sa me. <p><a name="70743"></a></p> <p class="BP1">For example, this means a Data Guard configuration with a primary database on a 32-bi t Solaris system must have a standby database that is configured on a 32-bit Solaris system. Similarly, a primary database on a 64-bi t HP-UX system must be configured with a standby database on a 64-bit HP-UX system, and a primary database on a 32-bit Linux on Intel system must be configured with a standby database on a 32-bit Linux on Intel system, and so forth.</p></li> <li class="LB1" type="di sc"><a name="72940"></a>The hardware (for example, the number of CPUs, memory size, storage configuration) can be different between t he primary and standby systems. <p><a name="72941"></a></p> <p class="BP1">If the standby system is smaller than the primary system, you may have to restrict the work that can be done on the standby system after a switchover or failover. The standby system must hav e enough resources available to receive and apply all redo data from the primary database. The logical standby database requires addi tional resources to translate the redo data into SQL statements and then execute the SQL on the logical standby database.</p></li> <l i class="LB1" type="disc"><a name="72083"></a>The operating system running on the primary and standby locations must be the same, but the operating system release does not need to be the same. In addition, the standby database can use a different directory structure from the primary database.</li></ul> <a name="72074"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-se rif" color="#330099">2.3.2 Oracle Software Requirements</font></h3>  <a name="72071"></a> <p class="BP">The following list describes Oracle software requirements for using Data Guard:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="72093"></ a>Oracle Data Guard is available only as a feature of Oracle Database Enterprise Edition. It is not available with Oracle Database St andard Edition. This means the same release of Oracle Database Enterprise Edition must be installed on the primary database and all s tandby databases in a Data Guard configuration. <p><a name="72497"></a></p> <div align="center"> <table class="Note" border="0" widt h="80%" cellpadding="0" cellspacing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="Note"> <td class="Note"> <hr> <a name="72495"></a><font face="Arial, Helvetica, sans-serif"><strong class= "NH">Note:</strong></font> <a name="72496"></a> <p class="NB">It is possible to simulate a standby database environment with databas es running Oracle Database Standard Edition. You can do this by manually transferring archived redo log files using an operating syst em copy utility or using custom scripts that periodically send archived redo log files from one database to the other. The consequenc e is that this configuration does not provide the ease-of-use, manageability, performance, and disaster-recovery capabilities availab le with Data Guard.</p> <hr></td></tr></table></div> <a name="72535"></a> <p class="BP1">Using Data Guard SQL Apply, you will be abl e to perform a rolling upgrade of the Oracle database software from patchset release 10.1.0.<em class="Variable">n</em> to the next d atabase 10.1.0.(<em class="Variable">n+1</em>) patchset release. During a rolling upgrade, you can run different releases of the Orac le database (10.1.0.1 and higher) on the primary and logical standby databases while you upgrade them, one at a time. For complete in formation, see <a href="manage_ls.htm#1028400">Section 9.2</a> and the ReadMe file for the applicable Oracle Database 10<em clas s="Italic">g</em> patchset release.</p></li> <li class="LB1" type="disc"><a name="72703"></a>If you are currently running Oracle Data Guard on Oracle8<em class="Italic">i</em> database software, see <em class="Italic"><a class="olinkSRC UPGRD" href="../../server$101 /b10763/toc.htm">Oracle Database Upgrade Guide</a></em> for complete information about upgrading to Oracle Data Guard.</li></ul> <a n ame="74634"></a> <ul class="LB1"> <li class="LB1" type="disc"><a name="72701"></a>The primary database must run in ARCHIVELOG mode.< /li> <li class="LB1" type="disc"><a name="70686"></a>The primary database can be a single instance database or a multi-instance Real Application Clusters database. The standby databases can be single instance databases or multi-instance Real Application Clusters (RA C) databases, and these standby databases can be a mix of both physical and logical types. See <em class="Italic"><a class="olinkSRC MAXAV" href="../../server$101/b10726/toc.htm">Oracle High Availability Architecture and Best Practices</a></em> for more information about configuring and using Oracle Data Guard with RAC.</li> <li class="LB1" type="disc"><a name="70692"></a>Each primary database an d standby database must have its own control file.</li> <li class="LB1" type="disc"><a name="70693"></a>If a standby database is loca ted on the same system as the primary database, the archival directories for the standby database <em class="Italic">must</em> use a different directory structure than the primary database. Otherwise, the standby database may overwrite the primary database files.</l i> <li class="LB1" type="disc"><a name="70694"></a>To protect against unlogged direct writes in the primary database that cannot be p ropagated to the standby database, turn on <code>FORCE LOGGING</code> at the primary database before performing datafile backups for standby creation. Keep the database in <code>FORCE LOGGING</code> mode as long as the standby database is required.</li> <li class="L B1" type="disc"><a name="72861"></a>The user accounts you use to manage the primary and standby database instances must have <code>SY SDBA</code> system privileges.</li> <li class="LB1" type="disc"><a name="72862"></a>Oracle recommends that when you set up Oracle Aut omatic Storage Management (ASM) and Oracle Managed Files (OMF) in a Data Guard configuration, set it up symmetrically on the primary and standby database. That is, if any database in the Data Guard configuration uses ASM, OMF, or both, then every database in the con figuration should use ASM, OMF, or both, respectively. See the scenario in <a href="scenarios.htm#1067083">Section 10.9</a> for more information. <p><a name="72824"></a></p> <div align="center"> <table class="Note" border="0" width="80%" cellpadding="0" cellsp acing="0" dir="ltr" summary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="Not e"> <td class="Note"> <hr> <a name="72822"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">Note:</strong></font> <a name="72823"></a> <p class="NB">Because some applications that perform updates involving time-based data cannot handle data entered from multiple time zones, consider setting the time zone for the primary and remote standby systems to be the same to ensure the chro nological ordering of records is maintained after a role transition.</p> <hr></td></tr></table></div></li></ul> <a name="64472"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">2.4 Standby Database Directory Structu re Considerations</font></h2>  <a name="64473"></a> <p class="BP">The directory structure of the various standby datab ases is important because it determines the path names for the standby datafiles, archived redo log files, and standby redo log files . If possible, the datafiles, log files, and control files on the primary and standby systems should have the same names and path nam es and use Optimal Flexible Architecture (OFA) naming conventions. The archival directories on the standby database should also be id entical between sites, including size and structure. This strategy allows other operations such as backups, switchovers, and failover s to execute the same set of steps, reducing the maintenance complexity.</p> <a name="57635"></a> <p class="BP">Otherwise, you must set the filename conversion parameters (as shown in <a href="standby.htm#64022">Table 2-1</a>) or rename the datafile. Neverthel ess, if you need to use a system with a different directory structure or place the standby and primary databases on the same system, you can do so with a minimum of extra administration.</p> <a name="57643"></a> <p class="BP">The three basic configuration options a re illustrated in <a href="standby.htm#57648">Figure 2-1</a>. These include:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="57644"></a>A standby database on the same system as the primary database that uses a different directory structure than the pr imary system. This is illustrated in <a href="standby.htm#57648">Figure 2-1</a> as <code>Standby1</code>. <p><a name="62588"></ a></p> <p class="BP1">If you have a standby database on the same system as the primary database, you <em class="Italic">must</em> use a different directory structure. Otherwise, the standby database attempts to overwrite the primary database files.</p></li> <li clas s="LB1" type="disc"><a name="57645"></a>A standby database on a separate system that uses the same directory structure as the primary system. This is illustrated in <a href="standby.htm#57648">Figure 2-1</a> as <code>Standby2</code>. This is the recommended met hod.</li> <li class="LB1" type="disc"><a name="57646"></a>A standby database on a separate system that uses a different directory str ucture than the primary system. This is illustrated in <a href="standby.htm#57648">Figure 2-1</a> as <code>Standby3</code>. <p> <a name="72867"></a></p> <div align="center"> <table class="Note" border="0" width="80%" cellpadding="0" cellspacing="0" dir="ltr" su mmary="This is a layout table to format a note" title="This is a layout table to format a note"> <tr class="Note"> <td class="Note"> <hr> <a name="72870"></a><font face="Arial, Helvetica, sans-serif"><strong class="NH">Note:</strong></font> <a name="72871"></a> <p class="NB">if any database in the Data Guard configuration uses ASM, OMF, or both, then every database in the configuration should us e ASM, OMF, or both, respectively. See <a href="scenarios.htm#1005573">Chapter 10</a> for a scenario describing how to set up OM F in a Data Guard configuration.</p> <hr></td></tr></table></div></li></ul> <a name="57648"></a> <h4 class="FT"><font face="Arial, H elvetica, sans-serif"><em>Figure 2-1 Possible Standby Configurations</em></font></h4> <a name="74642"><img src="sbr81097.gif" alt="Te xt description of sbr81097.gif follows." border="0" hspace="0" vspace="0"></a> <p><a href="img_text/sbr81097.htm">Text description o f the illustration sbr81097.gif</a></p> <a name="63474"></a> <p class="BP"><a href="standby.htm#64022">Table 2-1</a> describes possible configurations of primary and standby databases and the consequences of each. In the table, note that the service name defau lts to the global database name, which is a concatenation of the database name (<code>DB_NAME</code>) and domain name (<code>DB_DOMAI N</code>) parameters. If you do not explicitly specify unique service names when the primary and standby databases reside on the same system, the same default global database name will be in effect for both the primary and standby databases.</p> <a name="64069"></a> <h5 class="TT"><a name="64069"></a><a name="64022"></a> <strong><font face="Arial, Helvetica, sans-serif"><em>Table 2-1 Stand by Database Location and Directory Options</em></font></strong></h5> <table class="RuleFormal" border="1" width="100%" cellpadding="3 " cellspacing="0" dir="ltr" title="Standby Database Location and Directory Options" summary="Describes possible configurations of pri mary and standby databases and the consequences on the directory structures of each configuration."> <thead> <tr class="Formal"> <th class="Formal" align="left" valign="bottom" scope="col"><a name="64029"></a> <font face="Arial, Helvetica, sans-serif"><strong>Standb y System</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a name="64032"></a> <font face="Arial, Hel vetica, sans-serif"><strong>Directory Structure</strong></font></th> <th class="Formal" align="left" valign="bottom" scope="col"><a n ame="64034"></a> <font face="Arial, Helvetica, sans-serif"><strong>Consequences</strong></font></th></tr></thead> <tbody> <tr class=" Formal" align="left" valign="top"> <td class="Formal"><a name="64036"></a> <p class="TB">Same as primary system</p></td> <td class=" Formal"><a name="64038"></a> <p class="TB">Different than primary system (required)</p></td> <td class="Formal"> <ul class="TLB"> <l i class="TLB" type="disc"><a name="64040"></a>You must set the <code>DB_UNIQUE_NAME</code> initialization parameter.</li> <li class=" TLB" type="disc"><a name="64041"></a>You can either manually rename files or set up the <code>DB_FILE_NAME_CONVERT</code> a<code>nd</ code> <code>LOG_FILE_NAME_CONVERT</code> initialization parameters on the standby database to automatically update the path names for primary database datafiles and archived redo log files and standby redo log files in the standby database control file. (See <a href ="create_ps.htm#68627">Section 3.1.3</a>.)</li> <li class="TLB" type="disc"><a name="66126"></a>You must explicitly set up uniqu e service names for the primary and standby databases with the <code>SERVICE_NAMES</code> initialization parameter.</li> <li class="T LB" type="disc"><a name="64048"></a>The standby database does not protect against disasters that destroy the system on which the prim ary and standby databases reside, but it does provide switchover capabilities for planned maintenance.</li></ul></td></tr> <tr class= "Formal" align="left" valign="top"> <td class="Formal"><a name="64050"></a> <p class="TB">Separate system</p></td> <td class="Formal "><a name="64052"></a> <p class="TB">Same as primary system</p></td> <td class="Formal"> <ul class="TLB"> <li class="TLB" type="disc "><a name="64054"></a>You do not need to rename primary database files, archived redo log files, and standby redo log files in the st andby database control file, although you can still do so if you want a new naming scheme (for example, to spread the files among dif ferent disks).</li> <li class="TLB" type="disc"><a name="64055"></a>By locating the standby database on separate physical media, you safeguard the data on the primary database against disasters that destroy the primary system.</li></ul></td></tr> <tr class="Formal" align="left" valign="top"> <td class="Formal"><a name="64057"></a> <p class="TB">Separate system</p></td> <td class="Formal"><a name ="64059"></a> <p class="TB">Different than primary system</p></td> <td class="Formal"> <ul class="TLB"> <li class="TLB" type="disc"> <a name="64061"></a>You can either manually rename files or set up the <code>DB_FILE_NAME_CONVERT</code> and <code>LOG_FILE_NAME_CONV ERT</code> initialization parameters on the standby database to automatically rename the datafiles (see <a href="create_ps.htm#68627" >Section 3.1.3</a>).</li> <li class="TLB" type="disc"><a name="64068"></a>By locating the standby database on separate physical media, you safeguard the data on the primary database against disasters that destroy the primary system.</li></ul></td></tr></tbody>< /table> <a name="72302"></a>  <h2 class="H1"><font face="Arial, Helvetica, sans-serif" color="#330099">2.5 Onlin e Redo Logs, Archived Redo Logs, and Standby Redo Logs</font></h2>  <a name="72303"></a> <p class="BP">The most crucia l structures for Data Guard recovery operations are online redo logs, archived redo logs, and standby redo logs. Redo data transmitte d from the primary database is received by the remote file server (RFS) process on the standby system where the RFS process writes th e redo data to archived log files or standby redo log files. Redo data can be applied either after the redo is written to the archive d redo log file or standby redo log file, or, if real-time apply is enabled, directly from the standby redo log file as it is being f illed.</p> <a name="72306"></a> <p class="BP">This documentation assumes that you already understand the concepts behind online redo logs and archived redo logs. <a href="standby.htm#72327">Section 2.5.1</a> supplements the basic concepts by providing informat ion that is specific to Data Guard configurations. <a href="standby.htm#72377">Section 2.5.2</a> provides detailed information a bout using standby redo log files.</p> <a name="72315"></a> <p class="BP">See <a class="olinkSRC ADMIN" href="../../server$101/b1073 9/toc.htm"><em class="Italic">Oracle Database Administrator's Guide</em></a> for more information about redo logs and archive logs, a nd <a href="log_apply.htm#1022886">Section 6.2.1</a> for information about real-time apply.</p> <a name="72327"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">2.5.1 Online Redo Logs and Archived Redo Logs</fo nt></h3>  <a name="72328"></a> <p class="BP">Both online redo logs and archived redo logs are required in a Data Guard environment:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="72330"></a>Online redo logs <p><a name="72331"></a></p> <p c lass="BP1">Every instance of an Oracle primary database and logical standby database has an associated online redo log to protect the database in case of an instance failure. Physical standby databases do not have an associated online redo log, because physical stan dby databases are never opened for read/write I/O; changes are not made to the database and redo data is not generated.</p></li> <li class="LB1" type="disc"><a name="72333"></a>Archived redo logs <p><a name="72334"></a></p> <p class="BP1">An archived redo log is re quired because archiving is the method used to keep standby databases transactionally consistent with the primary database. Primary d atabases, and both physical and logical standby databases each have an archived redo log. Oracle databases are set up, by default, to run in ARCHIVELOG mode so that the archiver (ARC<em class="Italic">n</em>) process automatically copies each filled online redo log file to one or more archived redo log files.</p></li></ul> <a name="72344"></a> <p class="BP">Both the size of the online redo log f iles and the frequency with which a log switch occurs can affect the generation of the archived redo log files at the primary site. T he <em class="Italic"><a class="olinkSRC MAXAV" href="../../server$101/b10726/toc.htm">Oracle High Availability Architecture and Best Practices</a></em> provides recommendations for log group sizing.</p> <a name="72345"></a> <p class="BP">An Oracle database will at tempt a checkpoint at each log switch. Therefore, if the size of the online redo log file is too small, frequent log switches lead to frequent checkpointing and negatively affect system performance on the standby database.</p> <a name="72377"></a>  <h3 class="H2"><font face="Arial, Helvetica, sans-serif" color="#330099">2.5.2 <a name="SBYDB00425">Standby Redo Logs</a></font>< /h3>  <a name="72378"></a> <p class="BP">A standby redo log is similar in all ways to an online redo log, except that a standby redo log is used only when the database is running in the standby role to store redo data received from the primary databas e.</p> <a name="72379"></a> <p class="BP">A standby redo log is required to implement:</p> <ul class="LB1"> <li class="LB1" type="di sc"><a name="72381"></a>The maximum protection and maximum availability levels of data protection (described in <a href="concepts.htm #1037159">Section 1.4</a> and in more detail in <a href="log_transport.htm#1102241">Section 5.6</a>)</li> <li class="LB1" t ype="disc"><a name="72389"></a>Real-time apply (described in <a href="log_apply.htm#1022879">Section 6.2</a>)</li> <li class="LB 1" type="disc"><a name="72394"></a>Cascaded redo log destinations (described in <a href="cascade_appx.htm#635322">Appendix C</a> )</li></ul> <a name="72395"></a> <p class="BP">Configuring standby redo log files is highly recommended on all standby databases in a Data Guard configuration, because they provide a number of advantages:</p> <ul class="LB1"> <li class="LB1" type="disc"><a name="72 396"></a>Because a standby redo log consists of preallocated files, a standby redo log avoids the operating system overhead of file s ystem metadata updates common with sequential files (such as with an archive log).</li> <li class="LB1" type="disc"><a name="72398">< /a>Standby redo log files can reside on raw devices, which may be important if either or both the primary and standby databases resid e in a Real Application Clusters environment.</li> <li class="LB1" type="disc"><a name="72400"></a>Standby redo log files can be mult iplexed using multiple members, improving reliability over archived log files.</li> <li class="LB1" type="disc"><a name="72401"></a>D uring a failover, Data Guard can recover and apply more redo data from standby redo log files than from the archived log files alone. </li> <li class="LB1" type="disc"><a name="72402"></a>The archiver (ARC<em class="Variable">n</em>) process or the log writer (LGWR) process on the primary database can transmit redo data directly to remote standby redo log files, potentially eliminating the need to register a partial archived log file (for example, to recover after a standby database crashes). See <a href="log_transport.htm#1148 215">Chapter 5</a> for more information.</li></ul> <a name="63374"></a> <p class="BP"><a href="log_transport.htm#1225705">Secti on 5.6.2</a> describes how to configure standby redo log files.</p></div> <div class="footer"> <hr> <table summary="" cellspacin g="0" cellpadding="0" width="100%"> <tr> <td style="width: 33%;" align="left"> <table summary="layout table" cellspacing="0" cellpadd ing="0" align="left" width="90"> <tr> <td align="center" valign="top"><a href="concepts.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="create_p s.htm"><img src="../../dcommon/gifs/rarrow.gif" alt="Go to next page" border="0"><br> <font size="-2">Next</font></a></td></tr></tabl e></td> <td style="width: 34%;" align="center"><img src="../../dcommon/gifs/oracle.gif" alt="Oracle"><br> <a href="../../dcommon/html /cpyr.htm"><font size="-2">Copyright © 1999, 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" va lign="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.ht m"><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> <fon t size="-2">Index</font></a></td> <td align="center" valign="top"><a href="../../mix$101/b12039/toc.htm"><img src="../../dcommon/gifs /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>