-
ora-01578 errororacle data block corrupted
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'
-
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.
-
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;
-
Originally Posted by 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;
you cannot repair then, you mark them as corupted so they don't get used.
You need to get your backups out
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|