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