 |
|
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
Instance
v10g1:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac1/archives1)
LOG_ARCHIVE_DEST_2=(SERVICE=v10g3 LGWR ...)
LOG_ARCHIVE_FORMAT=arc_%s_%t
Instance
v10g2:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac2/archives2)
LOG_ARCHIVE_DEST_2=(SERVICE=v10g4 LGWR ...)
LOG_ARCHIVE_FORMAT=arc_%s_%t
Now we
designate instance v10g4 as the recovering instance (it can be either
v10g3 or v10g4). This means that the archive logs from the instance
v10g3 have to be transferred to instance v10g4. Instance v10g4 is also
performing the archiving to disk process (again, on the shared disk
that is available for both standby instances). The resulting settings
for instance v10g3 and v10g4 are:
Instance
v10g3:
LOG_ARCHIVE_DEST_1=(SERVICE=v10g4 ARCH SYNC)
Instance
v10g4:
LOG_ARCHIVE_DEST_1=(location=/usr/backup/v10g_rac4/archives4)
Once this
is complete, the startup nomount and alter database mount standby
database commands can be issued for all instances and the recovering
instance can be put into recovery Mode.
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
 .
|
