Call for Oracle support & training (800) 766-1884
Free Oracle Tips

Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients


Free Oracle Tips


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


Remote Oracle

Custom Oracle Training


  Oracle Tips by Burleson

Oracle 10g Failover in RAC

With Oracle Database 10g, support for streams in the Oracle RAC environment has been considerably extended. In prior releases, whenever a failure of a RAC instance occurred, there was a bit of manual work in restarting the capture or apply processes. And also for capturing the events, archive logs were read instead of online redo log files. These two issues have been enhanced.

Now, the following actions occur automatically when an instance failure occurs:

  • Each queue that was previously owned by the failed instance is assigned to a new instance.

  • The capture process is restarted automatically on the new instance.

  • All propagation jobs are automatically migrated to the new instance.

  • The apply process is restarted automatically on the new instance.

However, there are still some actions that need to be taken by the streams administrator:

  • For propagations that were configured with the failed instance as the destination, drop the database link and recreate it using the same global name, but pointing to the failover instance.

  • For propagation at the failover instance, verify the dynamic initialization parameter job_queue_processes is greater than zero.

To improve the performance of streams for a RAC database, a capture process can now capture changes from the archived redo logs or from the online redo. When it reads the redo log files, it is known as Hot-Mining. This feature allows changes to be captured closer to the time they were executed, reducing the capture latency.

Get the complete story:

The above text is an excerpt from "Oracle Database 10g New Features: Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:


Oracle performance tuning book



Oracle performance tuning software

Oracle performance tuning software
Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel


email BC:

Copyright 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle is the registered trademark of Oracle Corporation.