Skip to Main Content
Forums

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

3667794Mar 20 2018 — edited Mar 20 2018

Hello Guru's,

Am running Oracle EBS on DB version 12.1.0.2 on IBM AIX.

We encountered a power failure and now db is unable to open.

when i issue the alter database open command i get;-

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-00399: corrupt change description in redo log

ORA-00353: log corruption near block 3 change 7454871357418 time 03/20/2018

22:51:00

ORA-00312: online log 3 thread 1: '/d01/PROD/db/apps_st/data2/log03b.dbf'

ORA-00312: online log 3 thread 1: '/d01/PROD/db/apps_st/data/log03a.dbf'

Tried all sorts of solutions from google and nothing seems to work including :-

SQL> alter database clear unarchived logfile '/d01/PROD/db/apps_st/data2/log03b.dbf';

alter database clear unarchived logfile '/d01/PROD/db/apps_st/data2/log03b.dbf'

*

ERROR at line 1:

ORA-01514: error in log specification: no such log

ORA-01517: log member: '/d01/PROD/db/apps_st/data2/log03b.dbf'

SQL> ALTER SYSTEM CHECKPOINT GLOBAL;

ALTER SYSTEM CHECKPOINT GLOBAL

*

ERROR at line 1:

ORA-01109: database not open

Kindly help,

Thanks.

Comments

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

Post Details

Locked on Apr 17 2018
Added on Mar 20 2018
#general-database-discussions
3 comments
1,666 views