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!

checksum error in redo log block

406133May 19 2010 — edited May 20 2010
I received ORA-00368 in my database and to resolve it I tried following steps:-

1) recover database until cancel;

2) alter database open resetlogs;
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oracle/data/system01.dbf'

3) recover database;
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 12018 change 5983381348672 time 05/18/2010
16:08:24
ORA-00312: online log 10 thread 1: '/u02/oracle/data/log10b.dbf'
ORA-00312: online log 10 thread 1: '/u01/oracle/data/log10a.dbf'


There are 4 log groups with 2 members each and the database is in archive mode. Log group# 10 is current and all others are inactive.

Could you please let me know how should I proceed further either with or without losing transaction in group# 10 redo log?

Thanks
Rajkum
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2010
Added on May 19 2010
18 comments
7,379 views