Solved

Oracle data block corrupted

Posted on 2014-09-19
2
686 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
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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

828 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