GBase 8a Mpp自动同步功能三种恢复日志记录方式

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

原创文章,作者:kirin,如若转载,请注明出处:https://blog.ytso.com/tech/bigdata/317861.html

(0)
上一篇 1天前
下一篇 1天前

相关推荐

发表回复

登录后才能评论