0 Replies Latest reply: Aug 29, 2013 7:39 AM by lguo.us@gmail.com RSS

How to use snapmirror to create DR for Oracle RAC with ASM

lguo.us@gmail.com
Currently Being Moderated

I am trying to figure out a solution to utilize NetApp utilities to setup a DR site for Oracle RAC database 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?

 

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

 

ASM configuration info:

 

Two diskgroups are created on 10 LUNs. One for database files and the other is for Oracle FRA.

 

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.

More Like This

  • Retrieving data ...