GBase 8a 备份恢复gcrcman

GNAIXGNAHZ

已于 2023-05-23 09:37:34 修改

阅读量225

点赞数

分类专栏： GBase8a 文章标签：数据库

于 2023-03-12 20:31:40 首次发布

本文链接：https://blog.csdn.net/qq_34479012/article/details/129480144

版权

GBase8a 专栏收录该内容

17 篇文章 2 订阅

订阅专栏

GBase提供备份恢复工具gcrcman，支持库级备份、表级备份

使用前需要安装pexpect

官网下载ptyprocess · PyPI

官网下载pexpect · PyPI

[root@bogon opt]# tar -zxvf pexpect-4.8.0.tar.gz
[root@bogon opt]# tar -zxvf ptyprocess-0.7.0.tar.gz

[root@bogon opt]# cd /opt/pexpect-4.8.0/
[root@bogon pexpect-4.8.0]# python /opt/pexpect-4.8.0/setup.py install

[root@bogon pexpect-4.8.0]# cd /opt/ptyprocess-0.7.0
[root@bogon ptyprocess-0.7.0]# python setup.py install

表备份

[gbase@bogon bin]$ mkdir -p /home/gbase/backuptest/
[gbase@bogon bin]$ gcrcman.py -d /home/gbase/backuptest/ -p gbase20110531 -U gbase -P gbase

gcrcman>backup table test.t2 level 0
03.12 20:03:53  BackUp table vcname000001.test.t2 start 
--------------------------------------------
03.12 20:03:54  node (192.168.61.173)  backup table begin 
03.12 20:03:54  node (192.168.61.174)  backup table begin 
03.12 20:03:54  node (192.168.61.175)  backup table begin 
03.12 20:04:12  node (192.168.61.173)  backup table success 
03.12 20:04:12  node (192.168.61.174)  backup table success 
03.12 20:04:12  node (192.168.61.175)  backup table success 
--------------------------------------------
03.12 20:04:12  BackUp table vcname000001.test.t2 end 
gcrcman>show backup
cycle	point	level	time
0	0	0	2023-03-12 20:03:54

[gbase@bogon bin]$ cd /home/gbase/backuptest/
[gbase@bogon backuptest]$ ll
total 0
drwxrwxr-x 3 gbase gbase 96 Mar 12 20:04 GclusterData_coordinator1_node2

表恢复

[gbase@bogon bin]$ gcrcman.py -d/home/gbase/backuptest/ -p Gbase20110531! -U root -P gbase
gcrcman>show backup  
cycle	point	level	time
0	0	0	2023-03-12 20:03:54
gcrcman>recover table test.t2
03.12 20:13:55  check Table topology start 
--------------------------------------------
03.12 20:13:55  node (192.168.61.173)  check table topology begin 
03.12 20:13:56  node (192.168.61.173)  check table topology success 
--------------------------------------------
03.12 20:13:56  check table topology success 
03.12 20:13:56  check Table BackUp start 
--------------------------------------------
03.12 20:13:56  node (192.168.61.173)  check table backup begin 
03.12 20:13:56  node (192.168.61.174)  check table backup begin 
03.12 20:13:56  node (192.168.61.175)  check table backup begin 
03.12 20:14:05  node (192.168.61.173)  check table backup success 
03.12 20:14:05  node (192.168.61.174)  check table backup success 
03.12 20:14:05  node (192.168.61.175)  check table backup success 
--------------------------------------------
03.12 20:14:05  check table BackUp success 
03.12 20:14:05  refresh table vcname000001.test.t2 start 
03.12 20:14:05  node (192.168.61.173)  recreate table begin 
03.12 20:14:06  node (192.168.61.173)  recreate table success 
03.12 20:14:06  refresh table vcname000001.test.t2 end 
03.12 20:14:06  Recover table vcname000001.test.t2 start 
--------------------------------------------
03.12 20:14:06  node (192.168.61.173)  Recover table begin 
03.12 20:14:06  node (192.168.61.174)  Recover table begin 
03.12 20:14:06  node (192.168.61.175)  Recover table begin 
03.12 20:14:21  node (192.168.61.173)  Recover table success 
03.12 20:14:21  node (192.168.61.174)  Recover table success 
03.12 20:14:21  node (192.168.61.175)  Recover table success 
--------------------------------------------
03.12 20:14:21  Recover table vcname000001.test.t2 success, please refresh it! 


[gbase@bogon bin]$ gccli -uroot -pGbase20110531!

GBase client 9.5.3.27.14_patch.1b41b5c1. Copyright (c) 2004-2023, GBase.  All Rights Reserved.

gbase> refresh table test.t2;       
Query OK, 0 rows affected (Elapsed: 00:00:00.01)

gbase> select * from test.t2;
+------+
| no   |
+------+
|    2 |
+------+
1 row in set (Elapsed: 00:00:00.01)