[210], [39496], [39684], [], [], [], [], [], [], [] error in oracle?
You might have faced this issue while trying to start the database. Most of the time this ora error occur during database restart after abnormal shutdown or power failure. To resolve it you need to recover the database using backup control file as shown below.
[Resolution]
C:Userssan>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 3 14:53:57 2018
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3307048960 bytes
Fixed Size 2180264 bytes
Variable Size 2046823256 bytes
Database Buffers 1241513984 bytes
Redo Buffers 16531456 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[210], [39496], [39684], [], [], [], [], [], [], []
STEP 1: Shut down the database and startup in mount state
SQL> shut immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3307048960 bytes
Fixed Size 2180264 bytes
Variable Size 2046823256 bytes
Database Buffers 1241513984 bytes
Redo Buffers 16531456 bytes
Database mounted.
STEP 2: Take backup of control file manually at os level using cp or copy command.
SQL> show parameter control_files;
NAME TYPE VALUE
———————————— ———– ——————————
control_files string C:APPSANORADATAORCL
CONTROL01.CTL, C:APPSAN
FLASH_RECOVERY_AREAORCLCON
TROL02.CTL
STEP 3: Check the Current Logfile
SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=b.group# and b.status=’CURRENT’
2 ;
MEMBER
——————————————————————————–
GROUP# STATUS
———- —————-
C:APPSANORADATAORCLREDO03.LOG
3 CURRENT
STEP 4: Shutdown the DB and startup in Mount state
SQL> Shutdown abort ;
ORACLE instance shut down.
SQL> Startup mount ;
ORACLE instance started.
Total System Global Area 3307048960 bytes
Fixed Size 2180264 bytes
Variable Size 2046823256 bytes
Database Buffers 1241513984 bytes
Redo Buffers 16531456 bytes
Database mounted.
STEP 5: Recover the database using backup controlfile until cancel.
SQL> recover database using backup controlfile until cancel ;
ORA-00279: change 2737134 generated at 12/27/2017 12:21:37 needed for thread 1
ORA-00289: suggestion :
C:APPSANFLASH_RECOVERY_AREAORCLARCHIVELOG2018_01_03O1_MF_1_210_%U_.
ARC
ORA-00280: change 2737134 for thread 1 is in sequence #210
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:APPSANORADATAORCLREDO03.LOG
Log applied.
Media recovery complete.
SQL>
STEP 6: Reset the logs and open the database
SQL> Alter database open resetlogs ;
Database altered.
SQL>
SQL>
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
C:Userssan>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Jan 3 15:00:37 2018
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 3307048960 bytes
Fixed Size 2180264 bytes
Variable Size 2046823256 bytes
Database Buffers 1241513984 bytes
Redo Buffers 16531456 bytes
Database mounted.
Database opened.
SQL>
SQL>