1.ddlevnt
记录方式:以表的执行ddl语句为单位,一条ddl语句记录一个ddlevent
示例:(dwd_acc_actpre_ds_20160629表执行了4条ddl语句)
[gbase@lww-node-3 ~]$ gcadmin showddlevent vc vc1
count:4
Event ID: 88481
ObjectName: bf1.dwd_acc_actpre_ds_20160629
Fail Node Copy:
------------------------------------------------------
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 10.10.4.70 FAILURE
SegName: n1 NodeIP: 10.10.4.70 FAILURE
Event ID: 88482
ObjectName: bf1.dwd_acc_actpre_ds_20160629
Fail Node Copy:
------------------------------------------------------
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 10.10.4.70 FAILURE
SegName: n1 NodeIP: 10.10.4.70 FAILURE
Event ID: 88483
ObjectName: bf1.dwd_acc_actpre_ds_20160629
Fail Node Copy:
------------------------------------------------------
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 10.10.4.70 FAILURE
SegName: n1 NodeIP: 10.10.4.70 FAILURE
Event ID: 88484
ObjectName: bf1.dwd_acc_actpre_ds_20160629
Fail Node Copy:
------------------------------------------------------
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 10.10.4.70 FAILURE
SegName: n1 NodeIP: 10.10.4.70 FAILURE
2.dmlevnt
记录方式:以表为单位,一张表记录一个dmlevent
示例:(cust_order表执行了5条dml语句)
[gbase@lww-node-3 ~]$ gcadmin showdmlevent vc vc1
Vc event count:1
Event ID: 20481
ObjectName: bf1.cust_order
Fail Data Copy:
------------------------------------------------------
SegName: n2 SCN: 1258028 NodeIP: 10.10.4.70 FAILURE
SegName: n1 SCN: 1258034 NodeIP: 10.10.4.70 FAILURE
3.dmlstorageeventevnt
记录方式:以表的分片为单位,一张表的一个分片记录一个dmlstorageevent
示例:(t1表的两个分片损坏)
[gbase@lww-node-1 gcware]$ gcadmin showdmlstorageevent vc vc1
Vc event count:2
Event ID: 12965
ObjectName: test.t1
TableID: 494583
Fail Data Copy:
------------------------------------------------------
SegName: n1 NodeIP: 10.10.2.10 FAILURE
Event ID: 12966
ObjectName: test.t1
TableID: 494583
Fail Data Copy:
------------------------------------------------------
SegName: n2 NodeIP: 10.10.4.70 FAILURE