日期:2014-05-17  浏览次数:20895 次

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