<\/span><\/h2>\n\n\n\n1\u4e2atestdb.t1\u8868\uff0c\u67094\u884c\u6570\u636e\u3002<\/p>\n\n\n\n
gbase> select count(*) from t1;\n+----------+\n| count(*) |\n+----------+\n| 4 |\n+----------+\n1 row in set (Elapsed: 00:00:00.04)\n<\/code><\/pre>\n\n\n\n<\/span>gcrcman\u547d\u4ee4\u4ecb\u7ecd<\/span><\/h2>\n\n\n\nGBase 8a MPP Cluster \u63d0\u4f9b\u4e13\u7528\u7684\u5907\u4efd\u6062\u590d\u5de5\u5177(gcrcman)\uff0c\u7528\u6237\u4f7f\u7528\u5b83\u53ef\u4ee5\u65b9\u4fbf\u5730\u5bf9\u6574\u4e2a\u96c6\u7fa4\u4e2d\u7684\u6570\u636e\u8fdb\u884c\u96c6\u7fa4\u7684\u5907\u4efd\u548c\u6062\u590d\u3002\u96c6\u7fa4\u7684\u5907\u4efd\u3001\u6062\u590d\u5de5\u5177\u968f\u96c6\u7fa4\u7684\u5b89\u88c5\u81ea\u52a8\u5b89\u88c5\uff0c\u8be5\u5de5\u5177\u88ab\u5b89\u88c5\u5728\/opt\/gcluster\/server\/bin \u76ee\u5f55\u4e0b\u3002\u4e00\u6b21\u5168\u91cf\u5907\u4efd\u5f00\u542f\u4e00\u4e2a\u65b0\u7684\u5468\u671f\u3002\u4e00\u6b21\u589e\u91cf\u5907\u4efd\u5219\u7eed\u5199\u6700\u540e\u4e00\u4e2a\u5907\u4efd\u5468\u671f\uff0c\u4f7f\u5176\u589e\u52a0\u4e00\u4e2a\u5907\u4efd\u70b9\u3002\u5907\u4efd\u6062\u590d\u5de5\u5177\u4f1a\u5bf9\u78c1\u76d8\u7a7a\u95f4\u8fdb\u884c\u68c0\u67e5\uff0c\u5982\u679c\u5b58\u653e\u5907\u4efd\u6570\u636e\u7684\u78c1\u76d8\u7a7a\u95f4\u4e0d\u8db3\uff0c\u4f1a\u62a5\u544a\u9519\u8bef\u4fe1\u606f\u3002<\/p>\n\n\n\n
<\/span>\u53c2\u6570<\/span><\/h3>\n\n\n\n[gbase@localhost ~]$ gcrcman.py --help\nSYNOPSIS\n gcrcman.py [options] <-d|--path BACKUP_PATH>\n\nOPTIONS:\n -h,--help\n Print this help\n -V,--version\n Print version\n -d BACKUP_PATH,--path=BACKUP_PATH\n Specify backup path, it must be absolute path\n -e COMMAND,--execute=COMMAND\n Specify backup or recover command\n -P HOST_PASSWD,--ospassword=HOST_PASSWD\n Specify operation system user gbase's password\n -p DATABASE_PASSWD,--dbpassword=DATABASE_PASSWD\n Specify database user gbase's password\n -r PARALLEL_LEVEL,--parallel=PARALLEL_LEVEL\n Specify parallel level. Parallel level is digital in range [1,128], default 4\n -D,--disk_space_estimate\n Skip estimate disk space before backup or recover\n -c,--checksum_database\n Skip database data checksum\n -C,--checksum_backup_data\n Skip backup data checksum\n -t SECOND,--timeout=SECOND\n Block on read, write or both transaction timeout, should be integar value\n in range [0,3600], default[300 secs]. if zero then block indefinitely\n\nbackup or recover commands:\n 1.show backup show backup data\n 2.backup level <0|1> backup instance\n 3.backup table <dbname.tablename> level <0|1> backup single table\n 4.recover [<cycle_id> [point_id]] recover instance\n 5.recover [force] table <dbname.tablename> [<cycle_id> [point_id]] recover single table\n 6.delete <cycle_id | last> delete backup data\n 7.cleanup clean invalid backup data\n 8.quit exit\n 9.help show help info\n<\/code><\/pre>\n\n\n\ngcrcman \u7684\u5177\u4f53\u529f\u80fd\uff1a\n\uf0b7 \u652f\u6301\u96c6\u7fa4\u7ea7\u3001\u5e93\u7ea7\u3001\u8868\u7ea7\u7684\u5168\u91cf\u5907\u4efd\n\uf0b7 \u652f\u6301\u96c6\u7fa4\u7ea7\u3001\u5e93\u7ea7\u3001\u8868\u7ea7\u7684\u589e\u91cf\u5907\u4efd\n\uf0b7 \u652f\u6301\u96c6\u7fa4\u7ea7\u3001\u5e93\u7ea7\u3001\u8868\u7ea7\u6062\u590d\u5230\u6307\u5b9a\u5907\u4efd\u5468\u671f\u7684\u6307\u5b9a\u5907\u4efd\u70b9\n\uf0b7 \u652f\u6301\u96c6\u7fa4\u7ea7\u3001\u5e93\u7ea7\u3001\u8868\u7ea7\u6062\u590d\u5230\u6700\u65b0\u5907\u4efd\u5468\u671f\u6700\u65b0\u5907\u4efd\u70b9\n\uf0b7 \u652f\u6301\u5f02\u5730\u5907\u4efd\u6062\u590d\uff08nfs \u6302\u8f7d\u5f02\u5730\u5907\u4efd\u6062\u590d\u6570\u636e\u5b58\u653e\u78c1\u76d8\uff09 - \u652f\u6301\u5220\u9664\u5907\u4efd\u548c\u6e05\u9664\u65e0\u6548\u5907\u4efd\n\u6570\u636e\n\uf0b7 \u652f\u6301\u67e5\u770b\u5907\u4efd\u4fe1\u606f\n\uf0b7 \u652f\u6301\u5220\u9664\u5907\u4efd\u6570\u636e\n\uf0b7 \u652f\u6301\u5220\u9664\u5783\u573e\u5907\u4efd\u6570\u636e<\/code><\/pre>\n\n\n\n<\/span>\u5907\u4efd\u524d\u7684\u8981\u6c42<\/span><\/h3>\n\n\n\n- \u5f53\u524d\u7528\u6237\u5fc5\u987b\u662fdbaUser\uff0c\u4e5f\u5c31\u662f\u6570\u636e\u5e93\u5b89\u88c5\u65f6\u7684\u64cd\u4f5c\u7cfb\u7edf\u7528\u6237\uff0c\u4e00\u822c\u662fgbase\u3002<\/li>
- \u5907\u4efd\u76ee\u5f55\u5728\u6bcf\u4e2a\u8282\u70b9\u5fc5\u987b\u5b58\u5728\uff0c\u4e14dbaUser\u6709\u8bfb\u5199\u6743\u9650\u3002<\/li>
- \u5404\u8282\u70b9\u8fd0\u884c\u6b63\u5e38\uff0c\u6ca1\u6709 offline \u8282\u70b9\uff0c\u6ca1\u6709 event \u4e8b\u4ef6\u65e5\u5fd7\uff0c\u6ca1\u6709CLOSED\u670d\u52a1\u7b49\u5f02\u5e38\u60c5\u51b5\u3002<\/li>
- \u5b9e\u4f8b\u7ea7\u7ea7\u5907\u4efd\u524d\uff0c\u6570\u636e\u5e93\u5fc5\u987b\u5904\u4e8ereadonly\u72b6\u6001,\u8fd8\u539f\u65f6\u5fc5\u987b\u65f6recovery\u72b6\u6001\u3002\u5982\u679c\u662f\u591avc\uff0c\u6bcf\u4e2avc\u90fd\u8981\u8bbe\u7f6e\u3002\u8868\u7ea7\u4e0d\u9700\u8981\u3002<\/li>
- \u5b9e\u4f8b\u7ea7\u5907\u4efd\u65f6\u64cd\u4f5c\uff0c\u4f1a\u72ec\u5360\u5907\u4efd\u6062\u590d\u9501\uff0c\u5176\u5b83gcrcman\u8fd0\u884c\u96c6\u7fa4\u5907\u4efd\u4f1a\u62a5\u9519\u3002<\/li>
- \u5b9e\u4f8b\u7ea7\u5907\u4efd\u76ee\u5f55\u4e0d\u80fd\u7528\u4e8e\u5e93\u7ea7\u548c\u8868\u7ea7\u5907\u4efd\u3002<\/li><\/ul>\n\n\n\n
<\/span>\u5907\u4efd\u6062\u590d\u76f8\u5173\u9501\u7684\u4fe1\u606f<\/span><\/h3>\n\n\n\n<\/span>\u96c6\u7fa4\u7ea7\u5e76\u884c\u5907\u4efd\u6062\u590d\u65f6\u65e0\u6cd5\u62ff\u5230\u9501\u7684\u62a5\u9519<\/span><\/h4>\n\n\n\ngcrcman>backup level 0\nfail to get gcrcman instance backup or recover lock\ngcrcman>\n<\/code><\/pre>\n\n\n\n<\/span>\u5b9e\u4f8b\u7ea7\u7ea7\u5907\u4efd\u6062\u590d\u9501\u4fe1\u606f<\/span><\/h4>\n\n\n\n[root@rh6-2 ~]# gcadmin showlock\n +========================================================================================================================+\n | GCLUSTER LOCK |\n +========================================================================================================================+\n +------------------------------------------------+---------+----------------------------------+--------------+------+----+\n | Lock name | owner | content | create time |orphan|type|\n +------------------------------------------------+---------+----------------------------------+--------------+------+----+\n |gcrcmanlock_8c5d910d-85fa-4a45-b7b9-f0282b0c63eb|2001::202|gcrcman instance backup or recover|20230414091550|FALSE | E |\n +------------------------------------------------+---------+----------------------------------+--------------+------+----+\n Total : 1\n<\/code><\/pre>\n\n\n\n<\/span>\u5e93\u7ea7\u5907\u4efd\u7684\u9501<\/span><\/h4>\n\n\n\n[gbase@gbase_rh7_001 root]$ gcadmin showlock\r\n +==================================================================================================+\r\n | GCLUSTER LOCK |\r\n +==================================================================================================+\r\n +----------------------+----------+-------------------------------------+--------------+------+----+\r\n | Lock name | owner | content | create time |locked|type|\r\n +----------------------+----------+-------------------------------------+--------------+------+----+\r\n | gc-event-lock |10.0.2.101| global master |20230414080742| TRUE | E |\r\n +----------------------+----------+-------------------------------------+--------------+------+----+\r\n | vc00001.hashmap_lock |10.0.2.101|gcrcman for table backup lock hashmap|20230414102329| TRUE | S |\r\n +----------------------+----------+-------------------------------------+--------------+------+----+\r\n |vc00001.testdb.db_lock|10.0.2.101| gcrcman for table backup lock db |20230414102329| TRUE | E |\r\n +----------------------+----------+-------------------------------------+--------------+------+----+\r\n Total : 3\r\n<\/code><\/pre>\n\n\n\n<\/span>\u5b9e\u4f8b\u7ea7\u5907\u4efd\u76ee\u5f55\u4e0d\u80fd\u7528\u4ee5\u5e93\u7ea7\u548c\u8868\u7ea7\u5907\u4efd<\/span><\/h4>\n\n\n\ngcrcman>backup database vc1.testdb level 0\nbackup dir already has backup data, and type is 'INSTANCE', please change another backup dir to do 'DATABASE' backup!\ngcrcman>\n<\/code><\/pre>\n\n\n\n<\/span>Log<\/span><\/h2>\n\n\n\ngcrcman.py\u7684\u65e5\u5fd7\u62a5\u9519\u5728gcluster\/log\/gcluster\/gcrcman.log<\/p>\n\n\n\n
<\/span>\u4ea4\u4e92\u6a21\u5f0f<\/span><\/h3>\n\n\n\n\u4e0d\u5e26-e\u53c2\u6570\uff0c\u8fdb\u5165\u4ea4\u4e92\u6a21\u5f0f \uff0c\u6309quit\u6216\u8005Ctrl+c\u9000\u51fa\u3002<\/p>\n\n\n\n
[gbase@localhost ~]$ gcrcman.py -d \/home\/gbase\/backup -P gbase1234 -pXXXXXX\ngcrcman>show backup\ncycle point level time\n0 0 0 2020-09-05 08:09:35\n0 1 1 2020-09-05 08:46:35\ngcrcman>quit\n[gbase@localhost ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u6279\u91cf\u6267\u884c\u6a21\u5f0f<\/span><\/h3>\n\n\n\n\u7528 -e\u53c2\u6570\u6307\u5b9a\u8981\u6267\u884c\u7684\u547d\u4ee4\u5373\u53ef<\/p>\n\n\n\n
[gbase@localhost ~]$ gcrcman.py -d \/home\/gbase\/backup -P gbase1234 -e \"show backup\"\ncycle point level time\n0 0 0 2020-09-05 08:09:35\n0 1 1 2020-09-05 08:46:35\n[gbase@localhost ~]$\n<\/code><\/pre>\n\n\n\n<\/span>\u5f00\u59cb\u5168\u91cf\u5907\u4efd<\/span><\/h2>\n\n\n\n\u901a\u8fc7gcrcman\u547d\u4ee4\u5907\u4efd\u8fd9\u4e2a\u8868\u3002\u5176\u4e2d\u547d\u4ee4\u884c\u7684 <\/p>\n\n\n\n
-d \u662f\u6307\u5b9a\u5907\u4efd\u7684\u76ee\u5f55\uff0c\u5fc5\u987b\u5728\u6bcf\u4e2a\u8282\u70b9\u90fd\u5b58\u5728\uff0c\u4e14gbase\u7528\u6237\u53ef\u5199\u5165\u3002<\/p>\n\n\n\n
-P \u53c2\u6570\u662f\u64cd\u4f5c\u7cfb\u7edfgbase\u7528\u6237\u7684\u5bc6\u7801<\/p>\n\n\n\n
-p \u6267\u884c\u6570\u636e\u5e93gbase\u7528\u6237\u7684\u5bc6\u7801<\/p>\n\n\n\n
backup table \u5e93\u540d.\u8868\u540d level 0|1<\/p>\n\n\n\n
\u5176\u4e2d0\u662f\u5168\u5907\u4efd\uff0c1\u662f\u589e\u91cf\u3002\u672c\u6d4b\u8bd5\u53ea\u6d4b\u8bd5\u5168\u5907\u4efd\u3002<\/p>\n\n\n\n
[gbase@localhost ~]$ gcrcman.py -d \/home\/gbase\/backup -P gbase1234\ngcrcman>backup table testdb.t1 level 0\n09.05 08:09:35 BackUp table testdb.t1 start\n--------------------------------------------\n09.05 08:09:35 node (10.0.2.107) backup table begin\n09.05 08:09:35 node (10.0.2.106) backup table begin\n09.05 08:10:03 node (10.0.2.107) backup table success\n09.05 08:10:03 node (10.0.2.106) backup table success\n--------------------------------------------\n09.05 08:10:03 BackUp table testdb.t1 end\n<\/code><\/pre>\n\n\n\n<\/span>\u67e5\u770b\u5907\u4efd<\/span><\/h2>\n\n\n\n show backup\u547d\u4ee4\uff0c \u5176\u4e2d<\/p>\n\n\n\n
cycle \u662f\u5907\u4efd\u5468\u671f\u7f16\u53f7<\/p>\n\n\n\n
point \u662f\u5907\u4efd\u70b9\u7f16\u53f7<\/p>\n\n\n\n
level \u662f\u5907\u4efd\u7ea7\u522b\uff0c0\u662f\u5168\u5907\uff0c1\u662f\u589e\u91cf<\/p>\n\n\n\n
gcrcman>show backup\ncycle point level time\n0 0 0 2020-09-05 08:09:35\n<\/code><\/pre>\n\n\n\n<\/span>\u5220\u9664\u8868\uff0c\u6a21\u62df\u6545\u969c<\/span><\/h2>\n\n\n\ngbase> drop table t1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.12)\n\ngbase> select count(*) from t1;\nERROR 1146 (42S02): Table 'testdb.t1' doesn't exist\n<\/code><\/pre>\n\n\n\n<\/span>\u8fd8\u539f\u8868<\/span><\/h2>\n\n\n\n \u901a\u8fc7recover table \u5e93\u540d.\u8868\u540d cycleId pointId\u53c2\u6570\uff0c\u672c\u4f8b\u662f0 0<\/p>\n\n\n\n
gcrcman>recover table testdb.t1 0 0\n09.05 08:14:28 check Table topology start\n--------------------------------------------\n09.05 08:14:28 node (10.0.2.107) check table topology begin\n09.05 08:14:31 node (10.0.2.107) check table topology success\n--------------------------------------------\n09.05 08:14:31 check table topology success\n09.05 08:14:31 check Table BackUp start\n--------------------------------------------\n09.05 08:14:31 node (10.0.2.107) check table backup begin\n09.05 08:14:31 node (10.0.2.106) check table backup begin\n09.05 08:14:48 node (10.0.2.107) check table backup success\n09.05 08:14:48 node (10.0.2.106) check table backup success\n--------------------------------------------\n09.05 08:14:48 check table BackUp success\n09.05 08:14:48 refresh table testdb.t1 start\n09.05 08:14:48 node (10.0.2.107) recreate table begin\n09.05 08:14:51 node (10.0.2.107) recreate table success\n09.05 08:14:51 refresh table testdb.t1 end\n09.05 08:14:52 Recover table testdb.t1 start\n--------------------------------------------\n09.05 08:14:52 node (10.0.2.107) Recover table begin\n09.05 08:14:52 node (10.0.2.106) Recover table begin\n09.05 08:15:09 node (10.0.2.107) Recover table success\n09.05 08:15:09 node (10.0.2.106) Recover table success\n--------------------------------------------\n09.05 08:15:09 Recover table testdb.t1 success, please refresh it!\n<\/code><\/pre>\n\n\n\n<\/span>\u9a8c\u8bc1<\/span><\/h2>\n\n\n\n\u6839\u636e\u63d0\u793a\uff0c\u9700\u8981\u5148\u5237\u65b0\u8868\uff0c\u7136\u540e\u67e5\u8be2\u3002\u4e0drefresh table, \u4f1a\u53ea\u770b\u5230\u8868\u7ed3\u6784\uff0c\u4f46\u770b\u4e0d\u5230\u6570\u636e\u3002<\/p>\n\n\n\n
[gbase@862b43 gcluster_0_0]$ gccli testdb -e\"select count(*) from t1\"\n+----------+\n| count(*) |\n+----------+\n| 0 |\n+----------+\n[gbase@862b43 gcluster_0_0]$ gccli testdb -e\"refresh table testdb.t1;select count(*) from t1\"\n+----------+\n| count(*) |\n+----------+\n| 4 |\n+----------+\n<\/code><\/pre>\n\n\n\n<\/span>\u53d8\u52a8\u6570\u636e<\/span><\/h2>\n\n\n\n \u589e\u52a0\u4e00\u884c\u6570\u636e<\/p>\n\n\n\n
gbase> select * from t1;\n+------+-------+-------+\n| id | value | birth |\n+------+-------+-------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |\n| 4 | 999 | NULL |\n+------+-------+-------+\n4 rows in set (Elapsed: 00:00:00.01)\n\ngbase> insert into t1 values (5,555555,'2020-01-03');\nQuery OK, 1 row affected (Elapsed: 00:00:02.91)\n\ngbase> select * from t1;\n+------+--------+---------------------+\n| id | value | birth |\n+------+--------+---------------------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |\n| 4 | 999 | NULL |\n| 5 | 555555 | 2020-01-03 00:00:00 |\n+------+--------+---------------------+\n5 rows in set (Elapsed: 00:00:00.00)\n<\/code><\/pre>\n\n\n\n<\/span>\u589e\u91cf\u5907\u4efd<\/span><\/h2>\n\n\n\n \u518d\u6b21\u505a\u5907\u4efd\uff0c\u8fd9\u56de\u9009\u62e9\u589e\u91cf\uff0c level \u53c2\u6570\u4e3a1. \u6700\u540e\u5f97\u5230\u4e86cycle\u7b49\u4e8e0\u7684\uff0cpoint \u4e3a1\uff0cleve\u4e3a1\u7684\u4e00\u4e2a\u589e\u91cf\u5907\u4efd\u3002<\/p>\n\n\n\n
[gbase@localhost ~]$ gcrcman.py -d \/home\/gbase\/backup -P gbase1234\ngcrcman>show backup\ncycle point level time\n0 0 0 2020-09-05 08:09:35\ngcrcman>backup table testdb.t1 level 1\n09.05 08:46:32 check cluster topology begin\n09.05 08:46:32 node (10.0.2.107) check topology begin\n09.05 08:46:35 node (10.0.2.107) check topology success\n09.05 08:46:35 check cluster topology end\n09.05 08:46:35 BackUp table testdb.t1 start\n--------------------------------------------\n09.05 08:46:35 node (10.0.2.107) backup table begin\n09.05 08:46:35 node (10.0.2.106) backup table begin\n09.05 08:47:06 node (10.0.2.107) backup table success\n09.05 08:47:06 node (10.0.2.106) backup table success\n--------------------------------------------\n09.05 08:47:06 BackUp table testdb.t1 end\ngcrcman>show backup\ncycle point level time\n0 0 0 2020-09-05 08:09:35\n0 1 1 2020-09-05 08:46:35\n<\/code><\/pre>\n\n\n\n<\/span> \u518d\u6b21\u8fd8\u539f<\/span><\/h2>\n\n\n\n \u5728\u8fd8\u539f\u524d\uff0c\u9700\u8981\u5148\u5220\u9664\u6389\u8868\uff0c\u5426\u5219\u4f1a\u62a5\u9519\u3002Table testdb.t1 exist, please drop it at first<\/p>\n\n\n\n
gcrcman>show backup\ncycle point level time\n0 0 0 2020-09-05 08:09:35\n0 1 1 2020-09-05 08:46:35\ngcrcman>recover table testdb.t1 0 1\n09.05 08:48:36 check Table topology start\n--------------------------------------------\n09.05 08:48:36 node (10.0.2.107) check table topology begin\n09.05 08:48:39 node (10.0.2.107) check table topology success\n--------------------------------------------\n09.05 08:48:39 check table topology success\n09.05 08:48:39 check Table BackUp start\n--------------------------------------------\n09.05 08:48:39 node (10.0.2.107) check table backup begin\n09.05 08:48:39 node (10.0.2.106) check table backup begin\n09.05 08:48:59 node (10.0.2.107) check table backup success\n09.05 08:48:59 node (10.0.2.106) check table backup success\n--------------------------------------------\n09.05 08:48:59 check table BackUp success\nTable testdb.t1 exist, please drop it at first\n<\/code><\/pre>\n\n\n\n\u5220\u9664\u8868<\/p>\n\n\n\n
gbase> select * from t1;\n+------+-------+-------+\n| id | value | birth |\n+------+-------+-------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |\n| 4 | 999 | NULL |\n+------+-------+-------+\n4 rows in set (Elapsed: 00:00:00.01)\n\ngbase> drop table t1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.07)\n<\/code><\/pre>\n\n\n\n\u518d\u6b21\u8fd8\u539f<\/p>\n\n\n\n
gcrcman>recover table testdb.t1 0 1\n09.05 08:50:10 check Table topology start\n--------------------------------------------\n09.05 08:50:10 node (10.0.2.107) check table topology begin\n09.05 08:50:14 node (10.0.2.107) check table topology success\n--------------------------------------------\n09.05 08:50:14 check table topology success\n09.05 08:50:14 check Table BackUp start\n--------------------------------------------\n09.05 08:50:14 node (10.0.2.107) check table backup begin\n09.05 08:50:14 node (10.0.2.106) check table backup begin\n09.05 08:50:34 node (10.0.2.107) check table backup success\n09.05 08:50:34 node (10.0.2.106) check table backup success\n--------------------------------------------\n09.05 08:50:34 check table BackUp success\n09.05 08:50:34 refresh table testdb.t1 start\n09.05 08:50:34 node (10.0.2.107) recreate table begin\n09.05 08:50:38 node (10.0.2.107) recreate table success\n09.05 08:50:38 refresh table testdb.t1 end\n09.05 08:50:38 Recover table testdb.t1 start\n--------------------------------------------\n09.05 08:50:38 node (10.0.2.107) Recover table begin\n09.05 08:50:38 node (10.0.2.106) Recover table begin\n09.05 08:50:56 node (10.0.2.107) Recover table success\n09.05 08:50:56 node (10.0.2.106) Recover table success\n--------------------------------------------\n09.05 08:50:56 Recover table testdb.t1 success, please refresh it!\ngcrcman>\n<\/code><\/pre>\n\n\n\n \u9a8c\u8bc1<\/p>\n\n\n\n
gbase> refresh table t1;\nQuery OK, 0 rows affected (Elapsed: 00:00:00.01)\n\ngbase> select * from t1;\n+------+--------+---------------------+\n| id | value | birth |\n+------+--------+---------------------+\n| 1 | 234 | NULL |\n| 2 | 567 | NULL |\n| 3 | 888 | NULL |\n| 4 | 999 | NULL |\n| 5 | 555555 | 2020-01-03 00:00:00 |\n+------+--------+---------------------+\n5 rows in set (Elapsed: 00:00:00.01)\n<\/code><\/pre>\n\n\n\n<\/span>Summary<\/span><\/h2>\n\n\n\nGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u81ea\u5e26\u7684gcrcman\u5de5\u5177\u53ef\u4ee5\u5b9e\u73b0\u8868\u7ea7\u5907\u4efd\uff0c\u671f\u95f4\u4e0d\u5f71\u54cd\u6570\u636e\u5e93\u7684\u6574\u4f53\u72b6\u6001\uff0c\u4e0d\u9700\u8981\u5207\u6362\u5230readonly\uff0c\u539f\u5219\u4e0a\u5907\u4efd\u548c\u8fd8\u539f\u65f6\uff0c\u8be5\u8868\u662f\u88ab\u9501\u4f4f\u72ec\u5360\u72b6\u6001\u3002<\/p>","protected":false},"excerpt":{"rendered":"
\u672c\u6587\u4ecb\u7ecdGBase 8a\u6570\u636e\u5e93\u96c6\u7fa4\u81ea\u5e26\u7684\u5907\u4efd\u8fd8\u539f\u5de5\u5177gcrcman\u7684\u4f7f\u7528\uff0c\u5c1d\u8bd5\u5907\u4efd\u8fd8\u539f\u4e00\u4e2a\u8868\u3002<\/p>","protected":false},"author":1,"featured_media":1687,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1679","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-gbase8a"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=1679"}],"version-history":[{"count":25,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1679\/revisions"}],"predecessor-version":[{"id":11419,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/1679\/revisions\/11419"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media\/1687"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=1679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=1679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=1679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}