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