Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Data Block corruption
You can't just delete the corrupted segment.
You need to restore the corrupted file only and apply all archived logs made
since the "alter tablespace .... begin backup" statement issued before you
made the backup of that file.
So: your database must run in archive log mode.
The exact scenario is described in the "Backup and Recovery Guide", "Performing Complete Media Recovery" (chapter 5). You can choose for an open database or closed database recovery. In the first case the database is available except for the segments stored in the affected tablespace. Go to http://tahiti.oracle.com and read it carefully. You can't affort to make any mistakes.
Rich <rich.bevan_at_bt.com> schreef in berichtnieuws
3E3021C5.70F699E0_at_bt.com...
| There was a disk errror on our system (Sun Sparc 2.6) which was repaired
| using format->analysis->read. However, before this was run the database
| was shutdown causing data block corruption - the message below was
| reported by TOAD
|
| ORA-01578: Oracle data block corruted (file# 11, block # 27874}
| ORA-01110: datafile 11: '/u03/oradata/BAA/data04.dbf'
|
| Is it possible from the above information to repair the damage either by
| deleting the segment which is corrupted and restoring the data or do I
| have to restore the whole datafile and use the archive logs ?
|
| I am running Oracle 8.1.7.1 on 32 bit
|
| Thanks for any help
|
| Richard
|
Received on Thu Jan 23 2003 - 11:25:39 CST