Hello Zaki,
First of all you should carefully consider if you really want to synchronously mirror the data. Especially if the target of mirror is R200 with SATA disks. Such a configuration would introduce huge performance degradation as compared to unmirrored config, especially in terms of write latency and IOPS.
You have 2 options: 1. use FC-disk as target, performance impact will be lowered significantly This way you can avoid IOPS bottleneck of SATA drives 2. use semi-sync or async replication if your RPO (recovery point objective) allows it If properly designed can lower perf impact to +0 even with SATA as target
In any case you can put database in hot backup mode and take snapshots of all data volumes on primary system. When you should take snapshot of archive redo logs volume. In this case Oracle will recover database successfully on secondary site even if data files placed on different aggregates and/or FAS-systems. The only difference between 1 and 2 is how quickly this snap will pop out on secondary system. Also in sync mode you will get crash consistent copy (all committed transactions are in place) of data on secondary site in case of disaster, in async/semi-sync mode you will probably lose some recent transactions.
BR, Alexander.
Network Appliance Simplifying Data Management
Alexander Fakanov tel: +7 495 937 8791 Project Manager fax: +7 495 771 7149 mob: +7 495 765 8475
Regus Business Center,750 Smolenskaya Square,3 alexander.fakanov@netapp.com 121099 Moscow, Russia
-----Original Message----- From: Hussain, Zaki H. [mailto:zaki.hussain@aramco.com] Sent: Sunday, May 06, 2007 10:38 To: toasters@mathworks.com Subject: Oracle on NetApp NFS
Hello all,
We are about to start testing Oracle 9i (single instance) with NetApp NAS (6070) filers. We currently have Oracle running on Solaris 9 with SAN storage attached and VERITAS.
We know that Oracle is supported on NAS, and we should have a great success potential. We also plan to synchronously mirror the data to another NAS system (R200). My question is following, can we put the database in a hot backup mode, then take a snapshot of the database file system. We will then break the mirroring, and start the database on another server that is mounting the database file system from the R200?
Any recommendations or suggestions are welcome.
Thanks.......