Re: HACMP automatic Oracle failover in non-RAC environment

From: Dan Norris <dannorris_at_dannorris.com>
Date: Wed, 27 Aug 2008 20:51:29 -0500
Message-ID: <48B604A1.1050804@dannorris.com>




  


I've been around lots of failover clusters like these and one of the
challenges that I've seen in these environments is scheduling routine
scheduled tasks. Often, crontab is used to start backups and in a
failover cluster (especially when all nodes are treated equally instead
of having a "primary" and "backup" node) and this poses a problem since
crontab isn't "cluster-aware". This is a great time to get familiar
with the DBMS_SCHEDULER interface that allows you to kick off shell
scripts. That way, you'll always ensure that the backup script will run
on the same node where the DB instance runs since the instance starts
its own backup. 

Other than that little tidbit, there shouldn't be anything else that would be dramatically different. Just make sure that you put all the pieces of the database on the proper storage locations (locations that will either be failed over or that are available to all nodes). I'd also recommend scheduling a failover test at least a couple times every year just to make sure that you aren't surprised by a non-starting instance during a failover time.

Dan

DIANNA GIBBS wrote:

Is anyone currently doing or have any thoughts or comments
on using AIX HACMP automatically to fail-over Oracle in a non-RAC
environment.
 
Do I need to worry about data corruption or anything else?  We have
manually done this and I've restarted Oracle, shutdown cleanly
and then restarted again.  Done my sanity checks and all has been
ok. 
 
I've been ask about automating this failover w/scripts.  My thoughts are
I need to control this process and be aware but I also realize
hardware and software are becoming more and more sophisticated.
 
Thoughts?
 
Please consider the environment before printing this e-mail

This e-mail, facsimile, or letter and any files or attachments transmitted with it contains
information that is confidential and privileged. This information is intended only for the use of the
individual(s) and entity(ies) to whom it is addressed. If you are the intended recipient, further
disclosures are prohibited without proper authorization. If you are not the intended recipient, any
disclosure, copying, printing, or use of this information is strictly prohibited and possibly a
violation of federal or state law and regulations. If you have received this information in error,
please notify Children's Medical Center Dallas immediately at 214-456-4444 or via e-mail at
privacy@childrens.com. Children's Medical Center Dallas and its affiliates hereby claim all
applicable privileges related to this information.


-- http://www.freelists.org/webpage/oracle-l Received on Wed Aug 27 2008 - 20:51:29 CDT

Original text of this message