1 2 Previous Next 16 Replies Latest reply: Sep 25, 2012 8:35 AM by ankitbarsainya RSS

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

    ankitbarsainya
      Hello,
      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
      11:24:27
      ORA-00312: online log 1 thread 1: 'C:\APP\CONADM\ORADATA\ORACLE\REDO01.LOG'

      Please suggest.
      DB version : 11.2.0.1
      Windows 7 64 Bit.
      Regards,
      Ankit
        1 2 Previous Next