RE: San & single point of failure

  • From: "Michael Fontana" <mfontana@xxxxxxxxxxx>
  • To: "'oracle_l'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 17 Nov 2008 15:27:05 -0600 (CST)

I've lost a san and had local controlfiles.

From them I was able to ascertain where the files were so that when the
SAN was rebuilt (which in this case it had to be), we knew exactly what
directories needed to be restored (which our san admins had no idea -
shame on them).  

You could also ascertain, from the controlfiles, what your recovery
options are BEFORE restoring from backup, which could save some time.
RMAN should still come up!




-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Allen, Brandon
Sent: Monday, November 17, 2008 3:23 PM
To: rjoralist@xxxxxxxxxxxxxxxxxxxxx; oracle_l
Subject: RE: San & single point of failure

I don't understand what good it does to have the control file alone on
your local disk in that situation?  If your SAN with the rest of your
database files is toast, then your control file alone isn't going to do
you much good.  You're going to have to restore from a backup and do an
incomplete recovery anyway, so what's the difference if you do it with
your current controlfile still on your local disk, or if you restore a
control file from backup along with the rest of the database files
you'll be restoring?


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Rich Jesse


Good luck convincing anyone that you NEED two mirrored fast local
drives,
but maybe this will help:

//www.freelists.org/post/oracle-l/Write-cache-for-a-SAN,7


Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do
not consent to Internet email for messages of this kind. Opinions,
conclusions and other information in this message that do not relate to
the official business of this company shall be understood as neither given
nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l


--
//www.freelists.org/webpage/oracle-l


Other related posts: