Disable Mirror logs

[John Smith]

Hi,

How do i disable Mirroring the Online Redo Logs.

[Dave Klinger]

Drop one of the redo logs in the group by using the ALTER DATABASE DROP
LOGFILE MEMBER '<logfilename>';

Dave

[sa...@my-dejanews.com]

Assuming that you are referring to the Oracle way of mirroring. Create new
redo log groups with single members, then take the old redo log groups
offline and delete. Make sure before you take them offline, that they are
not the current redo log group. If they are, you can force a log switch.

Good Luck,
Satar Naghshineh

In article <6vad9l$f6g$1...@mrnews.mro.dec.com>,

"John Smith" <jo...@hitech.com> wrote:
> Hi,
>
> How do i disable Mirroring the Online Redo Logs.
>
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

[tb...@worldnet.att.net]

"John Smith" <jo...@hitech.com> wrote:

> How do i disable Mirroring the Online Redo Logs.

You don't. You leave it on because it saves your bacon when a hard disk
containing a log dies.

Or you can disable it by creating log groups with only one member not two.
Some versions of Oracle might complain bitterly about that, however, and it
really is a dreadfully bad idea, so I hope you'll reconsider.

-Tom