Database Software

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 -10567 : Redo is inconsistent with data block...

Avichal MishraJan 22 2008

Hi All !!

Two days back I installed oracle 10g on windows XP and today my database is giving problem as it's in mount state and not opening for normal operation.
When I give command 'alter database open' then it's giving error ORA-10567 : Redo is inconsistent with data block...I have no earlier backup for database
and also no backup for any datafile. I crosschecked the status of datafile and found that there are block corruption in datafile 2 & 4 (users and undotbs01)..I used blockrecover coomand too for block corruption but not able to correct those blocks..plz suggest me that how can I fix this error ORA-10567.

Thanks
With Best Regards
-avichal

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 19 2008

Added on Jan 22 2008

#database-key-features, #replication

0 comments

2,983 views