Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle block corruption, restore and roll forward

Oracle block corruption, restore and roll forward

From: Andrew Riley <himsdba_at_yahoo.co.uk>
Date: 2 Nov 2004 18:34:48 -0800
Message-ID: <30e7f1c6.0411021834.34706262@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
Received on Tue Nov 02 2004 - 20:34:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US