Oracle数据服务器遭遇楼层停电,启动后一段时间内反复宕机。
背景:
   昨天中午,我们公司楼层由于电路原因,突然断电。
   我们开发小组的数据库开发环境(Linux)也遭遇宕机。
以下是alert_sid.log
ORA-00474: SMON process terminated with errorThu Jul  5 23:01:54 2012
PMON: terminating instance due to error 474Instance terminated by PMON, pid = 10718
Thu Jul  5 23:02:21 2012
Starting ORACLE instance (normal)
Cannot determine all dependent dynamic libraries for /proc/self/exe
Unable to find dynamic library libocr10.so in search paths
RPATH = /ade/aime1_build2101/oracle/has/lib/:/ade/aime1_build2101/oracle/lib/:/ade/aime1_build2101/oracle/has/lib/:
LD_LIBRARY_PATH is not set!
The default library directories are /lib and /usr/lib
Unable to find dynamic library libocrb10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
Unable to find dynamic library libocrutl10.so in search paths
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
Using LOG_ARCHIVE_DEST_1 parameter default value as /usr/local/oracle/dbs/arch
Autotune of undo retention is turned on.  
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.1.0.
System parameters with non-default values:
   processes                = 150
   __shared_pool_size       = 79691776
   __large_pool_size        = 4194304
   __java_pool_size         = 4194304
   __streams_pool_size      = 4194304
   sga_target               = 285212672
   control_files            = /usr/local/oracle/oradata/techdb/control01.ctl, /usr/local/oracle/oradata/techdb/control02.ctl, /usr/local/oracle/oradata/techdb/control03.ctl
   db_block_size            = 8192
   __db_cache_size          = 184549376
   compatible               = 10.2.0.1.0
   db_file_multiblock_read_count= 16
   undo_management          = AUTO
   undo_tablespace          = UNDOTBS1
   _kgl_large_heap_warning_threshold= 52428800
   remote_login_passwordfile= EXCLUSIVE
   db_domain                =  
   dispatchers              = (PROTOCOL=TCP) (SERVICE=techdbXDB)
   job_queue_processes      = 10
   background_dump_dest     = /usr/local/oracle/admin/techdb/bdump
   user_dump_dest           = /usr/local/oracle/admin/techdb/udump
   core_dump_dest           = /usr/local/oracle/admin/techdb/cdump
   audit_file_dest          = /usr/local/oracle/admin/techdb/adump
   db_name                  = techdb
   open_cursors             = 300
   pga_aggregate_target     = 94371840
PMON started with pid=2, OS id=10967
PSP0 started with pid=3, OS id=10969
MMAN started with pid=4, OS id=10971
DBW0 started with pid=5, OS id=10973
LGWR started with pid=6, OS id=10975
CKPT started with pid=7, OS id=10977
SMON started with pid=8, OS id=10979
RECO started with pid=9, OS id=10981
CJQ0 started with pid=10, OS id=10983
MMON started with pid=11, OS id=10985
Thu Jul  5 23:02:21 2012
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=12, OS id=10987
Thu Jul  5 23:02:21 2012
starting up 1 shared server(s) ...
Thu Jul  5 23:02:21 2012
ALTER DATABASE   MOUNT
Thu Jul  5 23:02:25 2012
Setting recovery target incarnation to 2
Thu Jul  5 23:02:25 2012
Successful mount of redo thread 1, with mount id 3665578877
Thu Jul  5 23:02:25 2012
Database mounted in Exclusive Mode
Completed: ALTER DATABASE   MOUNT
Thu Jul  5 23:02:25 2012
ALTER DATABASE OPEN
Thu Jul  5 23:02:25 2012
Beginning cras