RE: RMAN impact

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <pythianbrinsmead@xxxxxxxxx>
  • Date: Tue, 24 Oct 2006 11:11:34 +0200

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

> 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.


Other related posts: