Oracle数据库运行时DOWN掉，之后重启，但没有过几分钟数据又DOWN掉，
alert.trc日志如下：
想请教一下：1、在什么样的情况下会导致该问题的发生，以后好加以预防？
2、这种问题如何最终解决？
Sat Apr5 17:14:43 2008
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/oracle/product/db10gr2h
Autotune of undo retention is turned on.
IMODE=BR
ILAT =42
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.2.0.
System parameters with non-default values:
processes
= 350
sga_max_size
= 16106127360
lock_sga
= TRUE
__shared_pool_size = 503316480
__large_pool_size= 16777216
__java_pool_size = 16777216
__streams_pool_size= 0
nls_language
= SIMPLIFIED CHINESE
nls_territory
= CHINA
sga_target
= 16106127360
control_files
= /pcrpt/pcrpt_u01/pcrpt/control01.ctl, /pcrpt/pcrptl
db_block_size
= 32768
__db_cache_size
= 15552479232
compatible
= 10.2.0.2.0
log_buffer
= 14230528
db_files
= 2048
db_file_multiblock_read_count= 32
undo_management
= AUTO
undo_tablespace
= UNDOTBS1
remote_login_passwordfile= EXCLUSIVE
db_domain
=
dispatchers
= (PROTOCOL=TCP) (SERVICE=pcrptXDB)
job_queue_processes= 10
background_dump_dest = /u01/oracle/admin/pcrpt/bdump
user_dump_dest = /u01/oracle/admin/pcrpt/udump
core_dump_dest = /u01/oracle/admin/pcrpt/cdump
audit_file_dest
= /u01/oracle/admin/pcrpt/adump
db_name
= pcrpt
open_cursors
= 300
pga_aggregate_target = 5143265280
PMON started with pid=2, OS id=422580
PSP0 started with pid=3, OS id=218074
MMAN started with pid=4, OS id=443068
DBW0 started with pid=5, OS id=213846
DBW1 started with pid=6, OS id=282826
LGWR started with pid=7, OS id=410074
CKPT started with pid=8, OS id=278712
SMON started with pid=9, OS id=401826
RECO started with pid=10, OS id=274642
CJQ0 started with pid=11, OS id=270516
MMON started with pid=12, OS id=438988
Sat Apr5 17:14:44 2008
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCO.
MMNL started with pid=13, OS id=397726
Sat Apr5 17:14:44 2008
starting up 1 shared server(s) ...
Sat Apr5 17:14:44 2008
ALTER DATABASE MOUNT
Sat Apr5 17:14:48 2008
Setting recovery target incarnation to 1
Sat Apr5 17:14:48 2008
Successful mount of redo thread 1, with mount id 4177586692
Sat Apr5 17:14:48 2008
Database mounted in Exclusive Mode
Completed: ALTER DATABASE MOUNT
Sat Apr5 17:14:48 2008
ALTER DATABASE OPEN
Sat Apr5 17:14:48 2008
Beginning crash recovery of 1 threads
parallel recovery started with 15 processes
Sat Apr5 17:14:49 2008
Started redo scan
Sat Apr5 17:14:49 2008
Completed redo scan
13 redo blocks read, 6 data blocks need recovery
Sat Apr5 17:14:49 2008
Started redo application at
Thread 1: logseq 28250, block 2901
Sat Apr5 17:14:49 2008
Recovery of Online Redo Log: Thread 1 Group 6 Seq 28250 Reading mem 0
Mem# 0 errs 0: /pcrpt/pcrpt_u05/redo06.log
Mem# 1 errs 0: /pcrpt/pcrpt_u14/redo06a.log
Sat Apr5 17:14:49 2008
Completed redo application
Sat Apr5 17:14:49 2008
Completed crash recovery at
Thread 1: logseq 28250, block 2914, scn 42627504082
6 data blocks read, 6 data blocks written, 13 redo blocks read
Sat Apr5 17:14:49 2008
Thread 1 advanced to log sequence 28251
Thread 1 opened at log sequence 28251
Current log# 4 seq# 28251 mem# 0: /pcrpt/pcrpt_u02/redo04.log
Current log# 4 seq# 28251 mem# 1: /pcrpt/pcrpt_u12/redo04a.log
Successful open of redo thread 1
Sat Apr5 17:14:49 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Sat Apr5 17:14:49 2008
SMON: enabling cache recovery
Sat Apr5 17:14:49 2008
Successfully onlined Undo Tablespace 1.
Sat Apr5 17:14:49 2008
SMON: enabling tx recovery
Sat Apr5 17:14:50 2008
Database Characterset is AL32UTF8
Sat Apr5 17:14:50 2008
SMON: Restarting fast_start parallel rollback
Sat Apr5 17:14:50 2008
replication_dependency_tracking turned off (no async multimaster replication fo)
Starting background process QMNC
QMNC started with pid=50, OS id=115474
Sat Apr5 17:14:50 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_p000_389524.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [6006], [1], [], [], [], [], [], []
Sat Apr5 17:14:50 2008
Completed: ALTER DATABASE OPEN
Sat Apr5 17:14:52 2008
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sat Apr5 17:14:52 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
ORACLE Instance pcrpt (pid = 9) - Error 600 encountered while recovering transa.
Sat Apr5 17:14:53 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
Sat Apr5 17:19:56 2008
SMON: Restarting fast_start parallel rollback
Sat Apr5 17:19:56 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_p000_434930.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [6006], [1], [], [], [], [], [], []
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sat Apr5 17:19:58 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
ORACLE Instance pcrpt (pid = 9) - Error 600 encountered while recovering transa.
Sat Apr5 17:19:59 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
Sat Apr5 17:25:01 2008
SMON: Restarting fast_start parallel rollback
Sat Apr5 17:25:01 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_p000_434932.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [6006], [1], [], [], [], [], [], []
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sat Apr5 17:25:03 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
ORACLE Instance pcrpt (pid = 9) - Error 600 encountered while recovering transa.
Sat Apr5 17:25:04 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
Sat Apr5 17:30:06 2008
SMON: Restarting fast_start parallel rollback
Sat Apr5 17:30:07 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_p000_434934.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [6006], [1], [], [], [], [], [], []
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sat Apr5 17:30:08 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
ORACLE Instance pcrpt (pid = 9) - Error 600 encountered while recovering transa.
Sat Apr5 17:30:10 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
Sat Apr5 17:35:12 2008
SMON: Restarting fast_start parallel rollback
Sat Apr5 17:35:12 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_p000_434936.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [6006], [1], [], [], [], [], [], []
SMON: Parallel transaction recovery slave got internal error
SMON: Downgrading transaction recovery to serial
Sat Apr5 17:35:14 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_smon_401826.trc:
ORA-00600: 鍐呴儴閿欒?浠ｇ爜, 鍙傛暟: [4137], [], [], [], [], [], [], []
Sat Apr5 17:35:17 2008
Errors in file /u01/oracle/admin/pcrpt/bdump/pcrpt_pmon_422580.trc:
ORA-00474: SMON 杩▼彘敊璇?
|
