Re: HACMP automatic Oracle failover in non-RAC environment


Dan,
Our HACMP clusters the crontabs and software  is shared  which basically helps 
it failover with the system.
This eliminates the hassle of worrying about 2 crontabs. As far as backups go 
legato has pretty good API to manage HACMP nodes for non RAC system. 

----- Original Message ----
From: Dan Norris <dannorris@xxxxxxxxxxxxx>
To: DIANNA.GIBBS@xxxxxxxxxxxxx
Cc: oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, August 27, 2008 8:51:29 PM
Subject: Re: HACMP automatic Oracle failover in non-RAC environment

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@xxxxxxxxxxxxxx Children's Medical Center Dallas and its
affiliates hereby claim all 
applicable privileges related to this information.


-- http://www.freelists.org/webpage/oracle-l

Other related posts: