All:
Re: "Specifically they mentioned a situation they had experienced while testing a netapp/oracle environment which would cause total corruption and require restoration from backup. The specific situation is a case where the filer loses power but the DB server doesn't. Their claim is that if this occurs there is no method to recover the DB other than from backup."
I was responsible for testing Network Appliance filers to obtain certification for our storage products by Oracle corporation, as part of the Oracle Storage Compatibility Program (OSCP). See: http://www.oracle.com/database/storage/vendors.html.
A major portion of the OSCP test suite had to do with abruptly powering off the filer while the database server stayed up (as well as powering off the database server while the filer stayed up, etc.).
NetApp filers passed all of these tests to the satisfaction of Oracle Corporation. The position of Oracle Corporation today is that NetApp filers are an appropriate storage technology for storing Oracle database files, as evidenced by the URL I show above.
If you have any further questions on this issue, please contact me directly.
Jeff Browning O.C.P. M.C.S.E. Manager of Database Performance Network Appliance, Inc.
----- Forwarded message from foo foo@eek.org -----
From: foo foo@eek.org To: toasters@mathworks.com Subject: Oracle and NTAP.
Ok, so we've been contemplating using one of our 760's for Oracle storage. Discussions with Netapp people made me feel relatively warm and fuzzy about doing this but discussions with our DBA consultants didn't. Specifically they mentioned a situation they had experienced while testing a netapp/oracle environment which would cause total corruption and require restoration from backup. The specific situation is a case where the filer loses power but the DB server doesn't. Their claim is that if this occurs there is no method to recover the DB other than from backup.
Anyone had any experience with Oracle/Netapp or this specific situation? We plan to test this in the next few days, but I wanted to get any insights you all might have.
Thanks,
-Brian
----- End forwarded message -----