Current Position:Home > Checksum error in redo log block

Checksum error in redo log block

Update:11-30Source: network consolidation
Advertisement
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

The Best Answer

Advertisement
How can I drop the CURRENT log group# 10 and start the database with remaining 3 log groups? Database is in archive mode.Short answer: You cant. It is the CURRENT redo log... most probably your database wasnt shut down cleanly hence requiring a recovery. This recovery cannot be done because you have a corruption in your redo log needed to roll-forward the changes.
Without a valid backup and a restore/recovery until time there is no chance of opening the database without the help of Oracle. I strongly suggest you open a SR and prepare your management for some costs because you are running a unsupported database version on a unsupported (at least today) operating system. I also doubt you have a valid support contract for a 9i database...
Ronny Egner
My Blog: http://blog.ronnyegner-consulting.de
  • [DG Physical] ORA-00368: checksum error in redo log block Update:11-30

    Hi all, I'm building a DR solution with 1 primary & 2 DR site (Physical). All DBs use Oracle 10.2.0.3.0 on Solaris 64bit. The first one ran fine for some days (6), then I installed the 2nd. After restoring the DB (DUPLICATE TARGET DATABASE FOR STANDB

  • Ora-00368 checksum error in redo log block Update:11-30

    We are running small database in oracle 9i in non archive mode .Database is not opening up with following error ora-00368 checksum error in redo log block. How to do the incomplete database recovery and open the database. Regards ArunFor more details

  • Checksum error in redo log block Update:11-30

    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/

  • Get ORA-00368: checksum error in redo log block Update:11-30

    Hi all, I get an error ORA-00368: checksum error in redo log block when connecting to database and here is the error: ORA-00368: checksum error in redo log block ORA-00353: log corruption near block 430757 change 1236507302 time 11/12/2009 09:55:35 O

  • Logmnr/capure error b'coz of corruption of redo log block Update:11-30

    Hi, We all know that capture process reads the REDO entries from redo log files or archived log files. Therefore we need to ahev db in ARCHIVELOG mode. In alert log file, I found error saying : Creating archive destination LOG_ARCHIVE_DEST_1: 'E:\ORA

  • ORA-00354: corrupt redo log block header Update:11-30

    Hi Guys, Need your support to resolve one of the oracle issues, Below are errors visible in alert.log in oracle, ORA-16038: log 24 sequence# 660467 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 24 thread 1: '/oracl

  • ORA-00354: corrupt redo log block header..urgent Update:11-30

    Hi All, i am running into an issue when trying to recover a datafile. 1). Logs are being applied to the datafile to recover but RMAN is throwing this error: ORA-00283: recovery session canceled due to errors RMAN-11003: failure during parse/execution

  • How to overcome corrupt redo log block header Update:11-30

    friends, can you tell me any utilities or packages using which i can clean my redo log . Iam encountering this error during recovery of my database NandJafar, SQL> recover database using backup controlfile; ORA-00279: change 166327733 generated at 04

  • Checksum problem in redo log file. Update:11-30

    hi, I hv a checksum problem in my redo log file. Details. 1. I m unable to open the database but able to mount it. 2. Error says checksum error in current redolog group 2, so can't recover thread 1. 3. Error in group 2 which is active group. In Mount

  • Error verifing REDO LOG COLLECTOR Update:11-30

    Dear all, I get this error when i try to verify REDO collector: $avorcldb verify -src 10.52.128.176:3000:TEST -colltype REDO Introducir Nombre de Usuario de Origen: srcuser Introducir Contraseña de Origen: ERROR: el nombre de base de datos global par