Home » RDBMS Server » Server Administration » ora-01578 errororacle data block corrupted (oracle 9i on windows 2000)
ora-01578 errororacle data block corrupted [message #420599] Mon, 31 August 2009 14:19 Go to next message
oradba123
Messages: 86
Registered: June 2009
Location: india
Member



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'
Re: ora-01578 errororacle data block corrupted [message #420601 is a reply to message #420599] Mon, 31 August 2009 14:29 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
You have object sitting on bad block.
It is identified by following SQL

SELECT tablespace_name, segment_type, owner, segment_name
FROM dba_extents
WHERE file_id =1
and 3726 between block_id AND block_id + blocks - 1;

post results from SQL above

Make sure you have good current backups.
Previous Topic: **URGENT** Error !!! cannot attach to oracle 7 -- When start DB from using remote desktop client XP
Next Topic: manage backup in OEM 10g
Goto Forum:
  


Current Time: Sun Dec 11 06:28:15 CST 2016

Total time taken to generate the page: 0.03837 seconds