- 最后登录
- 2017-8-28
- 在线时间
- 5 小时
- 威望
- 0
- 金钱
- 42
- 注册时间
- 2017-7-17
- 阅读权限
- 10
- 帖子
- 13
- 精华
- 0
- 积分
- 0
- UID
- 2510
|
5#
发表于 2017-7-19 12:53:03
Liu Maclean(刘相兵 发表于 2017-7-17 17:46
WARNING: failed to read mirror side 1 of virtual extent 4 logical extent 0 of file 302 in group [5.4 ...
刘总,今天的故障,操作系统层面有重启的现象,数据库层面有时间漂移告警,但是无法确认实例挂掉的真正原因。
两台windows环境的RAC,其中一台突然宕机,以下是宕机那台ORACLE报错日志:
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Wed Jul 19 11:11:20 2017
Warning: VKTM detected a time drift.
Time drifts can result in an unexpected behavior such as time-outs. Please check trace file for more details.
Wed Jul 19 11:46:43 2017
Reconfiguration started (old inc 28, new inc 30)
List of instances:
1 (myinst: 1)
Global Resource Directory frozen
* dead instance detected - domain 0 invalid = TRUE
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Jul 19 11:46:45 2017
LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed Jul 19 11:46:45 2017
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed Jul 19 11:46:45 2017
LMS 1: 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
Post SMON to start 1st pass IR
Wed Jul 19 11:46:48 2017
minact-scn: Inst 1 is now the master inc#:30 mmon proc-id:5644 status:0x7
minact-scn status: grec-scn:0x0000.00000000 gmin-scn:0x0000.1d0ecabe gcalc-scn:0x0000.1d0ecad8
minact-scn: master found reconf/inst-rec before recscn scan old-inc#:30 new-inc#:30
Wed Jul 19 11:46:48 2017
Instance recovery: looking for dead threads
Beginning instance recovery of 1 threads
Submitted all GCS remote-cache requests
Post SMON to start 1st pass IR
Fix write in gcs resources
Reconfiguration complete
parallel recovery started with 31 processes
Started redo scan
Completed redo scan
read 936 KB redo, 186 data blocks need recovery
Started redo application at
Thread 2: logseq 2804, block 200490
Recovery of Online Redo Log: Thread 2 Group 4 Seq 2804 Reading mem 0
Mem# 0: +DATA/cdjcws/onlinelog/group_4.266.868297653
Mem# 1: +FRA/cdjcws/onlinelog/group_4.260.868297655
Completed redo application of 0.29MB
Completed instance recovery at
Thread 2: logseq 2804, block 202362, scn 487528908
182 data blocks read, 189 data blocks written, 936 redo k-bytes read
Thread 2 advanced to log sequence 2805 (thread recovery)
Redo thread 2 internally disabled at seq 2805 (SMON)
minact-scn: master continuing after IR
Wed Jul 19 11:46:55 2017
Thread 1 advanced to log sequence 1873 (LGWR switch)
Current log# 1 seq# 1873 mem# 0: +DATA/cdjcws/onlinelog/group_1.261.868297405
Current log# 1 seq# 1873 mem# 1: +FRA/cdjcws/onlinelog/group_1.257.868297407
Wed Jul 19 11:46:56 2017
Archived Log entry 4675 added for thread 1 sequence 1872 ID 0x96266c76 dest 1:
Wed Jul 19 11:46:57 2017
Archived Log entry 4676 added for thread 2 sequence 2804 ID 0x96266c76 dest 1:
Wed Jul 19 11:46:58 2017
ARC2: Archiving disabled thread 2 sequence 2805
Archived Log entry 4677 added for thread 2 sequence 2805 ID 0x96266c76 dest 1:
Wed Jul 19 11:47:48 2017
Decreasing number of real time LMS from 3 to 0
Wed Jul 19 11:56:58 2017
db_recovery_file_dest_size of 819200 MB is 0.55% 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
space available in the underlying filesystem or ASM diskgroup.
Wed Jul 19 12:05:44 2017
Reconfiguration started (old inc 30, new inc 32)
List of instances:
1 2 (myinst: 1)
Global Resource Directory frozen
Communication channels reestablished
Master broadcasted resource hash value bitmaps
Non-local Process blocks cleaned out
Wed Jul 19 12:05:44 2017
LMS 2: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed Jul 19 12:05:44 2017
LMS 1: 0 GCS shadows cancelled, 0 closed, 0 Xw survived
Wed Jul 19 12:05:44 2017
LMS 0: 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
Wed Jul 19 12:05:46 2017
minact-scn: Master returning as live inst:2 has inc# mismatch instinc:0 cur:32 errcnt:0
Submitted all GCS remote-cache requests
Fix write in gcs resources
Reconfiguration complete
Wed Jul 19 12:06:58 2017
Increasing number of real time LMS from 0 to 3
Wed Jul 19 12:11:58 2017
db_recovery_file_dest_size of 819200 MB is 0.55% 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
space available in the underlying filesystem or ASM diskgroup. |
|