bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 14
16:40:47 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size
2232840 bytes
Variable Size
864030200 bytes
Database Buffers
197132288 bytes
Redo Buffers
5541888 bytes
Database mounted.
ORA-00600: internal error code, arguments:
[kcratr_nab_less_than_odr], [1],
[169], [61273], [61294], [], [], [], [], [], [], []
Solution
Alter database open fails with ORA-00600
kcratr_nab_less_than_odr [ID 1296264.1]
SQL> startup mount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size
2232840 bytes
Variable Size
864030200 bytes
Database Buffers
197132288 bytes
Redo Buffers
5541888 bytes
Database mounted.
SQL> show parameter control_files;
NAME TYPE VALUE
------------------------------------ -----------
------------------------------
control_files string /u02/app/oracle/oradata/tetris
11/control01.ctl, /u02/app/ora
cle/fast_recovery_area/tetris1
1/control02.ctl
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
---------- ----------------
/u02/app/oracle/oradata/redo/redo01_2.log
1 CURRENT
/u02/app/oracle/oradata/tetris11/redo01.log
1 CURRENT
bash-3.2$ cd /u02/app/oracle/oradata/tetris11
bash-3.2$ cp control01.ctl control01.ctl_20130613
bash-3.2$ cd /u02/app/oracle/fast_recovery_area/tetris11/
bash-3.2$ cp control02.ctl control02.ctl_20130613
bash-3.2$ sqlplus /nolog
SQL*Plus: Release 11.2.0.3.0 Production on Fri Jun 14
16:52:34 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size
2232840 bytes
Variable Size
864030200 bytes
Database Buffers
197132288 bytes
Redo Buffers
5541888 bytes
Database mounted.
SQL> recover database using backup controlfile until
cancel ;
ORA-00279: change 9173756576002 generated at 06/14/2013
13:07:32 needed for
thread 1
ORA-00289: suggestion :
/u02/app/oracle/fast_recovery_area/TETRIS11/archivelog/2013_06_14/o1_mf_1_169_%u
_.arc
ORA-00280: change 9173756576002 for thread 1 is in sequence
#169
Specify log: {<RET>=suggested | filename | AUTO |
CANCEL}
/u02/app/oracle/oradata/tetris11/redo01.log
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL>
SQL> shutdown immediate
ORA-03135: connection lost contact
SQL>
SQL>
There was a second issue, that you will find in next post:
ORA-00600: internal error code, arguments:
[4194], [], [], [], [], [], [], [], [], [], [], []
No comments:
Post a Comment