Re: Control files : number and location ?

Make a *separate* directory on the C drive for the Oracle stuff. Put a control file in there and a mirror of your online redo log. Also write your archive logs to this disk if you are running in archive log mode and hope to perform any form of recovery - as you haven't got a chance with your current set-up (apart from a full restore up to the point you did your last full backup to tape).

I'd really recommend getting a few more drives, though. Monitor your disks to chart their I/O.

Oh, and don't forget to backup this new C directory as part of your Oracle D drive backup!

Steve Phelan.

(Oracle 7 & 8 OCP).

Matthieu KREMBEL wrote:

> Hi,
>
> I read that Oracle strongly recommends that a database has a minimum of 2
> control files on different disks.
>
> My 7.3.3 Oracle server runs on a Windows NT 4.0 server.
> The server has only 2 disks :
> C: where there is the Windows NT system directory.
> D: where there is the Orant directory.
>
> Presently, my both control files are in the "D:\Orant\Database" directory.
>
> According to your opinions, which is the safest strategy ?
> ---------------------------------------------------------------------------
>
> 1. To do nothing and to keep the current setup ?
> 2. To move one of the control file to the C: disk: ( system HD) ?
> 3. To add a new control file to the C: disk
> ( in this case, the database will have 3 control files )
>
> Thanks for your hints,
>
> Matthieu Krembel
> E-Mail : m.krembel_at_ch-rouffach.fr
Received on Fri Feb 19 1999 - 14:43:54 CST