Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

ankitbarsainyaSep 25 2012 — edited Sep 25 2012

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 23 2012

Added on Sep 25 2012

#general-database-discussions

16 comments

6,233 views