RE: RMAN impact

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 24 Oct 2006 11:11:34 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF79BA56@MSXVS04.trivadis.com>

Hi Mark

Just a couple of comments...

> One of the other nice features of Oracle 10g(R2?) is the ability to
> recover individual blocks in the even of corruption.

This is a 9.0 feature. See
http://download-uk.oracle.com/docs/cd/A91202_01/901_doc/server.901/a9013 6/rcmsyn10.htm#79197.

> Should you start exporting again? Nah. You can do an RMAN "BACKUP
> VALIDATE DATABASE" instead. In fact, with 10g, there is an
> additional option "CHECK LOGICAL" that will cause RMAN to crosscheck
> indexes and tables, which can detect logical corruption (of the type
> that occurs when your disk array loses the contents of its
> "nonvolatile" write cache) which is otherwise undetectable by any
> other means.

Be carefull... CHECK LOGICAL doesn't cover all type of logical corruptions. Inconsistencies, e.g. ORA-01499, are *not* detected. AFAIK ANALYZE is the only tool able to discover them.

Regards,
Chris

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Oct 24 2006 - 04:11:34 CDT