1 2 Previous Next 16 Replies Latest reply on Sep 25, 2012 1:35 PM by ankitbarsainya

    Ora 00353 and ora 00354 while opening database for redolog grp 1

      I'm facing issue while trying to open the database instance.
      Below mentioned is the error i'm getting:
      SQL> alter database open;
      alter database open
      ERROR at line 1:
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

      SQL> alter database open noresetlogs;
      alter database open noresetlogs
      ERROR at line 1:
      ORA-00354: corrupt redo log block header
      ORA-00353: log corruption near block 80085 change 11481814 time 09/25/2012
      ORA-00312: online log 1 thread 1: 'C:\APP\CONADM\ORADATA\ORACLE\REDO01.LOG'

      Please suggest.
      DB version :
      Windows 7 64 Bit.
        1 2 Previous Next