ASM and Linux Pacemaker Cluster
dannyBoyJul 10 2012 — edited Jul 16 2012Hi all,
My company is planning to implement ASM and I am tasked to evaluate the possibility to integrate ASM with our current infrastructure system.
We are currently running Oracle 11.2.0.2 on Linux SLES 11 clustered with Pacemaker. The cool feature of Pacemaker is that it is able to failover one database although there are multiple databases on the same server. In other words, failure of 1 database will not affect the other databases residing on the same server. We can easily failover only 1 database.
My question is: Is it possible for a single ASM-based database to failover to the other node without having to cause other databases on the same server to failover as well? Clusterware does not allow this as stated below:
********************************************************************************************************************************************
Extracted from: http://docs.oracle.com/cd/E11882_01/server.112/e18951/asmcon.htm
Oracle ASM instances can be clustered using Oracle Clusterware; there is one Oracle ASM instance for each cluster node. If there are several database
instances for different databases on the same node, then the database instances share the same single Oracle ASM instance on that node.
If the Oracle ASM instance on a node fails, then all of the database instances on that node also fail. Unlike a file system driver failure, an Oracle ASM instance
failure does not require restarting the operating system. In an Oracle RAC environment, the Oracle ASM and database instances on the surviving nodes
automatically recover from an Oracle ASM instance failure on a node.
********************************************************************************************************************************************
Since Clusterware does not support single-database failover, I am actually thinking of setting up two separate ASM instances on two different servers (OS-clustered without Oracle Clusterware). Both ASM instances are active at the same time so that when the database fails over from node 1 to node 2, the ASM instance on ASM 2 is already ready to bring up the database. However, the question will be: Is it possible to register one database in two different ASM instances?
Thank you
Regards,
Richard