 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 13 - Oracle RAC Backup and Recovery
Log Shipping
when the Standby Database Is a Single Node System
If the RAC-standby
configuration is on a single node system, the prerequisites are the
same. The difference is that all instances from the primary database
have to ship their archive logs to one single system. Due to the
information (SCNs) in the archive logs, the managed recovery process (MRP)
on the standby database determines the correct order to apply the
archive logs from the different threads on the Standby Database.
Therefore, we now have, as the primary instances in our example,
instance v10g1 and v10g2. The single node standby instance is v10g3.
This results in these settings for log_archive_dest:
Instance
v10g1 and v10g2:
v10g1:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac1/archives1)
LOG_ARCHIVE_DEST_2=(SERVICE=v10g3 LGWR ...)
Instance
v10g2:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac2/archives2)
LOG_ARCHIVE_DEST_2=(SERVICE=v10g3 LGWR ...)
We must also
create different standby redo log threads on the standby database.
Instance v10g3 now receives all the logs and applies them to the
standby database.
Instance
v10g3:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac3/archives3)
For more information,
see the book
Oracle 11g Grid and Real Application Clusters - 30% off if
you buy it directly from Rampant TechPress .
Written by top
Oracle experts, this RAC book has a complete online code depot with
ready to use RAC scripts.
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
 .
|
