Link to home
Start Free TrialLog in
Avatar of goldieretriever
goldieretrieverFlag for United States of America

asked on

Oracle data block corrupted

When doing a select count on a oracle table - I received this -

SQL.sql: Error (1,22): ORA-01578: ORACLE data block corrupted (file # 7, block # 3379875)
ORA-01110: data file 7: '/opt/oracle/oradata/orcl/COSTPOINT_DATA'

II ran these sql commands:
Select owner, segment_name from dba_extents where 3379875 between block_id and block_id + blocks and file_id = 7;
Received back:
 
OWNER                          SEGMENT_NAME
------------------------------ ---------------------------------------------------------------------------------
DELTEK                         GL_POST_SUM
 
1 row selected.
 
Then ran-
select bytes from dba_segments where owner = 'DELTEK' and segment_name = 'GL_POST_SUM';
 
received this error
SQL.sql: Error (1,19): ORA-01578: ORACLE data block corrupted (file # 1, block # 184437)
ORA-01110: data file 1: '/opt/oracle/oradata/orcl/system01.dbf'

ran this
Select owner, segment_name from dba_extents where 184437 between block_id and block_id + blocks and file_id = 1;

OWNER                          SEGMENT_NAME
------------------------------ ---------------------------------------------------------------------------------
SYS                                I_FILE#_BLOCK#

Is there any way to recover?
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of goldieretriever

ASKER

Thank you for the quick response. Oracle support was a great help. It was a sever hardware problem.