We have several DB's running as single instance but we also have a lot of RAC Clusters. Both installations are based on Linux. The experience we got with oracle on netapp is quite good, but with our RAC's we didn't make the best experiences. Backing up Oracle DB's on NFS with snapshot technology is very handsome. As mentioned recovering a full DB under a minute is nearly unbeatable. We use self written scripts to backup DB's and their archive logs.
What are your experiences with rac clusters over gigabit nfs? What kind of filers do you use? I would be interested in some details of you environement with Oracle RAC on Linux and NetApp. Today we are in discussion of response times and throughput rates. I would like to share some experiences.
Regards Andreas -----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.