今天有人问以下这个问题，没能解决各位老大给看一下参数设置的是否合理？
如何解决好？
Error while trying to retrieve text for error ORA-03113
ORACLE V8.1.6.0.0
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
内存：512M
以下为数据的参数：
Wed Jun 11 10:42:06 2008
ORACLE V8.1.6.0.0 - Production vsnsta=0
vsnsql=e vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Starting up ORACLE RDBMS Version: 8.1.6.0.0.
System parameters with non-default values:
processes
= 300
shared_pool_size = 52428800
large_pool_size
= 614400
java_pool_size = 20971520
control_files
= D:Oracleoradatamydbcontrol01.ctl, D:Oracleoradatamydbcontrol02.ctl, D:Oracleoradatamydbcontrol03.ctl
db_block_buffers = 19200
db_block_size
= 8192
compatible
= 8.1.0
log_buffer
= 32768
log_checkpoint_interval= 10000
log_checkpoint_timeout = 1800
db_files
= 1024
db_file_multiblock_read_count= 8
max_enabled_roles= 30
remote_login_passwordfile= EXCLUSIVE
global_names
= TRUE
distributed_transactions = 500
instance_name
= mydb
service_names
= mydb
mts_dispatchers
= (PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)
open_links
= 4
sort_area_size = 65536
sort_area_retained_size= 65536
db_name
= mydb
open_cursors
= 100
ifile
= D:Oracleadminmydbpfileinit.ora
os_authent_prefix=
job_queue_processes= 4
job_queue_interval = 10
parallel_max_servers = 5
background_dump_dest = D:Oracleadminmydbdump
user_dump_dest = D:Oracleadminmydbudump
max_dump_file_size = 10240
oracle_trace_collection_name=
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
SNP0 started with pid=8
SNP1 started with pid=9
SNP2 started with pid=10
SNP3 started with pid=11
Wed Jun 11 10:42:09 2008
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Wed Jun 11 10:42:10 2008
ALTER DATABASE MOUNT
Wed Jun 11 10:42:19 2008
Successful mount of redo thread 1, with mount id 2186773706.
Wed Jun 11 10:42:19 2008
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Wed Jun 11 10:42:20 2008
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Wed Jun 11 10:42:21 2008
Thread recovery: start rolling forward thread 1
Recovery of Online Redo Log: Thread 1 Group 1 Seq 1318 Reading mem 0
Mem# 0 errs 0: D:ORACLEORADATAmydbREDO03.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 1319 Reading mem 0
Mem# 0 errs 0: D:ORACLEORADATAmydbREDO02.LOG
Wed Jun 11 10:42:23 2008
Thread recovery: finish rolling forward thread 1
Thread recovery: 154 data blocks read, 110 data blocks written, 886 redo blocks read
Crash recovery completed successfully
Wed Jun 11 10:42:24 2008
Thread 1 advanced to log sequence 1320
Thread 1 opened at log sequence 1320
Current log# 3 seq# 1320 mem# 0: D:ORACLEORADATAmydbREDO01.LOG
Successful open of redo thread 1.
Wed Jun 11 10:42:27 2008
SMON: enabling cache recovery
SMON: enabling tx recovery
Wed Jun 11 10:42:44 2008
Completed: ALTER DATABASE OPEN
|
