Use Netapp snapmirror to create DR for Oracle RAC with ASM

[Limin Guo]

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.

[Austin Hackett]

Hi Limin

We're a NFS and NetApp shop, but I've never tried this as we use Data Guard for DR. However, did you see this NetApp technical report: http://www.netapp.com/us/media/tr-3455.pdf?

In the example, the source DB uses NFS, but off-hand I would think it should work for ASM too. Presumably, you'd need additional steps to mount the ASM disk groups after braking the mirror. Given that the solution involves recovering the database from a broken mirror, you could amend the DR parameter file to have less instances than the primary DB and once the DB is open, disable the redundant redo threads.

Hope the helps

Austin


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

[kyle Hailey]

What advantage to you want to get by using Netapp instead of Data Guard?
Data Guard the defacto standard for fail over. Using Netapp snapmirror is
more appropriate for features such as thin cloning databases. Check out
http://www.kylehailey.com/delphix/delphix-oracle-12c/

Synchronizing database on a source Netapp array with a remote Netapp array
is suprisingly complicated. Here most relevant Netapp paper I've found
http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-3761.pdf&cc=us

Of course all of this is simple with Delphix. If you have questions about
Delphix join Jonathan Lewis and I next Tues for a Q&A session
http://www.kylehailey.com/sample-page/current/


- Kyle
http://kylehailey.com


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

[Limin Guo]

One of our client is trying to move away from Oracle Data Guard due to the
Oracle licensing costs, and, instead, they want to use NetApp snapmirror
for the DR. If the primary database is single instance without ASM, the
snapmirror solution is not too hard to implement.
Thanks for the information, Kyle, Austin and John.

Limin.

Post by kyle Hailey
What advantage to you want to get by using Netapp instead of Data Guard?
Data Guard the defacto standard for fail over. Using Netapp snapmirror is
more appropriate for features such as thin cloning databases. Check out
http://www.kylehailey.com/delphix/delphix-oracle-12c/
Synchronizing database on a source Netapp array with a remote Netapp array
is suprisingly complicated. Here most relevant Netapp paper I've found
http://www.netapp.com/us/system/pdf-reader.aspx?m=tr-3761.pdf&cc=us
Of course all of this is simple with Delphix. If you have questions about
Delphix join Jonathan Lewis and I next Tues for a Q&A session
http://www.kylehailey.com/sample-page/current/
- Kyle
http://kylehailey.com
--
http://www.freelists.org/webpage/oracle-l