One control file/redo member with ASM ok?

In article , Sybrand Bakker says...
>
>On 16 Jan 2005 10:25:25 -0800, domenicg@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

Really?

SQL> startup pfile=initora9ir2.ora
ORACLE instance started.

Total System Global Area 269554828 bytes
Fixed Size 451724 bytes
Variable Size 201326592 bytes
Database Buffers 67108864 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> show parameter control

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
control_files string /home/ora9ir2/oradata/ora9ir2/
control01.ctl
SQL>


(they have the control files mirrored via ASM mirroring)


--
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

Thomas Kyte wrote:

> In article , Sybrand Bakker says...
>
>>On 16 Jan 2005 10:25:25 -0800, domenicg@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
>
>
> Really?
>
> SQL> startup pfile=initora9ir2.ora
> ORACLE instance started.
>
> Total System Global Area 269554828 bytes
> Fixed Size 451724 bytes
> Variable Size 201326592 bytes
> Database Buffers 67108864 bytes
> Redo Buffers 667648 bytes
> Database mounted.
> Database opened.
> SQL> show parameter control
>
> NAME TYPE VALUE
> ------------------------------------ ----------- ------------------------------
> control_file_record_keep_time integer 7
> control_files string /home/ora9ir2/oradata/ora9ir2/
> control01.ctl
> SQL>
>
>
> (they have the control files mirrored via ASM mirroring)

I have mixed feelings on this one.

While technically you are correct ... advising someone that they can do
this invites a very dangerous behaviour. Companies may suffer greviously
because someone reads this as Tom Kyte saying it is ok. And even I would
gleefully do what you recommend or what I assume you have sanctioned.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---

DA Morgan wrote:
>
> Thomas Kyte wrote:
>
> > In article , Sybrand Bakker says...
> >
> >>On 16 Jan 2005 10:25:25 -0800, domenicg@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
> >
> >
> > Really?
> >
> > SQL> startup pfile=initora9ir2.ora
> > ORACLE instance started.
> >
> > Total System Global Area 269554828 bytes
> > Fixed Size 451724 bytes
> > Variable Size 201326592 bytes
> > Database Buffers 67108864 bytes
> > Redo Buffers 667648 bytes
> > Database mounted.
> > Database opened.
> > SQL> show parameter control
> >
> > NAME TYPE VALUE
> > ------------------------------------ ----------- ------------------------------
> > control_file_record_keep_time integer 7
> > control_files string /home/ora9ir2/oradata/ora9ir2/
> > control01.ctl
> > SQL>
> >
> >
> > (they have the control files mirrored via ASM mirroring)
>
> I have mixed feelings on this one.
>
> While technically you are correct ... advising someone that they can do
> this invites a very dangerous behaviour. Companies may suffer greviously
> because someone reads this as Tom Kyte saying it is ok. And even I would
> gleefully do what you recommend or what I assume you have sanctioned.
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace 'x' with 'u' to respond)
>
> ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
> http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
> ---= East/West-Coast Server Farms - Total Privacy via Encryption =---

"can" != "should"

:-)
--
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald@yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------