Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Block Corruption?

846231Jul 18 2012 — edited Jul 20 2012

Hi all,

OraDB 11.2.0.1

Today, we just encountered this error in oue PROD db. This is the first time we hit this.

Caused by: java.sql.SQLException: ORA-01578: ORACLE data block corrupted (file #
5, block # 136230)
ORA-01110: data file 5: 'C:\ORACLE\ORADATA\ORAJVB7\DATATS01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

My boss ask what are the usual cause of this issue.
I just said, power fluctuation and the disk is already old and brittle.
It this a valid explaination?

How do you handle this issue?
Is the ff. acceptable too?

startup nomount,
recover database.

Thanks a lot,

Edited by: KinsaKaUy? on 18-Jul-2012 20:19

This post has been answered by Aman.... on Jul 19 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2012

Added on Jul 18 2012

#general-database-discussions

63 comments

3,429 views