| ORA-01578: ORACLE data block corrupted [message #571081] |
Wed, 21 November 2012 00:58  |
 |
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
|
Member |
|
|
Could you please suggest what i have to do for this error:
ORA-01578: ORACLE data block corrupted (file # 3, block # 42348)
ORA-01110: data file 3: '+DGMETA/metadb/datafile/sysaux.257.783871811'
Wed Nov 21 09:30:00 2012
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 42348, RDBA = 12625260
OBJN = 50439, OBJD = 50439, OBJECT = MGMT_STRING_METRIC_HISTORY_PK, SUB OBJECT =
SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment
Database version is :- Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bi
Thanks
Daulat
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: ORA-01578: ORACLE data block corrupted [message #595402 is a reply to message #571207] |
Tue, 10 September 2013 23:02  |
|
daulat01
Messages: 62
Registered: May 2011
Location: Delhi
|
Member |
|
|
Hi , I am getting below an error in Oracle database on RAC in 10g.
ORA-01578: ORACLE data block corrupted (file # ORA-01578: ORACLE data block corrupted (file # 1, block # 560935)
ORA-01110: data file 1: '+DGDIXIE/dixie/datafile/system.260.647197957'
ORA-06512: at "SYS.DBMS_STATS", line 18544
ORA-06512: at "SYS.DBMS_STATS", line 18873
, block # )
@Note: While fetching data through the below query. We are getting same an error message.
select segment_name,segment_type,owner
from sys.dba_extents
where file_id=(1)
and (560935) between block_id and block_id + blocks -1
Could you please help me on this.
Thanks,
[Updated on: Tue, 10 September 2013 23:04] Report message to a moderator |
|
|
|
| Re: ORA-01578: ORACLE data block corrupted [message #595407 is a reply to message #595402] |
Wed, 11 September 2013 00:58 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
You have a corruption in SYSTEM tablespace.
You have to use the underlying tables of the view to get the result.
Use SQL*Plus and execute the following query and post the result.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" or "Preview Quick Reply" button to verify.
Also always post your Oracle version, with 4 decimals.
select * from sys.uet$
where file# = 1
and 560935 between block# and block#+length-1
/
Regards
Michel
[Updated on: Wed, 11 September 2013 00:59] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
