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.