Skip to Main Content

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!

ORA-01578: ORACLE data block corrupted (file # 9, block # 247998)

741376Jan 12 2010 — edited Jan 12 2010
Hi all,

In my alert database i found the error bellow but it still continue working, this error was already coming from last year.

Errors in file /home/oracle/admin/tchad/bdump/tchad_smon_5665.trc:
ORA-01578: ORACLE data block corrupted (file # 9, block # 247998)
ORA-01110: data file 9: '/oradata05/tchad/AGGREGATES01.dbf'
Mon Jan 11 06:44:03 2010
SMON: Restarting fast_start parallel rollback
SMON: ignoring slave err,downgrading to serial rollback
ORACLE Instance tchad (pid = 9) - Error 1578 encountered while recovering transaction (1, 30) on object 55627.

What should i do to overcome this error.
I don't have backup but i only have archivelog backup if possible.
This error is coming every a minutes in my database.

Thanks
Raitsarevo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2010
Added on Jan 12 2010
13 comments
15,663 views