Solved

Oracle data block corrupted

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

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

747 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now