ORACLE系统反复重启 due to error 472

gangse

日志如下
有时候什么错误也不报，到alter database open以后直接重启，不知道什么原因

请大家指教


ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586
Mon May 11 13:53:29 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.1.0.
System parameters with non-default values:
  processes                = 450
  timed_statistics         = TRUE
  shared_pool_size         = 419430400
  sga_max_size             = 1259414708
  large_pool_size          = 8388608
  java_pool_size           = 33554432
  control_files            = Z:\oracle\oradata\ORAL\CONTROL01.CTL, Z:\oracle\oradata\ORAL\CONTROL02.CTL, Z:\oracle\oradata\ORAL\CONTROL03.CTL
  db_block_size            = 8192
  db_cache_size            = 629145600
  compatible               = 9.2.0.0.0
  log_archive_start        = TRUE
  log_archive_dest_1       = location=z:\oracle\archivelog
  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            = ORAL
  dispatchers              = (PROTOCOL=TCP) (SERVICE=ORALXDB)
  job_queue_processes      = 10
  hash_join_enabled        = TRUE
  background_dump_dest     = c:\oracle\admin\ORAL\bdump
  user_dump_dest           = c:\oracle\admin\ORAL\udump
  core_dump_dest           = c:\oracle\admin\ORAL\cdump
  sort_area_size           = 524288
  db_name                  = ORAL
  open_cursors             = 750
  star_transformation_enabled= FALSE
  query_rewrite_enabled    = FALSE
  pga_aggregate_target     = 419430400
  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
Mon May 11 13:53:32 2009
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
Mon May 11 13:53:33 2009
ARC1: Archival started
Mon May 11 13:53:33 2009
ARCH: STARTING ARCH PROCESSES COMPLETE
ARC1: Thread not mounted
Mon May 11 13:53:33 2009
ARC0: Thread not mounted
Mon May 11 13:53:33 2009
alter database mount exclusive
Mon May 11 13:53:37 2009
Successful mount of redo thread 1, with mount id 1015454941.
Mon May 11 13:53:37 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Mon May 11 13:53:37 2009
alter database open
Mon May 11 13:53:37 2009
Beginning crash recovery of 1 threads
Mon May 11 13:53:37 2009
Started first pass scan
Mon May 11 13:53:38 2009
Completed first pass scan
364 redo blocks read, 89 data blocks need recovery
Mon May 11 13:53:38 2009
Started recovery at
Thread 1: logseq 1463, block 3, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1463 Reading mem 0
  Mem# 0 errs 0: Z:\ORACLE\ORADATA\ORAL\REDO01.LOG
Mon May 11 13:53:38 2009
Ended recovery at
Thread 1: logseq 1463, block 367, scn 1389.1911532022
89 data blocks read, 89 data blocks written, 364 redo blocks read
Crash recovery completed successfully
Mon May 11 13:53:38 2009
LGWR: Primary database is in CLUSTER CONSISTENT mode
Thread 1 advanced to log sequence 1464
Thread 1 opened at log sequence 1464
  Current log# 2 seq# 1464 mem# 0: Z:\ORACLE\ORADATA\ORAL\REDO02.LOG
Successful open of redo thread 1.
Mon May 11 13:53:39 2009
SMON: enabling cache recovery
Mon May 11 13:53:39 2009
ARC0: Evaluating archive   log 1 thread 1 sequence 1463
ARC0: Beginning to archive log 1 thread 1 sequence 1463
Creating archive destination LOG_ARCHIVE_DEST_1: 'Z:\ORACLE\ARCHIVELOG\ARC01463.001'
ARC0: Completed archiving  log 1 thread 1 sequence 1463
Mon May 11 13:53:39 2009
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.
Mon May 11 13:53:39 2009
SMON: enabling tx recovery
Mon May 11 13:53:39 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon May 11 13:54:35 2009
CKPT: terminating instance due to error 472
Dump file c:\oracle\admin\oral\bdump\alert_oral.log
Mon May 11 13:54:39 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 1, CPU type 586

dingning239

注意这几句

replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
Mon May 11 13:54:35 2009
CKPT: terminating instance due to error 472