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
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
