Re: how to mirror redolog ?

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Tue, 02 Mar 1999 08:38:10 -0800
Message-ID: <36DC13F2.5433F804@us.oracle.com>

Not an ideal configuration for recovery purposes. Apart from that, you've already mirrored the control file by having copies on both disks. If your redo logs have redo log 1 on disk 1 and redo log 2 on disk 2, all you need to do is do an alter database add logfile member command for each redo log group so you end up with a member of each group on each disk. I would suggest you move your datafiles to disk 2 as well, since it will probably relieve the load on disk 1. Disk 1 is being hit pretty hard by having both the OS and database kernels on it. Also, consider archiving to floppy if it's not a Production system (believe it or not, I've had people do this in the past for Production systems to provide a more robust recovery scenario!).

HTH Pete

nikko wrote:

> How do I mirror redo logs and control file in two disk in NT Windows 4.0
> for the following file distribution ?
>
> Disk 1: Windows NT 4.0 Server
> Oracle 8 Server
> Datafiles
> redo logs
> control file
>
> Disk 2: Archive log
> redo logs
> control file

Regards

Pete

Peter Sharman                              Email: psharman_at_us.oracle.com
WISE Course Development Manager            Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education               (650)607 0109 (local)

San Francisco

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Tue Mar 02 1999 - 10:38:10 CST