ora-01578 errororacle data block corrupted

[younusdba]

Hi all,


our production oracle 9i database is on windows 2000 server.since 3 days daily morning its is automaically being shutdown, when i check the alert log file it show the following below errors, when i execute startup command at sql prompt as sysdbs its up without any error.can anyone has idea about that.quick response will be higly appreciated.thanks a lot in advance.


.Mon Aug 31 17:11:30 2009
Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

Mon Aug 31 17:16:38 2009
Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

Mon Aug 31 17:21:46 2009
Errors in file c:\oracle\admin\bmms\bdump\bmms_smon_2416.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-01578: ORACLE data block corrupted (file # 1, block # 3726)
ORA-01110: data file 1: 'C:\ORACLE\ORADATA\BMMS\SYSTEM01.DBF'

[Rayyah]

Do you have valid backup with rman ?If yes,then follow

I)
a) Shutdown your database
b) start rman

rman target /


Use blockrecovery to recover the corrupted block(s)

c)BACKUP VALIDATE CHECK LOGICAL database;

d)BLOCKRECOVER CORRUPTION LIST;

e)startup database

Should be good to go......

if not

use dbms_repair to mark them as corrupt this is the only option if you dont have any backups.

[younusdba]

Hi rayyah,


thank you for quick response .but could you please tell me how to repair the corrupt block using dbms_repaid.waiting for your response.thanks in advance;

[davey23uk]

Hi rayyah,


thank you for quick response .but could you please tell me how to repair the corrupt block using dbms_repaid.waiting for your response.thanks in advance;

you cannot repair then, you mark them as corupted so they don't get used.

You need to get your backups out