Saturday, 5 January 2019

Alter database open fails with ORA-00600 kcratr_nab_less_than_odr

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[16], [54566], [54579], [], [], [], [], [], [], []


SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
b.group# and b.status='CURRENT';

MEMBER
--------------------------------------------------------------------------------

    GROUP# STATUS
---------- ----------------
E:\APP\TARIG\ORADATA\ORCL\REDO01.LOG
         1 CURRENT


SQL>Shutdown abort ;

Take a OS Level back of the controlfile (This is to ensure we have a backup of current state of controlfile)

SQL>Startup mount ;

SQL> shutdown abort;
ORACLE instance shut down.
SQL> Startup mount ;
ORACLE instance started.

Total System Global Area 3390558208 bytes
Fixed Size                  2180464 bytes
Variable Size            1929382544 bytes
Database Buffers         1442840576 bytes
Redo Buffers               16154624 bytes
Database mounted.
SQL> recover database using backup controlfile until cancel ;
ORA-00279: change 19769913 generated at 01/03/2019 16:07:47 needed for thread 1
ORA-00289: suggestion :
E:\APP\TARIG\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2019_01_05\O1_MF_1_16_%U_.ARC
ORA-00280: change 19769913 for thread 1 is in sequence #16


Specify log: {=suggested | filename | AUTO | CANCEL}
E:\APP\TARIG\ORADATA\ORCL\REDO01.LOG
Log applied.
Media recovery complete.

Hit Enter


SQL>Alter database open resetlogs ;

Number of Visitors