8 Replies Latest reply: Jun 29, 2009 5:12 PM by user652965-Oracle RSS

    how to recover from corrupt redo log file in non-archived 10g db

    user652965-Oracle
      Hello Friends,
      I don't know much about recovering databases. I have a 10.2.0.2 database with corrupt redo file and I am getting following error on startup. (db is non archived and no backup) Thanks very much for any help.

      Database mounted.
      ORA-00368: checksum error in redo log block
      ORA-00353: log corruption near block 6464 change 9979452011066 time 06/27/2009
      15:46:47
      ORA-00312: online log 1 thread 1: '/dbfiles/data_files/log3.dbf'

      ====
      SQL> select Group#,members,status from v$log;

      GROUP# MEMBERS STATUS
      ---------- ---------- ----------------
      1 1 CURRENT
      3 1 UNUSED
      2 1 INACTIVE
      ==
      I have tried this so far but no luck
      I have tried following commands but no help.
      SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;

      Database altered.

      SQL> alter database open resetlogs;
      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01139: RESETLOGS option only valid after an incomplete database recovery


      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-00368: checksum error in redo log block
      ORA-00353: log corruption near block 6464 change 9979452011066 time 06/27/2009
      15:46:47
      ORA-00312: online log 1 thread 1: '/dbfiles/data_files/log3.dbf'