Search BC Sites

Free Oracle Tips   HTML Text

Free Oracle App Server Tips   HTML Text

Privacy Policy

Redneck

Dress Code

Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 13 - Oracle RAC Backup and Recovery

Configuration when the Standby Database Is also a Cluster (RAC-) System

The standby system may also be created in a second RAC-environment. This provides more confidence, scalability, and performance. If two identical systems can be utilized, there should be no performance and availability degradation in the case of switchover or failover. Normally, there is the same number of instances (nodes) on the standby system as on the primary system. However, this isn't required.

Essentially, we proceed as with a normal standby database creation. Full backup is taken from the primary database and the standby control file is created from any of the instances. Next, the standby system is prepared for the database by creating the RAW devices (if OCFS is not being used), creating the logical links, configuring the hardware and installing the Oracle software on each node. At this point, the backup of the primary instance can be restored, including the newly created standby control file. Next, setup the appropriate parameters in the pfile or spfile for EACH instance correctly (See the preceding section, Setting Up a Standby Database For a RAC Cluster To a Single-Instance (One Node)) and also configure the network parameter (tnsnames.ora and listener.ora) corresponding to your requirements and settings.

The greatest difference between the multi-node and single-node system is that there are now multiple standby instances and only one of them can perform the recovery.

Every primary instance transports its archive logs to a corresponding standby instance. The standby instance receiving the logs now transfers them to the instance performing the recovery. This is configured by the log_archive_dest_n parameter. It is also suggested that all standby redo logs be copied on the standby database for each standby instance. For clarification, consider this example:

Customized Oracle Training Classes

Burleson Consulting offers on-site Oracle courses year-round in a variety of Oracle topics.  All on-site Oracle training can be custom fit to meet your specific training needs.  For customized syllabus development or a price quote, please visit www.fast-track.cc or email .