| |
 |
|
Oracle Tips by Burleson |
Oracle10g Grid Computing
with RAC
Chapter 13 - Oracle RAC Backup and Recovery
Recovery in
the RAC Environment
Reconfiguration complete
Post SMON
to start 1st pass IR
Sat Feb 15
16:39:10 2003
Instance
recovery: looking for dead threads
Sat Feb 15
16:39:10 2003
Beginning
instance recovery of 1 threads
Sat Feb 15
16:39:10 2003
Started
first pass scan
Sat Feb 15
16:39:11 2003
Completed
first pass scan
208 redo
blocks read, 6 data blocks need recovery
Sat Feb 15
16:39:11 2003
Started
recovery at
Thread 2:
logseq 26, block 14, scn 0.0
Recovery of
Online Redo Log: Thread 2 Group 4 Seq 26 Reading mem 0
Mem# 0
errs 0: /oracle/oradata/v10g_rac/v10g_rac_raw_rdo_2_2.log
Recovery of
Online Redo Log: Thread 2 Group 3 Seq 27 Reading mem 0
Mem# 0
errs 0: /oracle/oradata/v10g_rac/v10g_rac_raw_rdo_2_1.log
Sat Feb 15
16:39:12 2003
Completed
redo application
Sat Feb 15
16:39:12 2003
Ended
recovery at
Thread 2:
logseq 27, block 185, scn 0.5479311
6 data
blocks read, 8 data blocks written, 208 redo blocks read
Ending
instance recovery of 1 threads
SMON: about
to recover undo segment 11
SMON: mark
undo segment 11 as available
Figure 9.15:
Alert Log Entries During Reconfiguration
One word of caution, during testing for the listing in Figure 9.15, an
instance could not be brought back up after failure, a rare
occurrence. A "kill -9" was done on the SMONprocess on
aultlinux1, within the Linux/RAC/RAW environment. aultlinux2
continued to operate and recovered the failed instance, however, an
attempted restart of the instance on aultlinux1 yielded a Linux Error:
24 : Too Many Files Open error. This was actually caused by something
blocking the spfile link. Once the instance was pointed towards the
proper spfile location during startup, it restarted with no problems.
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
 .
|
