ORA-00600: ORA-12012 ORA-08102解决

SQL> startup pfile=?/dbs/inittesttt.ora
ORACLE instance started.

Total System Global Area 2147483648 bytes
Fixed Size                  2022144 bytes
Variable Size             184550656 bytes
Database Buffers         1946157056 bytes
Redo Buffers               14753792 bytes
Database mounted.
ORA-00603: ORACLE server session terminated by fatal error

启动不了数据库。实例会自动关闭。警告日志里显示：

Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p002_5401.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_5411.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p003_5403.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/udump/testtt_ora_5395.trc:
ORA-00600: internal error code, arguments: [4193], [23533], [23595], [], [], [], [], []
Thu Dec 16 18:09:36 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p001_5399.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Doing block recovery for file 2 block 131316

SQL>  startup mount;

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS1

SQL> alter system set undo_management=manual scope=spfile;

System altered.

 
SQL> shutdown immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup

SQL> create undo tablespace undotbs2 datafile '/db/oracle10g/oradata/testtt/undotbs02.dbf' size 2048m;

Tablespace created.

SQL> alter system set undo_tablespace="UNDOTBS2" scope=spfile;

System altered.

SQL> alter system set undo_management=auto scope=spfile;

System altered.
 
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
undo_management                      string      AUTO
undo_retention                       integer     900
undo_tablespace                      string      UNDOTBS2
SQL>
SQL>
到现在，库能起来了。

启动的时候报错：
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p005_10503.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
Fri Dec 17 09:15:09 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p007_10507.trc:
ORA-00600: internal error code, arguments: [kturbleurec1], [], [], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=24, OS id=10509
Fri Dec 17 09:15:14 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_mmon_10483.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 98.11% used, and has 40616960 remaining bytes available.
Fri Dec 17 09:15:14 2010
************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************
Fri Dec 17 09:15:15 2010
SMON: Restarting fast_start parallel rollback
Fri Dec 17 09:15:15 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_p000_10493.trc:
ORA-00600: internal error code, arguments: [4198], [9], [], [], [], [], [], []
Fri Dec 17 09:15:16 2010
Completed: ALTER DATABASE OPEN
Fri Dec 17 09:15:17 2010
Doing block recovery for file 2 block 81
Block recovery from logseq 11, block 3 to scn 613750430
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
  Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.3.16, scn 0.613750431
Doing block recovery for file 14 block 473
Block recovery from logseq 11, block 138 to scn 613750553
Fri Dec 17 09:15:17 2010
Recovery of Online Redo Log: Thread 1 Group 2 Seq 11 Reading mem 0
  Mem# 0 errs 0: /db/oracle10g/oradata/testtt/redo02.log
Block recovery completed at rba 11.138.16, scn 0.613750554
Fri Dec 17 09:15:17 2010
SMON: ignoring slave err,downgrading to serial rollback
Fri Dec 17 09:15:17 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
ORACLE Instance testtt (pid = 8) - Error 600 encountered while recovering transaction (15, 19).
Fri Dec 17 09:15:18 2010
Errors in file /db/oracle10g/admin/testtt/bdump/testtt_smon_10477.trc:
ORA-00600: internal error code, arguments: [4137], [], [], [], [], [], [], []
Fri Dec 17 09:15:24 2010
ORA-01555 caused by SQL statement below (SQL ID: 41kvabf2pspqq, Query Duration=5 sec, SCN: 0x0000.24951735):
Fri Dec 17 09:15:24 2010
UPDATE TYPE SET ARTICLENUM = ( SELECT COUNT(*) FROM MV_ARTICLE WHERE F_TYPE_ID = TYPE.ID