| ora-01578 errororacle data block corrupted [message #420599] |
Mon, 31 August 2009 14:19  |
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  |
 |
BlackSwan
Messages: 26766
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
