Skip to Content
0
Former Member
Aug 13, 2009 at 12:57 AM

ORACLE data block corrupted

317 Views

Hello,

System : Windows/4.6c/oracle 9i

Observed from Short dumps and System logs :

ORA-01578: ORACLE data block corrupted (file # 4, block #117760)#ORA-01110: data file 4:

'H:\ORACLE\AB5\SAPDATA1\STABI_1\STABI.DATA1'#

So we Executed Verification of database blocks in Offline mode to verify if any other part of database is corrupted .

DBVERIFY detected corrupted blocks in TWO locations :

1. H:\ORACLE\AB5\SAPDATA2\BTABD_8\BTABD.DATA8

2. H:\ORACLE\AB5\SAPDATA1\STABI_1\STABI.DATA1

Currently system is up and running .Can someone suggest how to overcome those corruptions ?

We tried to restore those corrrupted files from earlier backup but Database could not be started ,asking for resotoration of other files of database . So we had to revert back .

Do we have only one option to restore complete database with earlier backup ? Any other options ??

Regards

ganesh