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

Home
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


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

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:

http://rampant-books.com/book_2003_2_oracle10g.htm


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:

http://www.dba-oracle.com/service_oracle_backup.htm

 
 
 

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.