Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ORA-00399: corrupt change description in redo log

OmoheiMay 22 2017 — edited Mar 3 2018

Hi Alll,

We have one database can't open with below error . Pleas note database noarchivelog and courrepted redo is current stat. Any one have idea how we can open it

ORA-00399: corrupt change description in redo log

ORA-00353: log corruption near block 3 change 563919349 time 05/21/2017

15:29:41

ORA-00312: online log 1 thread 1:

'/u01/app/oracle/fast_recovery_area/ORCL/onlinelog/o1_mf_1_c9d1bzqh_.log'

ORA-00312: online log 1 thread 1:

'/u01/app/oracle/oradata/ORCL/onlinelog/o1_mf_1_c9d1bzk2_.log'

SQL> select group#,status,archived,sequence#,first_change# from v$log;

    GROUP# STATUS           ARC  SEQUENCE# FIRST_CHANGE#

---------- ---------------- --- ---------- -------------

         1 CURRENT          NO           4     563919346

         3 INACTIVE         NO           3     563899340

         2 INACTIVE         NO           2     563879332

This post has been answered by SUPRIYO DEY on May 22 2017
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 19 2017
Added on May 22 2017
1 comment
1,869 views