Steve,

'alter database backup controlfile to trace;'

The values will be in the trace file.

Jared





"Steve McClure" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/24/02 11:48 AM
Please respond to ORACLE-L

 
        To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
        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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to