自从做了数据库迁移以后,发现数据库很不稳定,检查了日志后,发现里面大量的报Ora-00600 4194错误,也在网上找资料了,但是看的一头雾水,请各位大侠指点我该怎么做!谢谢啦!
数据库装的是ORACLE9I,双机软件是ROSE,LINUX AS4 U5的操作系统,数据文件放在磁盘阵列上的/data/oradata下。
日志文件在附件中,高手请帮下忙了!
贴出一部分日志:
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /data/oradata/oracle/control01.ctl, /data/oradata/oracle/control02.ctl, /data/oradata/oracle/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /data/archive/
log_archive_format = T%TS%S.ARC
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = oracle
dispatchers = (PROTOCOL=TCP) (SERVICE=oracleXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle9i/admin/oracle/bdump
user_dump_dest = /opt/oracle9i/admin/oracle/udump
core_dump_dest = /opt/oracle9i/admin/oracle/cdump
sort_area_size = 524288
db_name = oracle
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Jun 19 19:28:38 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Thu Jun 19 19:28:38 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Jun 19 19:28:38 2008
ARC0: Thread not mounted
Thu Jun 19 19:28:38 2008
ARC1: Archival started
ARC1: Thread not mounted
Thu Jun 19 19:28:38 2008
ALTER DATABASE MOUNT
Thu Jun 19 19:28:42 2008
Successful mount of redo thread 1, with mount id 1530882342.
Thu Jun 19 19:28:42 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jun 19 19:28:42 2008
ALTER DATABASE OPEN
Thu Jun 19 19:28:42 2008
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 948
Current log# 2 seq# 948 mem# 0: /data/oradata/oracle/redo02.log
Successful open of redo thread 1.
Thu Jun 19 19:28:42 2008
SMON: enabling cache recovery
Thu Jun 19 19:28:42 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Jun 19 19:28:42 2008
SMON: enabling tx recovery
Thu Jun 19 19:28:42 2008
Database Characterset is ZHS16GBK
Thu Jun 19 19:28:42 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [4194], [61], [61], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Thu Jun 19 19:28:43 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Thu Jun 19 19:28:43 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [61], [61], [], [], [], [], []
Thu Jun 19 19:28:44 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053704], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:46 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053704], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 2 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:47 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053705], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 3 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:49 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053705], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 4 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:59 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053709], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 5 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:10 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053712], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 6 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:20 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053715], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 7 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:31 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053719], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 8 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:30:43 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_qmn0_10935.trc:
ORA-00600: internal error code, arguments: [4194], [91], [66], [], [], [], [], []
Thu Jun 19 19:30:44 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
数据库装的是ORACLE9I,双机软件是ROSE,LINUX AS4 U5的操作系统,数据文件放在磁盘阵列上的/data/oradata下。
日志文件在附件中,高手请帮下忙了!
贴出一部分日志:
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 83886080
large_pool_size = 16777216
java_pool_size = 83886080
control_files = /data/oradata/oracle/control01.ctl, /data/oradata/oracle/control02.ctl, /data/oradata/oracle/control03.ctl
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /data/archive/
log_archive_format = T%TS%S.ARC
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = oracle
dispatchers = (PROTOCOL=TCP) (SERVICE=oracleXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle9i/admin/oracle/bdump
user_dump_dest = /opt/oracle9i/admin/oracle/udump
core_dump_dest = /opt/oracle9i/admin/oracle/cdump
sort_area_size = 524288
db_name = oracle
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 25165824
aq_tm_processes = 1
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
CJQ0 started with pid=8
QMN0 started with pid=9
Thu Jun 19 19:28:38 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=12
ARC0: Archival started
ARC1 started with pid=13
Thu Jun 19 19:28:38 2008
ARCH: STARTING ARCH PROCESSES COMPLETE
Thu Jun 19 19:28:38 2008
ARC0: Thread not mounted
Thu Jun 19 19:28:38 2008
ARC1: Archival started
ARC1: Thread not mounted
Thu Jun 19 19:28:38 2008
ALTER DATABASE MOUNT
Thu Jun 19 19:28:42 2008
Successful mount of redo thread 1, with mount id 1530882342.
Thu Jun 19 19:28:42 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Thu Jun 19 19:28:42 2008
ALTER DATABASE OPEN
Thu Jun 19 19:28:42 2008
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 opened at log sequence 948
Current log# 2 seq# 948 mem# 0: /data/oradata/oracle/redo02.log
Successful open of redo thread 1.
Thu Jun 19 19:28:42 2008
SMON: enabling cache recovery
Thu Jun 19 19:28:42 2008
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Jun 19 19:28:42 2008
SMON: enabling tx recovery
Thu Jun 19 19:28:42 2008
Database Characterset is ZHS16GBK
Thu Jun 19 19:28:42 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [4194], [61], [61], [], [], [], [], []
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: ALTER DATABASE OPEN
Thu Jun 19 19:28:43 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Thu Jun 19 19:28:43 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [61], [61], [], [], [], [], []
Thu Jun 19 19:28:44 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053704], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 1 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:46 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053704], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 2 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:47 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053705], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 3 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:49 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053705], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 4 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:28:59 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053709], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 5 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:10 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053712], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 6 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:20 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053715], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 7 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:29:31 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_smon_10929.trc:
ORA-00600: internal error code, arguments: [2662], [0], [226053719], [0], [226053787], [8392994], [], []
Non-fatal internal error happenned while SMON was doing offlining of rollback segments.
SMON encountered 8 out of maximum 100 non-fatal internal errors.
Thu Jun 19 19:30:43 2008
Errors in file /opt/oracle9i/admin/oracle/bdump/oracle_qmn0_10935.trc:
ORA-00600: internal error code, arguments: [4194], [91], [66], [], [], [], [], []
Thu Jun 19 19:30:44 2008
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
Recovery of Online Redo Log: Thread 1 Group 2 Seq 948 Reading mem 0
Mem# 0 errs 0: /data/oradata/oracle/redo02.log
db_block_size = 8192
db_cache_size = 33554432
compatible = 9.2.0.0.0
log_archive_start = TRUE
log_archive_dest = /data/archive/
log_archive_format = T%TS%S.ARC