Re: Oracle block corruption, restore and roll forward

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Wed, 03 Nov 2004 03:14:49 GMT
Message-ID: <Xns9595C3CAAACADSunnySD@68.6.19.6>

himsdba_at_yahoo.co.uk (Andrew Riley) wrote in news:30e7f1c6.0411021834.34706262_at_posting.google.com:

> We are running an Oracle 8.1.7.4.1 SE database and a datafile has a
> corrupt block. The database has been restored and we have attempted
> to roll forward using the current control files and archive logs but
> it has failed.
>
> The table concerned is fairly large at ~150Gb so selecting/inserting
> around the corrupt 2K block could be a bit of a nightmare!
>
> Has anybody else had a similar problem and been able to resolve it?
> If so, what actions did you take?
>
> Any feedback would be appreciated.
>
> Many thanks
>

http://metalink.oracle.com explains how to handle this situation. Received on Tue Nov 02 2004 - 21:14:49 CST