| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE:
Paul, Tom
More to the point: what is a good data corruption checker? People have
noted on this list that RMAN hasn't caught corruption in their database.
Therefore I don't rely on it for that purpose. I export all tables each
week. If anyone has had export fail to catch a database corruption, please
post a reply.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Paul Drake
Sent: Friday, June 04, 2004 1:56 PM
To: oracle-l_at_freelists.org
Subject: RE:
> >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.
Pd
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 14:01:34 CDT
 |
 |