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
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
Title: Message
1.)
Restore datafile from backup.
2.)
recover datafile;
3.)voila!
Of
course, you mileage may vary. Do you have a valid backup? Is it hot
or cold? RMAN/conventional? etc,etc
Mark J.
Bobak Oracle DBA ProQuest Company
Ann Arbor,
MI "Imagination
was given to man to
Title: ORA-01578 data block corrupted
Run dbv on the datafile.
Also there is a document on Metalink which describes how to handle data
block corruption.
Use the folliwng query to get segment name
SELECT TABLESPACE_NAME, SEGMENT_TYPE, OWNER, SEGMENT_NAMEFROM
DBA_EXTENTSWHERE FILE_ID =
If you have access to Metalink:
Check Note:28814.1
Haven't had to use it, hopefully never will.
HTH,
Mike
Nguyen, David M
if you got rman backup and 9i, you can do block level recovery.
joe
Bobak, Mark wrote:
1.) Restore datafile from backup.
2.) recover datafile;
3.) voila!
Of course, you mileage may vary. Do you have a valid backup? Is it
hot or cold? RMAN/conventional? etc,etc
Mark J. Bobak