Re: One control file/redo member with ASM ok?

From: Sybrand Bakker <gooiditweg_at_sybrandb.verwijderdit.demon.nl>
Date: Sun, 16 Jan 2005 22:54:02 +0100
Message-ID: <beolu01umcqbaft3pmdmu5isst1c4as0bg@4ax.com>

On 16 Jan 2005 10:25:25 -0800, domenicg_at_hotmail.com (Domenic) wrote:

>Is it acceptable to use one control file and one redo log member only
>(per group) on a database using ASM, where ASM is doing the mirroring?
> What's Oracle's recommendation/opinion on this? Wouldn't two control
>files and two redo members per group be overkill when ASM is doing the
>mirroring also?
>
>Domenic.

Oracle requires 2 control files. It won't start without 2 control files.
Mirroring only protects you against hardware failure. It doesn't protect you against someone inadvertently deleting a controlfile.
Also the controlfile is usually only a few Mb's big. It would be very strange to try to save a few Mb's and instead increase the risk someone blows up your database.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sun Jan 16 2005 - 15:54:02 CST