Newsletters Archive - 2010

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

  Data Guard Configuration Example, Oracle 10g, Physical Standby — (10-December-2010)

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 
physical 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, Physical Standby)

It should be noted that several different methods exist to create a physical 
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 standby database, you will see that it is essentially 
nothing more than taking a backup of the primary database, creating a standby 
controlfile, transferring the files to the standby host, mounting the standby 
database, putting the standby database in managed recovery mode (Redo 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 

Jeffrey M. Hunter, OCP
Sr. Database Administrator