Newsletters Archive - 2011

If you would like to know more about the iDevelopment.info Newsletter, please email me.


  Data Guard Configuration Example, Oracle 10g, Logical Standby — (17-January-2011)

Oracle Data Guard (known as Oracle Standby Database prior to Oracle9i), forms 
an extension to the Oracle RDBMS and provides organizations with high 
availability, data protection, and disaster recovery for enterprise databases. 
Oracle Data Guard provides the DBA with services for creating, maintaining, 
managing, and monitoring one or more standby databases. The functionality 
included with Oracle Data Guard enables enterprise data systems to survive both 
data corruption as well as major disasters. 

The following article provides instructions for creating and configuring a 
logical standby database from a primary database using Oracle Database 10g 
Release 2 (10.2) operating in maximum performance protection mode:

Data Guard Configuration Example - (Oracle 10g, Logical Standby)

It should be noted that several different methods exist to create a logical 
standby database configuration and that this is just one of those ways. The 
methods outlined in this guide present a simple approach that should be easy to 
implement in most situations. In fact, if you break down the essential tasks 
required to build a logical standby database, you will see that it is 
essentially nothing more than creating an initial physical standby database, 
building a dictionary in the redo data for LogMiner, verifying supplemental 
logging is enabled on both the primary and standby, converting the physical 
standby database to a logical standby database, putting the logical standby 
database in managed recovery mode (SQL Apply), and starting remote archiving 
from the primary database (Redo Transport). Obviously there are a number of 
smaller steps I am leaving out which will all be discussed in more depth 
throughout this guide. 

All configuration parameters related to the Oracle instance and networking will 
be discussed as well as how to place the standby database in Managed Recovery 
Mode. 

----------------------------
Jeffrey M. Hunter, OCP
Sr. Database Administrator
jhunter@idevelopment.info
http://www.idevelopment.info
----------------------------