Use Netapp snapmirror to create DR for Oracle RAC with ASM

  • From: Limin Guo <lguo.oracle@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 11 Sep 2013 11:58:21 -0400

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.


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


Other related posts: