求救,现在数据库每隔三,四天就down掉一次。
Thu Apr 16 20:34:44 2009
ORACLE V9.2.0.4.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Thu Apr 16 20:34:44 2009
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes
= 300
sessions
= 335
timed_statistics = TRUE
shared_pool_size = 838860800
large_pool_size
= 109051904
java_pool_size = 109051904
control_files
= D:\oracle\oradata\mydata\control01.ctl, D:\oracle\oradata\mydata\control02.ctl, D:\oracle\oradata\mydata\control03.ctl
db_block_size
= 8192
db_cache_size
= 419430400
compatible
= 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain
=
instance_name
= mydata
cursor_sharing = SIMILAR
hash_join_enabled= TRUE
background_dump_dest = D:\oracle\admin\mydata\bdump
user_dump_dest = D:\oracle\admin\mydata\udump
core_dump_dest = D:\oracle\admin\mydata\cdump
sort_area_size = 524288
db_name
= mydata
open_cursors
= 700
star_transformation_enabled= FALSE
query_rewrite_enabled= FALSE
pga_aggregate_target = 419430400
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
Thu Apr 16 20:34:46 2009
alter database mount exclusive
Thu Apr 16 20:34:51 2009
Successful mount of redo thread 1, with mount id 231271462.
Thu Apr 16 20:34:51 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Thu Apr 16 20:34:51 2009
alter database open
Thu Apr 16 20:34:51 2009
Beginning crash recovery of 1 threads
Thu Apr 16 20:34:51 2009
Started first pass scan
Thu Apr 16 20:34:51 2009
Completed first pass scan
1819 redo blocks read, 210 data blocks need recovery
Thu Apr 16 20:34:51 2009
Started recovery at
Thread 1: logseq 27, block 92454, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 27 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\MYDATA\REDO03.LOG
Mem# 1 errs 0: D:\ORACLE\ORADATA\MYDATA\REDO031.LOG
Thu Apr 16 20:34:51 2009
Completed redo application
Thu Apr 16 20:34:52 2009
Ended recovery at
Thread 1: logseq 27, block 94273, scn 0.967624
210 data blocks read, 210 data blocks written, 1819 redo blocks read
Crash recovery completed successfully
Thu Apr 16 20:34:52 2009
Thread 1 advanced to log sequence 28
Thread 1 opened at log sequence 28
Current log# 1 seq# 28 mem# 0: D:\ORACLE\ORADATA\MYDATA\REDO01.LOG
Current log# 1 seq# 28 mem# 1: D:\ORACLE\ORADATA\MYDATA\REDO011.LOG
Successful open of redo thread 1.
Thu Apr 16 20:34:52 2009
SMON: enabling cache recovery
Thu Apr 16 20:34:53 2009
Undo Segment 1 Onlined
Undo Segment 2 Onlined
Undo Segment 3 Onlined
Undo Segment 4 Onlined
Undo Segment 5 Onlined
Undo Segment 6 Onlined
Undo Segment 7 Onlined
Undo Segment 8 Onlined
Undo Segment 9 Onlined
Undo Segment 10 Onlined
Successfully onlined Undo Tablespace 1.
Thu Apr 16 20:34:53 2009
SMON: enabling tx recovery
Thu Apr 16 20:34:53 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open
|