RE: What makes Oracle DB shutdown automatically?

[shuan.tay\(PCI鄭祺勛\)]

This is the alert log file, and i try to search for error ORA-00313, it's:   "ORA-00313 open failed for members of log group string of thread string Cause: The online log cannot be opened. The file may not be in the expected location. Action: Specify the correct redo log file or make the log available, if necessary."   Is it correct? What's the online log mentioned here? Redo log?   ---------------------alert_pcia.log---------------------------------------------------------- LGWR: terminating instance due to error 313 Instance terminated by LGWR, pid = 2025 Mon Nov 25 15:07:56 2002 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.0.5.0.0. System parameters with non-default values:   processes                = 300   event                    =  10805 trace name context forever, level 1   shared_pool_size         = 19000000   control_files            = $ORACLE_HOME/dbs/ctl1pcia.dbf, $ORACLE_HOME/dbs/ctl2pcia.dbf, $ORACLE_HOME/dbs/ctl3pcia.dbf, $ORACLE_HOME/dbs/ctl4pcia.dbf   db_block_buffers         = 550   db_block_size            = 8192   compatible               = 8.0.5.0.0   log_buffer               = 163840   log_checkpoint_interval  = 10000   db_files                 = 500   db_file_multiblock_read_count= 16   dml_locks                = 500   rollback_segments        = rbs01, rbs06, rbs02, rbs07, rbs03, rbs08, rbs04, rbs09, rbs05, rbs10, rbs20, rbs15, rbs19, rbs14, rbs18, rbs13, rbs17, rbs12, rbs16, rbs11, rb30, rb21, rb29, rb22, rb27, rb23, rb26, rb24, rb25   sequence_cache_entries   = 100   sequence_cache_hash_buckets= 23   remote_login_passwordfile= NONE   global_names             = FALSE   db_name                  = pcia   open_cursors             = 100000   os_authent_prefix        =   background_dump_dest     = $ORACLE_HOME/rdbms/trace   user_dump_dest           = $ORACLE_HOME/rdbms/trace   max_dump_file_size       = 10240 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 Mon Nov 25 15:07:56 2002 alter database  mount Mon Nov 25 15:08:00 2002 Successful mount of redo thread 1, with mount id 810458128. Mon Nov 25 15:08:00 2002 Database mounted in Exclusive Mode. Completed: alter database  mount Mon Nov 25 15:08:00 2002 alter database open Beginning crash recovery of 1 threads Recovery of Online Redo Log: Thread 1 Group 1 Seq 16402 Reading mem 0   Mem# 0 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log1pcia.log   Mem# 1 errs 0: /home/oracle/app/oracle/product/8.0.5/dbs/log4pcia.log Crash recovery completed successfully Picked broadcast on commit scheme to generate SCNs   -------------------------------------------------------------------------