This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Sep 25, 2012 6:35 AM by ankitbarsainya RSS

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

ankitbarsainya Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points