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 ;
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: {
E:\APP\TARIG\ORADATA\ORCL\REDO01.LOG
Log applied.
Media recovery complete.
Hit Enter
SQL>Alter database open resetlogs ;