数据库实例突然停止，手工启动后回复。查看alert日志中没有任何提示，不知何故，盼高手解答。
Sun Oct 31 16:00:53 2010
Thread 1 advanced to log sequence 2773
Current log# 2 seq# 2773 mem# 0: +DATA/nsadbp/onlinelog/group_2.283.656692761
Current log# 2 seq# 2773 mem# 1: +LOG/nsadbp/onlinelog/group_2.269.656692765
Mon Nov 01 09:11:09 2010
Thread 1 advanced to log sequence 2774
Current log# 3 seq# 2774 mem# 0: +DATA/nsadbp/onlinelog/group_3.284.656692769
Current log# 3 seq# 2774 mem# 1: +LOG/nsadbp/onlinelog/group_3.270.656692773
Mon Nov 01 09:45:43 2010
Thread 1 advanced to log sequence 2775
Current log# 1 seq# 2775 mem# 0: +DATA/nsadbp/onlinelog/group_1.282.656692753
Current log# 1 seq# 2775 mem# 1: +LOG/nsadbp/onlinelog/group_1.268.656692757
Dump file e:\oracle\product\10.2.0\admin\nsadbp\bdump\alert_nsadbp.log
Mon Nov 01 10:35:51 2010
ORACLE V10.2.0.3.0 - 64bit Production vsnsta=0
vsnsql=14 vsnxtr=3
Windows NT Version V5.2 Service Pack 2
CPU
: 16 - type 8664, 4 Physical Cores
Process Affinity: 0x0000000000000000
Memory (Avail/Total): Ph:7518M/16378M, Ph+PgF:8538M/23959M
Mon Nov 01 10:35:51 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =121
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.3.0.
System parameters with non-default values:
processes
= 1000
sessions
= 1105
sga_max_size
= 6442450944
__shared_pool_size = 2583691264
__large_pool_size= 16777216
__java_pool_size = 67108864
__streams_pool_size= 0
spfile
= +DATA/nsadbp/spfilensadbp.ora
nls_language
= SIMPLIFIED CHINESE
nls_territory
= CHINA
sga_target
= 4294967296
control_files
= +DATA/nsadbp/controlfile/current.281.656692751, +LOG/nsadbp/controlfile/current.267.656692751, E:\CONTROLFILE\NSADBP\CONTROLFILE1.CTL
db_block_size
= 16384
__db_cache_size
= 1610612736
compatible
= 10.2.0.3.0
log_archive_dest_1 = LOCATION=+LOG/nsadbp/
log_archive_format = ARC%S_%R.%T
db_file_multiblock_read_count= 16
db_create_file_dest= +DATA
db_recovery_file_dest= +LOG
db_recovery_file_dest_size= 429496729600
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=nsadbpXDB)
local_listener = LISTENER_NSADBP
job_queue_processes= 10
audit_file_dest
= E:\ORACLE\PRODUCT\10.2.0\ADMIN\NSADBP\ADUMP
background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\NSADBP\BDUMP
user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\NSADBP\UDUMP
core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\NSADBP\CDUMP
sort_area_size = 1024000000
sort_area_retained_size= 1024000000
db_name
= nsadbp
open_cursors
= 1000
pga_aggregate_target = 1706033152
PMON started with pid=2, OS id=9316
PSP0 started with pid=3, OS id=3088
MMAN started with pid=4, OS id=9672
DBW0 started with pid=5, OS id=880
DBW1 started with pid=6, OS id=9564
LGWR started with pid=7, OS id=3196
CKPT started with pid=8, OS id=10208
SMON started with pid=9, OS id=5168
RECO started with pid=10, OS id=9884
CJQ0 started with pid=11, OS id=7220
MMON started with pid=12, OS id=10172
Mon Nov 01 10:35:52 2010
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
MMNL started with pid=13, OS id=9064
Mon Nov 01 10:35:52 2010
starting up 1 shared server(s) ...
Oracle Data Guard is not available in this edition of Oracle.
Mon Nov 01 10:35:52 2010
alter database mount exclusive
Mon Nov 01 10:35:54 2010
Starting background process ASMB
ASMB started with pid=17, OS id=9060
Starting background process RBAL
RBAL started with pid=18, OS id=9684
Mon Nov 01 10:35:59 2010
SUCCESS: diskgroup DATA was mounted
SUCCESS: diskgroup LOG was mounted
Mon Nov 01 10:36:04 2010
Setting recovery target incarnation to 1
Mon Nov 01 10:36:04 2010
Successful mount of redo thread 1, with mount id 1633101832
Mon Nov 01 10:36:04 2010
Database mounted in Exclusive Mode
Completed: alter database mount exclusive
Mon Nov 01 10:36:04 2010
alter database open
Mon Nov 01 10:36:04 2010
Beginning crash recovery of 1 threads
Mon Nov 01 10:36:04 2010
Started redo scan
Mon Nov 01 10:36:04 2010
Completed redo scan
123593 redo blocks read, 3923 data blocks need recovery
Mon Nov 01 10:36:05 2010
Started redo application at
Thread 1: logseq 2775, block 593992
Mon Nov 01 10:36:05 2010
Recovery of Online Redo Log: Thread 1 Group 1 Seq 2775 Reading mem 0
Mem# 0: +DATA/nsadbp/onlinelog/group_1.282.656692753
Mem# 1: +LOG/nsadbp/onlinelog/group_1.268.656692757
Mon Nov 01 10:36:06 2010
Completed redo application
Mon Nov 01 10:36:06 2010
Completed crash recovery at
Thread 1: logseq 2775, block 717585, scn 4177500632
3923 data blocks read, 3923 data blocks written, 123593 redo blocks read
Mon Nov 01 10:36:06 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=20, OS id=10064
Mon Nov 01 10:36:06 2010
ARC0: Archival started
ARC1 started with pid=21, OS id=1052
Mon Nov 01 10:36:06 2010
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
Thread 1 advanced to log sequence 2776
Thread 1 opened at log sequence 2776
Current log# 4 seq# 2776 mem# 0: +DATA/nsadbp/onlinelog/group_4.291.656928827
Mon Nov 01 10:36:07 2010
ARC0: Becoming the 'no FAL' ARCH
Mon Nov 01 10:36:07 2010
Current log# 4 seq# 2776 mem# 1: E:\REDOLOG\NSADBP\REDOLOGFILE1
Mon Nov 01 10:36:07 2010
ARC0: Becoming the 'no SRL' ARCH
Mon Nov 01 10:36:07 2010
Successful open of redo thread 1
Mon Nov 01 10:36:07 2010
ARC1: Becoming the heartbeat ARCH
Mon Nov 01 10:36:07 2010
SMON: enabling cache recovery
Mon Nov 01 10:36:08 2010
Successfully onlined Undo Tablespace 1.
Mon Nov 01 10:36:08 2010
SMON: enabling tx recovery
Mon Nov 01 10:36:08 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=23, OS id=4384
Mon Nov 01 10:36:11 2010
Completed: alter database open
Mon Nov 01 10:36:11 2010
db_recovery_file_dest_size of 409600 MB is 0.38% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
|
