Yup, there are some nice ways for restoring even parts of a datablock using contents from corresponding indexes... or if it's an index block (just a plain count(*) can use indexes as well if all rows are quaranteed to be indexed), then you can "just" rebuild the index. So, nothing is lost, until it's completely lost ;)
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, January 09, 2004 1:24 AM > If the restore/recovery thing from backup doesn't work (it usually > does), it's time to panic in a controlled fashion... > > Dump the block to see if it's a hard or soft corruption. > > A hard corruption is when some kind of "stray write" has hit the block, > causing one of many checks against eg the rows to fail. > > A soft corruption happens when Oracle decides it doesn't have faith in > the block anymore, so better corrupt it by zero'ing out part of the > footer field. > > There's no easy way to tell whether it's a hard or soft corruption. You > can dump the block and study the header and footer fields to see if they > match. If not, it's probably a soft corruption. > > Or get Peter Gram to look at such stuff. He's crazy. > > Mogens > > Nguyen, David M wrote: > > > I got ORA-01578 error while querrying info for below table. How do I > > fix this error? > > > > > > SQL>Select count(*) from GATEWAYCALLSTATS; > > > > * > > > > ERROR at line 2: > > > > ORA-01578: ORACLE* data block corrupted* (file # 3, block # 2683299) > > > > ORA-01110: data file 3: '/apps/oracle/oradata/SIDB/rtesvr01.dbf' > > > > Thanks, > > > > David > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
