goldieretriever
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.d bf'
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?
SQL.sql: Error (1,22): ORA-01578: ORACLE data block corrupted (file # 7, block # 3379875)
ORA-01110: data file 7: '/opt/oracle/oradata/orcl/
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/
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER