Solved

Oracle data block corrupted

Posted on 2014-09-19
2
691 Views
Last Modified: 2014-09-19
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?
0
Comment
Question by:goldieretriever
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 40333218
Step 1:
PERFORM A COMPLETE BACKUP OF THE CURRENT STATE.

Step 2:
Contact Oracle Support.

There are no more steps.

Looks like you have corruption in several data files.  My guess is there was some disk event that likely caused more damage that you are aware of.

You can find a TON of stuff on the web that says things like:
Try this...
Try this...
Try this...

Not knowing the EXACT state of the database, you could corrupt things even more.

Oracle Support will be able to walk you through what you need to do.
0
 

Author Closing Comment

by:goldieretriever
ID: 40333908
Thank you for the quick response. Oracle support was a great help. It was a sever hardware problem.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question