Oracle DBA Tips Corner
Return to the Oracle DBA Tips Corner.
|
Oracle DBA Tips Corner
|
Oracle10g Data Guard Configuration Example - (Physical, Maximum Performance Mode)
by Jeff Hunter, Sr. Database Administrator
Contents
Overview
This article provides detailed instructions for creating
and configuring a physical standby database from a primary database
in Oracle10g Release 2 (10.2). After creating and configuring
the physical standby database, I will then go into the details of Role
Transitions using both switchover and failover
operations and when to use either of them.
To keep the article simple, I will
be using a protection mode of Maximum Performance. (Maximum
Performance is the default protection mode.)
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.
Introduction to Data Guard
With the introduction of Oracle9i, Oracle has since then
changed the name of Standby Database to Oracle Data Guard.
The Data Guard software product in Oracle10g is used to maintain a standby database, or
real-time copy of a primary database. When the standby database site is
hosted in a different geographical location than the primary site, it provides
for an excellent High Availability (HA) solution. When creating a standby database
configuration, the DBA should always attempt to keep the primary and standby database
sites identical as well as keeping the physical location of the production database
transparent to the end user. This allows for an easy switchover scenario for both
planned and unplanned outages. When the secondary (standby) site is identical to the
primary site, it allows predictable performance and response time after failing over
(or switching over) from the primary site.
Hardware and O/S Configuration
Configuring the Primary Database
Configuring the Standby Database
Start Remote Archiving
Verifying the Physical Standby Database
Role Transitions
Which Role Transition Operation Should I Use?
Implementing Role Switchover Operations
Implementing Role Failover Operations
Further Reading
About the Author
All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter
and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express,
prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.
I have made every effort and taken great care in making sure that the material included on my web site is technically accurate,
but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from
relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.
Oracle Data Guard (known as Oracle Standby Database
prior to Oracle9i), provides organizations with
high availability, data protection, and disaster recovery
for enterprise databases with extraordinary ease of use.
The DBA has many services included with Oracle Data Guard
for creating, maintaining, managing, and monitoring one or more
standby database instances. Oracle Data Guard provides
functionality to enable enterprise data systems to
survive both data corruption as well as major disasters.
For a detailed discussion on the various Oracle Data Guard protection modes, see my article
entitled "Data Protection Modes".
The Standby Database feature of Oracle was first introduced in Oracle
Release 7. Since then Oracle has added many new features to the standby
database option, making it an excellent choice for your high availably requirements.
Now, let's take a look at the Oracle database configuration and parameters
we will be using for our physical standby database configuration.
Primary Database
Oracle Release:
Oracle10g Release 2 - (10.2.0.3)
Machine Name:
vmlinux3.idevelopment.info
Operating System:
Red Hat Linux 4 - (CentOS 4.5)
Oracle SID:
TESTDB
Instance Service Names:
TESTDB.IDEVELOPMENT.INFO
TNS Service Name:
TESTDB_VMLINUX3.IDEVELOPMENT.INFO
Standby Database
Oracle Release:
Oracle10g Release 2 - (10.2.0.3)
Machine Name:
vmlinux4.idevelopment.info
Operating System:
Red Hat Linux 4 - (CentOS 4.5)
Oracle SID:
TESTDB
Instance Service Names:
TESTDB.IDEVELOPMENT.INFO
TNS Service Name:
TESTDB_VMLINUX4.IDEVELOPMENT.INFO
Additional information on Oracle10g Release 2 Data Guard
can be found in the Data Guard Concepts and Administration.
This guide is available from the Oracle Documentation Library
website located at the following address
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239.pdf.
Jeffrey Hunter graduated from Stanislaus State University in Turlock,
California, with a Bachelor's degree in Computer Science. Jeff is an
Oracle Certified Professional, Java Development Certified Professional,
Author, and currently works as a Senior Database Administrator for
The DBA Zone, Inc..
His work includes advanced performance tuning, Java and PL/SQL programming, capacity
planning, database security, and physical / logical database design in a UNIX,
Linux, and Windows server environment. Jeff's other interests include mathematical
encryption theory, programming language processors (compilers and interpreters)
in Java and C, LDAP, writing web-based database administration tools, and of
course Linux. Jeff has been a Sr. Database Administrator and Software Engineer
for over 13 years and maintains his own website site at:
http://www.iDevelopment.info.
Wednesday, 02-Jan-2008 16:07:27 EST
Page Count: 2990