oracle 10.2.0.1 rac ,hp-ux 11.23,最近老自动重启。请高手帮助指点，谢谢！下面是昨晚的日志。
Thread 1 advanced to log sequence 6536
Current log# 2 seq# 6536 mem# 0: /dev/vgredo/rredo2
Mon Aug 30 23:30:03 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_j000_1721.trc:
ORA-12012: error on auto execute of job 8888
ORA-08103: object no longer exists
Tue Aug 31 00:35:08 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms0_1269.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4519] [5] [79364942] [0]
Tue Aug 31 00:35:09 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms0_1269.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4519] [5] [79364942] [0]
Tue Aug 31 00:35:09 2010
Trace dumping is performing id=[cdmp_20100831003509]
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms0_1269.trc:
ORA-00600: Message 600 not found; No message file for product=RDBMS, facility=ORA; arguments: [4519] [5] [79364942] [0]
Tue Aug 31 00:35:12 2010
LMS0: terminating instance due to error 484
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lgwr_1299.trc:
ORA-00484: Message 484 not found; No message file for product=RDBMS, facility=ORA
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_smon_1314.trc:
ORA-00484: Message 484 not found; No message file for product=RDBMS, facility=ORA
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lms1_1271.trc:
ORA-00484: Message 484 not found; No message file for product=RDBMS, facility=ORA
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lmd0_1265.trc:
ORA-00484: Message 484 not found; No message file for product=RDBMS, facility=ORA
Tue Aug 31 00:35:12 2010
Errors in file /opt/oracle/admin/orcl/bdump/orcl1_lmon_1263.trc:
ORA-00484: Message 484 not found; No message file for product=RDBMS, facility=ORA
Instance terminated by LMS0, pid = 1269
Tue Aug 31 00:36:15 2010
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Interface type 1 lan0 192.168.1.0 configured from OCR for use as a cluster interconnect
Interface type 1 lan1 10.92.131.0 configured from OCR for use as a public interface
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
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 = 800
sessions = 885
sga_max_size = 5368709120
__shared_pool_size = 587202560
__large_pool_size = 16777216
__java_pool_size = 33554432
__streams_pool_size = 0
nls_language = ENGLISH
nls_territory = CHINA
dbwr_io_slaves = 4
sga_target = 5368709120
control_files = /dev/vgcont/rcont1, /dev/vgcont/rcont2, /dev/vgcont/rcont3
db_block_size = 16384
__db_cache_size = 4714397696
compatible = 10.2.0.1.0
log_archive_start = TRUE
log_archive_dest = /opt/oracle/arch
db_file_multiblock_read_count= 16
cluster_database = TRUE
cluster_database_instances= 2
thread = 1
_allow_resetlogs_corruption= FALSE
_allow_read_only_corruption= FALSE
instance_number = 1
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 900
_kgl_large_heap_warning_threshold= 16777216
remote_login_passwordfile= EXCLUSIVE
db_domain =
local_listener = ORCL1
remote_listener = LISTENERS_ORCL
job_queue_processes = 10
background_dump_dest = /opt/oracle/admin/orcl/bdump
user_dump_dest = /opt/oracle/admin/orcl/udump
core_dump_dest = /opt/oracle/admin/orcl/cdump
audit_file_dest = /opt/oracle/admin/orcl/adump
db_name = orcl
open_cursors = 3000
pga_aggregate_target = 1380974592
Deprecated system parameters with specified values:
log_archive_start
End of deprecated system parameter listing
Cluster communication is configured to use the following interface(s) for this instance
192.168.1.11
Tue Aug 31 00:36:16 2010
cluster interconnect IPC version:Oracle UDP/IP
IPC Vendor 1 proto 2
PMON started with pid=2, OS id=717
DIAG started with pid=4, OS id=719
PSP0 started with pid=6, OS id=721
LMON started with pid=8, OS id=723
LMD0 started with pid=10, OS id=725
LMS0 started with pid=12, OS id=727
LMS1 started with pid=3, OS id=729
MMAN started with pid=14, OS id=731
DBW0 started with pid=16, OS id=733
LGWR started with pid=5, OS id=735
CKPT started with pid=18, OS id=759
SMON started with pid=20, OS id=767
RECO started with pid=22, OS id=769
CJQ0 started with pid=24, OS id=771
MMON started with pid=26, OS id=773
MMNL started with pid=28, OS id=775
Tue Aug 31 00:36:17 2010
lmon registered with NM - instance id 1 (internal mem no 0)
Tue Aug 31 00:36:18 2010
Reconfiguration started (old inc 0, new inc 60)
List of nodes:
0 1
Global Resource Directory frozen
* allocate domain 0, invalid = TRUE
Communication channels reestablished
* domain 0 valid according to instance 1
* domain 0 valid = 1 according to instance 1
Tue Aug 31 00:36:20 2010
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Tue Aug 31 00:36:20 2010
LMS 0: 0 GCS shadows cancelled, 0 closed
Tue Aug 31 00:36:20 2010
LMS 1: 0 GCS shadows cancelled, 0 closed
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Tue Aug 31 00:36:21 2010
LMS 0: 0 GCS shadows traversed, 0 replayed
Tue Aug 31 00:36:21 2010
LMS 1: 0 GCS shadows traversed, 0 replayed
Tue Aug 31 00:36:21 2010
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
LCK0 started with pid=30, OS id=887
Tue Aug 31 00:36:23 2010
ALTER DATABASE MOUNT
Tue Aug 31 00:36:27 2010
Setting recovery target incarnation to 4
Tue Aug 31 00:36:27 2010
Successful mount of redo thread 1, with mount id 1254595123
Tue Aug 31 00:36:27 2010
Database mounted in Shared Mode (CLUSTER_DATABASE=TRUE)
Completed: ALTER DATABASE MOUNT
Tue Aug 31 00:36:27 2010
ALTER DATABASE OPEN
Tue Aug 31 00:36:28 2010
Picked broadcast on commit scheme to generate SCNs
Tue Aug 31 00:36:28 2010
LGWR: STARTING ARCH PROCESSES
ARC0 started with pid=34, OS id=1029
Tue Aug 31 00:36:28 2010
ARC0: Archival started
ARC1: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC1 started with pid=7, OS id=1039
Tue Aug 31 00:36:28 2010
Thread 1 opened at log sequence 6537
Current log# 1 seq# 6537 mem# 0: /dev/vgredo/rredo1
Successful open of redo thread 1
Tue Aug 31 00:36:28 2010
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Aug 31 00:36:28 2010
ARC0: STARTING ARCH PROCESSES
Tue Aug 31 00:36:28 2010
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
Tue Aug 31 00:36:28 2010
SMON: enabling cache recovery
ARC2 started with pid=36, OS id=1060
Tue Aug 31 00:36:28 2010
ARC2: Archival started
Tue Aug 31 00:36:28 2010
ARC0: STARTING ARCH PROCESSES COMPLETE
ARC0: Becoming the heartbeat ARCH
Tue Aug 31 00:36:29 2010
Successfully onlined Undo Tablespace 1.
Tue Aug 31 00:36:29 2010
SMON: enabling tx recovery
Tue Aug 31 00:36:29 2010
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
QMNC started with pid=40, OS id=1116
Tue Aug 31 00:36:33 2010
Completed: ALTER DATABASE OPEN
Tue Aug 31 00:42:28 2010
Shutting down archive processes
Tue Aug 31 00:42:33 2010
ARCH shutting down
ARC2: Archival stopped
Tue Aug 31 05:43:21 2010
Thread 1 advanced to log sequence 6538
Current log# 2 seq# 6538 mem# 0: /dev/vgredo/rredo2
Tue Aug 31 08:26:38 2010
Thread 1 advanced to log sequence 6539
Current log# 1 seq# 6539 mem# 0: /dev/vgredo/rredo1
Tue Aug 31 08:31:27 2010
Thread 1 cannot allocate new log, sequence 6540
扫一扫
1238
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
