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.