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
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