Use Netapp snapmirror to create DR for Oracle RAC with ASM

From: Limin Guo <lguo.oracle_at_gmail.com>
Date: Wed, 11 Sep 2013 11:58:21 -0400
Message-ID: <CANxNJmMYO5rs_h8cuAbf3ryAvM5GQikcvGsvG93os3YpcHr58A_at_mail.gmail.com>

I am trying to figure out a solution to utilize NetApp snapmirror to setup a DR site for the primary databases, which are two nodes Oracle RAC databases with ASM, to replace Oracle Data Guard, which is currently being used. The database servers on both primary and DR sites are Solaris 10. The primary site database on Oracle 10.2 RAC with ASM. The DR database can be on ASM or NFS, but I guess if using NetApp utility, such as snapmirror, the database on DR site has to be on ASM, correct? I am also puzzling if DR site has to mimic the primary setup and has to be two node RAC with ASM since snapmirror copying redo logs from both instances from the primary site.

If you have done similar setup, I'd appreciate if you could share some technical details with me. Thank you in advance.

Two volumes are created on NetApp FAS3140. One is for Oracle cluster OCR and voting disks, and the other is for Oracle ASM.

ASM configuration info:

Two diskgroups are created on 10 LUNs. One for database files (7 luns) and the other is for Oracle FRA (3 luns).

NetApp FAS3140 configuration info:

*LUN Information

Oracle Cluster Registry
VOLUMELUNSIZEINITIATOR GROUPLUN ID
*OracleCL_RAC_vol/vol/OracleCL_RAC_vol/Cluster_LUN1/Cluster_
LUN1520MBTUMACTIVECLUST1 OracleCL_RAC_vol/vol/OracleCL_RAC_vol/Cluster_LUN2/Cluster_ LUN2520MBTUMACTIVECLUST2 OracleCL_RAC_vol/vol/OracleCL_RAC_vol/Cluster_LUN3/Cluster_ LUN3300MBTUMACTIVECLUST3 OracleCL_RAC_vol/vol/OracleCL_RAC_vol/Cluster_LUN4/Cluster_ LUN4300MBTUMACTIVECLUST4 OracleCL_RAC_vol/vol/OracleCL_RAC_vol/Cluster_LUN5/Cluster_ LUN5300MBTUMACTIVECLUST5
*

Database
VOLUMELUNSIZEINITIATOR GROUPLUN ID
*OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN1/DB_LUN1100GBTUMACTIVECLUST11

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN10/DB_LUN10100GBTUMACTIVECLUST20

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN2/DB_LUN2100GBTUMACTIVECLUST12

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN3/DB_LUN3100GBTUMACTIVECLUST13

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN4/DB_LUN4100GBTUMACTIVECLUST14

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN5/DB_LUN5100GBTUMACTIVECLUST15

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN6/DB_LUN6100GBTUMACTIVECLUST16

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN7/DB_LUN7100GBTUMACTIVECLUST17

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN8/DB_LUN8100GBTUMACTIVECLUST18

OracleDB_RAC_vol/vol/OracleDB_RAC_vol/DB_LUN9/DB_LUN9100GBTUMACTIVECLUST19

Thank you in advanced for any suggestions and recommendations.

Limin.

-- 
Regards,

Limin Guo.


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

Received on Wed Sep 11 2013 - 17:58:21 CEST