*************************
alert log 中存在错误信息,不过不能理解。
Errors in file /oracle/app/oracle/admin/ora8/udump/ora_26310.trc:
ORA-00600: internal error code, arguments: [521], [0], [], [], [], [], [], []
*************************
Mon Oct 1 11:44:45 2001
Thread 1 advanced to log sequence 44802
Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log
Mon Oct 1 22:10:57 2001
Starting ORACLE instance (normal)
Mon Oct 1 22:11:37 2001
Shutting down instance (immediate)
License high water mark = 30
Mon Oct 1 22:12:26 2001
Starting ORACLE instance (normal)
Mon Oct 1 22:12:41 2001
ALTER DATABASE CLOSE NORMAL
Mon Oct 1 22:12:41 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Oct 1 22:12:42 2001
Thread 1 closed at log sequence 44802
Mon Oct 1 22:12:42 2001
Completed: ALTER DATABASE CLOSE NORMAL
Mon Oct 1 22:12:42 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Mon Oct 1 22:12:53 2001
Errors in file /oracle/app/oracle/admin/ora8/udump/ora_26310.trc:
ORA-00600: internal error code, arguments: [521], [0], [], [], [], [], [], []
Mon Oct 1 22:13:07 2001
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.4.3.0.
System parameters with non-default values:
processes = 100
shared_pool_size = 50000000
nls_date_format = yyyy/mm/dd
control_files = /oracle/oradata/ora8/control01.ctl, /oracle/oradata/ora8/control02.ctl, /oracle/oradata/ora8/control03.ctl
db_block_buffers = 25000
db_block_size = 4096
log_archive_start = TRUE
log_archive_dest = /u02/archive/
log_archive_format = arch_%s.arc
log_buffer = 8192
log_checkpoint_interval = 1000000
db_files = 80
db_file_multiblock_read_count= 8
dml_locks = 100
rollback_segments = r01, r02, r03, r04
sequence_cache_entries = 30
sequence_cache_hash_buckets= 10
global_names = TRUE
db_name = ora8
open_cursors = 200
ifile = /oracle/app/oracle/admin/ora8/pfile/configora8.ora
background_dump_dest = /oracle/app/oracle/admin/ora8/bdump
user_dump_dest = /oracle/app/oracle/admin/ora8/udump
max_dump_file_size = 10240
core_dump_dest = /oracle/app/oracle/admin/ora8/cdump
PMON started with pid=2
DBW0 started with pid=3
ARCH started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
Mon Oct 1 22:13:10 2001
alter database mount
Mon Oct 1 22:13:10 2001
Successful mount of redo thread 1.
Mon Oct 1 22:13:10 2001
Completed: alter database mount
Mon Oct 1 22:13:10 2001
alter database open
Mon Oct 1 22:13:11 2001
Thread 1 opened at log sequence 44802
Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log
Successful open of redo thread 1.
Mon Oct 1 22:13:11 2001
SMON: enabling cache recovery
SMON: enabling tx recovery
Mon Oct 1 22:13:13 2001
Completed: alter database open
Shutting down instance (immediate)
License high water mark = 1
Mon Oct 1 22:13:54 2001
ALTER DATABASE CLOSE NORMAL
Mon Oct 1 22:13:54 2001
SMON: disabling tx recovery
SMON: disabling cache recovery
Mon Oct 1 22:13:55 2001
Thread 1 closed at log sequence 44802
Mon Oct 1 22:13:56 2001
Completed: ALTER DATABASE CLOSE NORMAL
Mon Oct 1 22:13:56 2001
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
Tue Oct 2 04:25:10 2001
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
LICENSE_MAX_USERS = 0
Starting up ORACLE RDBMS Version: 8.0.4.3.0.
System parameters with non-default values:
processes = 100
shared_pool_size = 50000000
nls_date_format = yyyy/mm/dd
control_files = /oracle/oradata/ora8/control01.ctl, /oracle/oradata/ora8/control02.ctl, /oracle/oradata/ora8/control03.ctl
db_block_buffers = 25000
db_block_size = 4096
log_archive_start = TRUE
log_archive_dest = /u02/archive/
log_archive_format = arch_%s.arc
log_buffer = 8192
log_checkpoint_interval = 1000000
db_files = 80
db_file_multiblock_read_count= 8
dml_locks = 100
rollback_segments = r01, r02, r03, r04
sequence_cache_entries = 30
sequence_cache_hash_buckets= 10
global_names = TRUE
db_name = ora8
open_cursors = 200
ifile = /oracle/app/oracle/admin/ora8/pfile/configora8.ora
background_dump_dest = /oracle/app/oracle/admin/ora8/bdump
user_dump_dest = /oracle/app/oracle/admin/ora8/udump
max_dump_file_size = 10240
core_dump_dest = /oracle/app/oracle/admin/ora8/cdump
PMON started with pid=2
DBW0 started with pid=3
ARCH started with pid=4
LGWR started with pid=5
CKPT started with pid=6
SMON started with pid=7
RECO started with pid=8
Tue Oct 2 04:25:12 2001
alter database mount
Tue Oct 2 04:25:13 2001
Successful mount of redo thread 1.
Tue Oct 2 04:25:13 2001
Completed: alter database mount
Tue Oct 2 04:25:13 2001
alter database open
Tue Oct 2 04:25:14 2001
Thread 1 opened at log sequence 44802
Current log# 3 seq# 44802 mem# 0: /oracle/oradata/ora8/redoora803.log
Successful open of redo thread 1.
Tue Oct 2 04:25:14 2001
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Oct 2 04:25:16 2001
Completed: alter database open
Tue Oct 2 10:49:48 2001
Thread 1 advanced to log sequence 44803
Current log# 1 seq# 44803 mem# 0: /oracle/oradata/ora8/redoora801.log
Tue Oct 2 20:07:23 2001
Thread 1 advanced to log sequence 44804
Current log# 2 seq# 44804 mem# 0: /oracle/oradata/ora8/redoora802.log
Wed Oct 3 12:08:42 2001
Thread 1 advanced to log sequence 44805
Current log# 3 seq# 44805 mem# 0: /oracle/oradata/ora8/redoora803.log
Wed Oct 3 13:13:19 2001
Thread 1 advanced to log sequence 44806
Current log# 1 seq# 44806 mem# 0: /oracle/oradata/ora8/redoora801.log
Wed Oct 3 13:46:07 2001
Thread 1 advanced to log sequence 44807
Current log# 2 seq# 44807 mem# 0: /oracle/oradata/ora8/redoora802.log
Wed Oct 3 14:12:33 2001