Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Mirroring REDO logs to an nfs drive
Steve,
'alter database backup controlfile to trace;'
The values will be in the trace file.
Jared
"Steve McClure" <smcclure_at_usscript.com>
Sent by: root_at_fatcity.com
01/24/02 11:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: Subject: Mirroring REDO logs to an nfs drive
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: smcclure_at_usscript.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.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). Received on Thu Jan 24 2002 - 15:06:18 CST