Re: Moving redo logs

Steve Rainbird wrote:

> I have to reconfigure one of our NT databases so that its redo logs are not
> all on the same disk.
 

> Thanks.
>
> Steve Rainbird
> Principal consultant
> MSS International Ltd.
> www.mssint.com

Steve,

Unless you are duplexing the online redo logs, having all of them on one disk is a good idea - if you only use the remainder of the disk for storing hot backups and other relatively static items - no other active oracle files. If you're running in NOARCHIVELOG mode, no archiver processes are reading the logs, so only LGWR is accessing them.
If you're running in ARCHIVELOG mode, there is some advantage to having online redo logs on separate disks, such as

        LGWR
                |
                |
               /
-------- /       --------
    R1               R2
--------        --------
                    /
                  /
                |
                |
        --------
            A1
        --------

 Ideally, LGWR would be writing to a different drive than the drive containing the onilne redo log that is being archived. Once again though, if you're going to have other files on the drives, you're better off having a single dedicated drive for online redo than a couple with other active oracle files.

And yes, I put online redo logs on a hardware mirrored drive. Wish that I could duplex them (2 members per group) but have never had enough drives for that. Then again, I haven't had crashes yet due to writefile( ) errors to the online redo.

hth,

Paul Received on Thu Apr 26 2001 - 19:41:02 CDT