Oh you just need a DBA to talk to your DBAs then.

Snapshot and snapmirror.

As long as you get everything in the same  "oracle seq number set" for the existing redo logs.

Basically, Oracle will handle the warm restart for you on those datafiles. 

Basically, you can power cycle an Oracle server and it will detect it was already running and "recover" itself. 

The warm restart takes all the data files and redo files and reapplies any changes to recover to the last oracle consistency point.

We used to have a complex backup system of many servers, and tape, and cronscripts.  It would take days to backup.  I estimated a month to recover.  I wasn't sleeping well back then.

Now we Snapmirror.  It is backed up every hour that way.

We can do a filer failover in about 15 minutes because of the design.

That is why my heart flutters when I think of Oracle on NetApp.  I like to get my sleep.

Cheers,

Joe Bishop



Brian Dunbar wrote:
RE: Oracle on Netapp

Our experience is similar to your, Daniel, except that we do not use RAQ or Linux.

I would not say our DBA team resisted the idea - merely that they were hesitant that it would actually work.  They're good guys and paid to be cautious.

Brian Dunbar
Systems Administrator
Plexus
Desk: (920) 751-3364
Cell: (920) 716-2027



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


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.