Re: HACMP automatic Oracle failover in non-RAC environment

We are currently using this to failover for hardware errors but not for database errors. Since database errors have to be evaluated in an HACMP environment but in case an hardware issue arises we have graceful shutdown scripts embeeded in the HA scripts scripts and sanity checking built into the scripts on failover before a database is brought up.

• Original Message ---- From: DIANNA GIBBS <DIANNA.GIBBS_at_childrens.com> To: oracle-l-freelists <oracle-l_at_freelists.org> Sent: Wednesday, August 27, 2008 4:25:38 PM Subject: HACMP automatic Oracle failover in non-RAC environment

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_at_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 - 18:51:13 CDT