Oracle-L: RE: What makes Oracle DB shutdown automatically?

From: shuan.tay\(PCI¾G¸R³Ô\) <shuan.tay_at_pci.co.id>
Date: Mon, 25 Nov 2002 04:03:37 -0800
Message-ID: <F001.0050A8D9.20021125040337@fatcity.com>

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: =?big5?B?c2h1YW4udGF5XChQQ0m+R7hSs9RcKQ==?= INET: shuan.tay_at_pci.co.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 25 2002 - 06:03:37 CST