Oracle alert文件分析(四)
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
LMS 3: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Set master node info
Submitted all remote-enqueue requests
Dwn-cvts replayed, VALBLKs dubious
All grantable enqueues granted
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
minact-scn: Master returning as live inst:2 has in
c# mismatch instinc:0 cur:4 errcnt:0
2013-05-20 09:26:57.692000 +08:00
Starting background process SMCO -- 该进程负责空间管理协调管理工作，负责执行空间的分配和回收。
SMCO started with pid=41, OS id=2884590
2013-05-20 09:30:51.966000 +08:00
Time drift detected. Please check VKTM trace file for more details.
2013-05-20 09:36:21.723000 +08:00
db_recovery_file_dest_size of 5727 MB is 62.98% 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
ALTER SYSTEM SET local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.48.13.130)(PORT=1521))))' SCOPE=
[name='en5', type=1, ip=169.254.25.4, mac=e4-1f-13-4f-b8-da, net=169.254.0.0/16, mask=255.255.0.0, use=haip:cluster_interc
Dumping diagnostic data in directory=[cdmp_20130520085448], requested by (instance=1, osid=6619738 (LMHB)), summary=[abnorma
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
2013-05-20 08:52:15.183000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80074):
ORA-32701: Possible hangs up to hang ID=136 detected ylqiu_1028@126.com
2013-05-20 08:52:30.247000 +08:00
DIA0 terminating blocker (ospid: 14484116 sid: 644 ser#: 859) of hang with ID = 136
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
significant number of affected sessions.
by terminating the process
DIA0 successfully terminated process ospid:14484116.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=136.
2013-05-20 08:52:34.807000 +08:00
Sweep [inc][80074]: completed
Sweep [inc][80073]: completed
2013-05-20 08:52:37.671000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80075):
ORA-32701: Possible hangs up to hang ID=137 detected
2013-05-20 08:52:52.777000 +08:00
DIA0 terminating blocker (ospid: 11862904 sid: 23 ser#: 355) of hang with ID = 137
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
significant number of affected sessions.
by terminating the process
DIA0 successfully terminated process ospid:11862904.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=137.
2013-05-20 08:52:55.847000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80076):
ORA-32701: Possible hangs