Whatever topic has been discussed on this blog is my own finding and views, not necessary match with others. I strongly recommend you to do a test before you implement the piece of advice given at my blog.
My upcoming webinar 'Managing & Troubleshooting Cluster - 360 degrees' sponsored/arranged by RedGate is scheduled on 25th April 2013. The following topic will be covered during the course of the presentation:
What's new in 11gR2
Clusterware – Key new features at a glance
Oracle 11gR2 Clusterware software stack
Clusterware start up sequence
CRS logs & directory tree structure
Analyzing CRS logs
CRS logs rotation/retention policy
Troubleshooting Cluster start up
issues
Debugging/Tracing CRS components
Tools & Utilities – how to pick the
right one
Q&A
If you haven't enrolled yet, enroll now. Registration is limited!.
I am afraid, it is not a so good news for those who manage 11.2.0.1|2 RAC databases. On a very unfortunate day, an RAC database db | instance shutdown normal|transactional|immediate mode could result in an ORA-600 errors or may cause logical corruption to the redo stream .
According to the MOS ID [1318986.1] , when a RAC instance(s) (11.2.0.1|2) shutdown either in normal|transactional|immediate mode, there could be possibilities, under certain circumstances, of hitting the bug.1020523which could produce either pool of ORA-600 errors or might also corrupt the data. The following workaround is suggested in the note:
For complete RAC database shutdown:
SQL> alter system checkpoint; srvctl stop database -d <db_uniqueue_name> -o abort -f
For one or more RAC instances, run the below for each instance:
SQL> alter system checkpoint local; SQL> shutdown abort; or
-- as the shutdown abort -f option complete by-pass the vulnerable code path of the bug:
The known downstream effect includes the following:
* Data corruption occurs around shutdown one or more of the RAC instances
* One of the following ORA-600 asserts:
- ORA-600 [kclchkblk_3]
- ORA-600 [kclwcrs_6]
- ORA-600 [ktubko_1]
- ORA-600 [kcratr_scan_lostwrt]
- ORA-600[3020] on the standby database
You may also refer to my earlier post discussion about choosing a quick database shutdown mode.
The IOUG Cloud Computing Special Interest Group (SIG) is
dedicated to communication and information interchange around the
subject matter of Cloud Computing centric to Oracle. The main purpose of the SIG is to discuss and share independent
thought, challenges, options, and best practices on key areas of Cloud
Computing from the perspective of Oracle. Topics will be discussed
freely in this open forum and touch on prevalent Cloud Computing
Paradigms/Technologies. The IOUG Cloud Computing SIG is led by the following thought leaders in the Oracle Community:
· President - Tariq Farooq, BrainSurface - Oracle ACE Director
· Vice President - George Trujillo, HortonWorks - Oracle ACE
Just a very quick update about the upcoming event in your city (India).
If you are around in India, don't miss the OTNYathra event scheduled between 15 & 27 February 2013. Many world known Oracle ACE Directors, Java champions and other experts are presenting. For more details and registration, visit the following links:
