We have over 30 oracle database instances running on both linux and solaris over gigabit nfs.  Some are standalone and others raq clusters.  There is a product from netapp called snapmanager for oracle but we currently do not use it, instead we just utilize scripts that either put the instance in hot backup mode or brings the db down for cold backup and then initiates a snapshot on the filer.  We snapvault the primary snapshot data to a secondary R200 as well.

This scenario works flawlessly and anything from single file restores to entire volume restores take seconds and always work.  There was a bit of hesitation implementing this at first but the first time you recover a database completely in under a minute your DBA's will be on board.

--daniel


--
Daniel Leeds
Manager, Storage Operations
Edmunds, Inc.
1620 26th Street, Suite 400 South
Santa Monica, CA 90404

310-309-4999 desk
310-430-0536 cell



-----Original Message-----
From: owner-toasters@mathworks.com on behalf of Page, Jeremy
Sent: Wed 10/17/2007 5:05 AM
To: toasters@mathworks.com
Subject: Oracle on Netapp

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.