RE: Mirroring REDO logs to an nfs drive

I know that at one time, Oracle recommended that you do not put files onto an NFS file system. I think the OS needs to guarantee that the data was actually written to disk, and when you use NFS the OS "thinks" the data was written, when in reality it may still be transferring across the network. Somebody else may be able to shed some more current information on this.

Also, even though your drives are mirrored on your production box, it is still wise to mirror your redo logs and control files to separate file systems. I have seen file systems become corrupt due to OS or firmware bugs, not to mention what an errant "rm" command can do. The only thing that hardware mirroring does in those cases is mirror the corruption or mistake.

-----Original Message-----
Sent: Thursday, January 24, 2002 12:50 PM To: Multiple recipients of list ORACLE-L

easiest way to see the values is to do a backup controlfile to trace... they will be there

• Steve McClure <smcclure_at_usscript.com> wrote:
  > Our site is preparing to fail over to our backup server. We need to
  > do
  > maintenance on our production server, and will be running on the
  > backup for
  > about 24 hours. One issue I brought up was that our backup server is
  > not
  > equiped with mirrored drives, thus there was the possibility that a
  > drive
  > failure could destroy an online redo log. On our production box the
  > logs
  > are not software mirrored, because of the physical mirroring in our
  > drive
  > cabinet.
  >
  > As a result I was told to multiplex the redo logs once we had failed
  > over to
  > the backup server. Furthermore I would add the new members to an nfs
  > drive,
  > so that even a pesky controller couldn't foil our mirrored log files.
  >
  > I have some questions about this. First, am I just looking for
  > problems by
  > doing this? I would appreciate any tips or warnings on this subject.
  > Secondly, researching this topic made me curious as to my DB's
  > settings for
  > MAXLOGFILES and MAXLOGMEMBERS. Where can I find these parameters? I
  > was
  > sure I would find them in v$parameter, but they were not there.
  >
  > Thanks for any response,
  > Steve McClure
  

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jay Hostetter
  INET: jhostetter_at_decommunications.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).