Our Oracle databases are on Windows 2003 servers with the files on NetApp storage using iSCSI. We use scripts to:
1. Take the database into hot backup mode 2. Take snapshots (using Snapdrive for Windows) of the data LUNs 3. Take the database out of hot backup mode 4. Take snapshot of the archive log LUN (using Snapdrive for Windows)
Snapdrive for Windows has a command line switch that we use to automatically trigger a snapmirror update when the snapshot is taken. Once the snapshots are taken we then use scripts to update the snapvault on our FAS6070 from the snapshot we just took. As soon as that is complete we take a snapshot on the FAS6070 to keep some number readily available online. Once that snapshot has been taken, we then start a backup to tape from that snapvault volume. Those tapes are then removed from the libraries and stored in a fireproof safe.
Early on, we did some analysis with our DBA's and determined that using snapshots would be faster and utilize much less WAN bandwidth than using Oracle's tools.
On 10/17/07, Page, Jeremy jeremy.page@gilbarco.com wrote:
Looking for someone out there with some experience with pSeries + Oracle. Is SnapVault, SnapMirror, Snapshot used as common replication tools for Oracle in the General Public versus native Oracle Replication or Snapshots? Long ago we also looked at Native clustering / replication tools at the P-Series level. Just curious on how many companies use the SAN replication tools for Oracle. I'd appreciate any insight you might have and I'll try and do some research on this.
From a storage admin side I was assuming it's as simple as creating a shell script that quiesces Oracle, takes a snapshot and then lets Oracle move on with it's life, am I missing something?
-Jeremy
This message (including any attachments) contains confidential and/or proprietary information intended only for the addressee. Any unauthorized disclosure, copying, distribution or reliance on the contents of this information is strictly prohibited and may constitute a violation of law. If you are not the intended recipient, please notify the sender immediately by responding to this e-mail, and delete the message from your system. If you have any questions about this e-mail please notify the sender immediately.