Re: Control files : number and location ?

Matthieu-
It depends on your backup and recovery procedures for your database. If your NT server goes down and you are unable to retrieve either control file then you will have to rebuild the database from the last backup dmp and control file you made. If you lose one partition you can use the control file in the other one to recover. Multiplexing increases your odds off recovery. Therefore I would recommend regular backups and doubling up on your control files-it doesn't hurt you.
Anil Bharadwa

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 Tue Feb 09 1999 - 11:19:46 CST