RE:

From: Paul Drake <discgolfdba_at_yahoo.com>
Date: Fri, 4 Jun 2004 11:55:44 -0700 (PDT)
Message-ID: <20040604185544.95408.qmail@web20422.mail.yahoo.com>

"Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> wrote:
> Paul,

> >1. block checking (inline). don't need to run dbv.

> OK. This makes sense. Although the risk is
> probably small - how many times have we
> experienced corrupted blocks?

more than once, due to bad hardware/drivers. wanna see it in the log as soon as it happens. in these days of quarterly sarbanes-oxley driven backup/restore/recover checks, this is a way of having a paper trail against some forms of corruption.

> >2. doesn't backup blocks that have not been written
> to.
>
> Grudgingly ok. I would keep the free space small
> for any database that I am
> not running in archivelog mode.
> I would *never* run
> a prod db in noarchivelog mode.

agreed. won't/don't have any.
think database where developers are trying out different designs and using lots of space, re-running test loads. not even the real dev db.

> >3. operation is in the controlfile (or rman
> catalog).

> I guess.

> >4. not platform-specific.

> *Everything* is platform specific.

> I guess is comes down to personal preference. I
> don't think I'd put myself
> in the position to allow this to happen.
> I'd argue like hell against it!

> Have a good weekend!

thanks. sure hope so, could use one.

Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jun 04 2004 - 13:53:29 CDT