暂无图片
暂无图片
暂无图片
暂无图片
暂无图片
首页 / GaussDB T备份工具Roach备份恢复数据库(分布式集群)示例

GaussDB T备份工具Roach备份恢复数据库(分布式集群)示例

原创 muggle 2020-01-20
1412
Gaussdb数据库可以通过备份工具GaussRoach直接在服务器上备份数据库，以下内容为在分布式集群的备份管理及恢复示例。

1.全备、增量备份、备份集查询，备份集验证

1)备份目录准备

[root@gaussdb1 ~]# mkdir -p /gaussdb/backup/media
[root@gaussdb1 ~]# mkdir -p /gaussdb/backup/metadata
[root@gaussdb1 ~]# chown omm:dbgrp /gaussdb/backup
[omm@gaussdb1 zroach]$cd /gaussdb/app/zroach

2) GaussRoach命令帮助

[omm@gaussdb1 zroach]$  python $ROACH_HOME/GaussRoach.py -h

3)全备(集群)

a) 备份前创建test_full表

[omm@gaussdb1 zroach]$ zsql / as sysdba -D /gaussdb/data/dn1/

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL>  create table test_full (id number,name varchar(40));

Succeed.

SQL> insert into test_full values(1,'abc');

1 rows affected.

SQL> commit;

Succeed.

SQL>  select * from test_full;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

b)(全备)

python GaussRoach.py  --mode cluster  -t backup --master-port 4444 --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type Disk  --validation-type sha256

[omm@gaussdb1 zroach]$ python GaussRoach.py  --mode cluster  -t backup --master-port 4444 --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type Disk  --validation-type sha256
gaussdb4 : ##################################################100%  0.054M/s
gaussdb3 : ##################################################100%  0.782M/s
gaussdb2 : ##################################################100%  0.054M/s
gaussdb1 : ##################################################100%  0.781M/s

Successfully backup data, backup key: 20200120_135739, takes time: 00:00:46.
Performing backup completed.

4)增量备份

a)查询备份集

python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata

[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata
start run show.
Parsing the configuration file.

|  BACKUP KEY   |BKP TYPE|MEDIA |    START TIME     |     END TIME      |  BKP SIZE  |  STATUS   |
|===============|========|======|===================|===================|============|===========|
|20200120_135739|  FULL  | DISK |2020-01-20 13:57:39|2020-01-20 13:58:21|     0      |  SUCCESS  |

Performing show completed.

b)创建test_inc表

[omm@gaussdb1 zroach]$ zsql / as sysdba -D /gaussdb/data/dn1/

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL>  create table test_inc (id number,name varchar(40));

Succeed.

SQL> insert into test_inc values(1,'abc');

1 rows affected.

SQL> commit;

Succeed.

SQL>  select * from test_inc;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

c)增量备份

python GaussRoach.py  --mode cluster  -t backup --master-port 4444 --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type Disk --prior-backup-key 20200120_110749 --validation-type sha256

[omm@gaussdb1 zroach]$ python GaussRoach.py  --mode cluster  -t backup --master-port 4444 --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type Disk --prior-backup-key 20200120_110749 --validation-type sha256
start run backup.
Parsing the configuration file.
Performing presetup activities...
gaussdb4 : ##################################################100%  0.005M/s
gaussdb3 : ##################################################100%  0.005M/s
gaussdb2 : ##################################################100%  0.007M/s
gaussdb1 : ##################################################100%  0.002M/s

Successfully backup data, backup key: 20200120_135953, takes time: 00:00:46.
Performing backup completed.

d)查询备份集


python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata

[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata
start run show.
Parsing the configuration file.

|  BACKUP KEY   |BKP TYPE|MEDIA |    START TIME     |     END TIME      |  BKP SIZE  |  STATUS   |
|===============|========|======|===================|===================|============|===========|
|20200120_135739|  FULL  | DISK |2020-01-20 13:57:39|2020-01-20 13:58:21|     0      |  SUCCESS  |
|20200120_135953|  INCR  | DISK |2020-01-20 13:59:53|2020-01-20 14:00:29|     0      |  SUCCESS  |

Performing show completed.

e)从服务器查看备份集

备份集分别存储于集群的每个节点的备份目录

节点二（示例）

[root@gaussdb2 backup]# tree
.
├── media
│   └── roach
│       ├── 20200120_085950
│       │   └── cn_402
│       │       ├── cfg
│       │       │   ├── zengine.ini
│       │       │   ├── zengine.ini_bak
│       │       │   └── zhba.conf
│       │       ├── data
│       │       │   ├── arch_5_0.bak
│       │       │   ├── backupset
│       │       │   ├── ctrl_0_0.bak
│       │       │   ├── data_SYSAUX_12_0.bak
│       │       │   ├── data_SYSTEM_0_0.bak
│       │       │   ├── data_TEMP_1_0.bak
│       │       │   ├── data_TEMP2_9_0.bak
│       │       │   ├── data_TEMP2_UNDO_11_0.bak
│       │       │   ├── data_UNDO_3_0.bak
│       │       │   ├── data_UNDO_3_1.bak
│       │       │   └── data_USERS_4_0.bak
│       │       └── path
│       │           └── path.rcd
│       ├── 20200120_090607
│       │   └── cn_402
│       │       ├── cfg
│       │       │   ├── zengine.ini
│       │       │   ├── zengine.ini_bak
│       │       │   └── zhba.conf
│       │       ├── data
│       │       │   ├── arch_6_0.bak
│       │       │   ├── backupset
│       │       │   ├── ctrl_0_0.bak
│       │       │   ├── data_SYSAUX_12_0.bak
│       │       │   ├── data_SYSTEM_0_0.bak
│       │       │   ├── data_TEMP_1_0.bak
│       │       │   ├── data_TEMP2_9_0.bak
│       │       │   ├── data_TEMP2_UNDO_11_0.bak
│       │       │   ├── data_UNDO_3_0.bak
│       │       │   ├── data_UNDO_3_1.bak
│       │       │   └── data_USERS_4_0.bak
│       │       └── path
│       │           └── path.rcd
│       ├── 20200120_091318
│       │   └── cn_402
│       │       ├── cfg
│       │       │   ├── zengine.ini
│       │       │   ├── zengine.ini_bak
│       │       │   └── zhba.conf
│       │       ├── data
│       │       │   ├── arch_7_0.bak
│       │       │   ├── backupset
│       │       │   ├── ctrl_0_0.bak
│       │       │   ├── data_SYSAUX_12_0.bak
│       │       │   ├── data_SYSTEM_0_0.bak
│       │       │   ├── data_TEMP_1_0.bak
│       │       │   ├── data_TEMP2_9_0.bak
│       │       │   ├── data_TEMP2_UNDO_11_0.bak
│       │       │   ├── data_UNDO_3_0.bak
│       │       │   ├── data_UNDO_3_1.bak
│       │       │   └── data_USERS_4_0.bak
│       │       └── path
│       │           └── path.rcd
│       ├── 20200120_101322
│       │   ├── cn_402
│       │   │   ├── cfg
│       │   │   │   ├── zengine.ini
│       │   │   │   ├── zengine.ini_bak
│       │   │   │   └── zhba.conf
│       │   │   ├── data
│       │   │   │   ├── arch_8_0.bak
│       │   │   │   ├── backupset
│       │   │   │   ├── ctrl_0_0.bak
│       │   │   │   ├── data_SYSAUX_12_0.bak
│       │   │   │   ├── data_SYSTEM_0_0.bak
│       │   │   │   ├── data_TEMP_1_0.bak
│       │   │   │   ├── data_TEMP2_9_0.bak
│       │   │   │   ├── data_TEMP2_UNDO_11_0.bak
│       │   │   │   ├── data_UNDO_3_0.bak
│       │   │   │   ├── data_UNDO_3_1.bak
│       │   │   │   └── data_USERS_4_0.bak
│       │   │   └── path
│       │   │       └── path.rcd
│       │   └── cn_402.sha256
│       ├── 20200120_101440
│       │   ├── cn_402
│       │   │   ├── cfg
│       │   │   │   ├── zengine.ini
│       │   │   │   ├── zengine.ini_bak
│       │   │   │   └── zhba.conf
│       │   │   ├── data
│       │   │   │   ├── arch_9_0.bak
│       │   │   │   ├── backupset
│       │   │   │   ├── ctrl_0_0.bak
│       │   │   │   ├── data_SYSAUX_12_0.bak
│       │   │   │   ├── data_SYSTEM_0_0.bak
│       │   │   │   ├── data_TEMP_1_0.bak
│       │   │   │   ├── data_TEMP2_9_0.bak
│       │   │   │   ├── data_TEMP2_UNDO_11_0.bak
│       │   │   │   ├── data_UNDO_3_0.bak
│       │   │   │   ├── data_UNDO_3_1.bak
│       │   │   │   └── data_USERS_4_0.bak
│       │   │   └── path
│       │   │       └── path.rcd
│       │   ├── cn_402.sha256
│       │   └── DB1_1
│       │       ├── cfg
│       │       │   ├── zengine.ini
│       │       │   ├── zengine.ini_bak
│       │       │   └── zhba.conf
│       │       ├── data
│       │       │   ├── arch_10_0.bak
│       │       │   ├── backupset
│       │       │   ├── ctrl_0_0.bak
│       │       │   ├── data_SYSAUX_12_0.bak
│       │       │   ├── data_SYSTEM_0_0.bak
│       │       │   ├── data_TEMP_1_0.bak
│       │       │   ├── data_TEMP2_9_0.bak
│       │       │   ├── data_TEMP2_UNDO_11_0.bak
│       │       │   ├── data_UNDO_3_0.bak
│       │       │   ├── data_UNDO_3_1.bak
│       │       │   └── data_USERS_4_0.bak
│       │       └── path
│       │           └── path.rcd
│       ├── 20200120_135739
│       │   ├── cn_402
│       │   │   ├── cfg
│       │   │   │   ├── zengine.ini
│       │   │   │   ├── zengine.ini_bak
│       │   │   │   └── zhba.conf
│       │   │   ├── data
│       │   │   │   ├── arch_12_0.bak
│       │   │   │   ├── backupset
│       │   │   │   ├── ctrl_0_0.bak
│       │   │   │   ├── data_SYSAUX_12_0.bak
│       │   │   │   ├── data_SYSTEM_0_0.bak
│       │   │   │   ├── data_TEMP_1_0.bak
│       │   │   │   ├── data_TEMP2_9_0.bak
│       │   │   │   ├── data_TEMP2_UNDO_11_0.bak
│       │   │   │   ├── data_UNDO_3_0.bak
│       │   │   │   ├── data_UNDO_3_1.bak
│       │   │   │   └── data_USERS_4_0.bak
│       │   │   └── path
│       │   │       └── path.rcd
│       │   ├── cn_402.sha256
│       │   └── DB1_1
│       │       ├── cfg
│       │       │   ├── zengine.ini
│       │       │   ├── zengine.ini_bak
│       │       │   └── zhba.conf
│       │       ├── data
│       │       │   ├── arch_13_0.bak
│       │       │   ├── backupset
│       │       │   ├── ctrl_0_0.bak
│       │       │   ├── data_SYSAUX_12_0.bak
│       │       │   ├── data_SYSTEM_0_0.bak
│       │       │   ├── data_TEMP_1_0.bak
│       │       │   ├── data_TEMP2_9_0.bak
│       │       │   ├── data_TEMP2_UNDO_11_0.bak
│       │       │   ├── data_UNDO_3_0.bak
│       │       │   ├── data_UNDO_3_1.bak
│       │       │   └── data_USERS_4_0.bak
│       │       └── path
│       │           └── path.rcd
│       └── 20200120_135953
│           ├── cn_402
│           │   ├── cfg
│           │   │   ├── zengine.ini
│           │   │   ├── zengine.ini_bak
│           │   │   └── zhba.conf
│           │   ├── data
│           │   │   ├── arch_13_0.bak
│           │   │   ├── backupset
│           │   │   ├── ctrl_0_0.bak
│           │   │   ├── data_SYSAUX_12_0.bak
│           │   │   ├── data_SYSTEM_0_0.bak
│           │   │   ├── data_TEMP_1_0.bak
│           │   │   ├── data_TEMP2_9_0.bak
│           │   │   ├── data_TEMP2_UNDO_11_0.bak
│           │   │   ├── data_UNDO_3_0.bak
│           │   │   ├── data_UNDO_3_1.bak
│           │   │   └── data_USERS_4_0.bak
│           │   └── path
│           │       └── path.rcd
│           ├── cn_402.sha256
│           └── DB1_1
│               ├── cfg
│               │   ├── zengine.ini
│               │   ├── zengine.ini_bak
│               │   └── zhba.conf
│               ├── data
│               │   ├── arch_14_0.bak
│               │   ├── backupset
│               │   ├── ctrl_0_0.bak
│               │   ├── data_SYSAUX_12_0.bak
│               │   ├── data_SYSTEM_0_0.bak
│               │   ├── data_TEMP_1_0.bak
│               │   ├── data_TEMP2_9_0.bak
│               │   ├── data_TEMP2_UNDO_11_0.bak
│               │   ├── data_UNDO_3_0.bak
│               │   ├── data_UNDO_3_1.bak
│               │   └── data_USERS_4_0.bak
│               └── path
│                   └── path.rcd
└── metadata
    ├── backupset_disk.ini
    └── roach
        ├── 20200120_135739
        │   └── roach_agent.json
        └── 20200120_135953
            └── roach_agent.json

5)验证备份集


[omm@gaussdb1 zroach]$ python GaussRoach.py -t validate --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type disk --validation-type sha256 --backup-key 20200120_135739
start run validate.
Parsing the configuration file.
start validate backup data.
Successfully validate backup data.
Performing validate completed.

[omm@gaussdb1 zroach]$ python GaussRoach.py -t validate --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media --media-type disk --validation-type sha256 --backup-key 20200120_135953
start run validate.
Parsing the configuration file.
start validate backup data.
Successfully validate backup data.
Performing validate completed.

2.恢复测试

1）(恢复全备)

a) 在增量备份后创建表

[omm@gaussdb1 zroach]$ zsql / as sysdba -D /gaussdb/data/dn1/

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL> create table test (id number,name varchar(40));

Succeed.

SQL> insert into test values(1,'abc');

1 rows affected.

SQL> commit;

Succeed.

SQL>  select * from test;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

SQL>

b)全备恢复


python GaussRoach.py --mode cluster -t restore --master-port 4444 --backup-key 20200120_135739 --validation-type sha256 --clean --metadata-destination /gaussdb/backup/metadata/ --media-destination /gaussdb/backup/media/

[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t restore --master-port 4444 --backup-key 20200120_135739 --validation-type sha256 --clean --metadata-destination /gaussdb/backup/metadata/ --media-destination /gaussdb/backup/media/
start run restore.
Parsing the configuration file.
Cleaning cluster.
Stopping cluster.
Successfully stopped cluster.
Successfully cleaned cluster.
Performing presetup activities...
gaussdb4 : ##################################################100%  0.031M/s
gaussdb3 : ##################################################100%  0.031M/s
gaussdb2 : ##################################################100%  0.037M/s
gaussdb1 : ##################################################100%  0.052M/s
Successfully restore data,  takes time: 00:17:35.
Performing restore completed.s...

c)启动集群



[omm@gaussdb1 zroach]$ python GaussRoach.py -t start
start run start.
Parsing the configuration file.
Starting the cluster.
Successfully started all instance.
..............................
.
======================================================================
Successfully started the cluster.
Performing start completed.
[omm@gaussdb1 zroach]$

d)检查集群状态

[omm@gaussdb1 ~]$ gs_om -t status
Set output to terminal.
--------------------------------------------------------------------Cluster Status--------------------------------------------------------------------
az_state :      single_az
cluster_state : Normal
balanced :      true
----------------------------------------------------------------------AZ Status-----------------------------------------------------------------------
AZ:AZ1                ROLE:primary            STATUS:ONLINE      
---------------------------------------------------------------------Host Status----------------------------------------------------------------------
HOST:gaussdb1         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.22
HOST:gaussdb2         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.23
HOST:gaussdb3         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.24
HOST:gaussdb4         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.25
----------------------------------------------------------------Cluster Manager Status----------------------------------------------------------------
INSTANCE:CM1          ROLE:primary            STATUS:ONLINE       HOST:gaussdb1         ID:601
INSTANCE:CM2          ROLE:slave              STATUS:ONLINE       HOST:gaussdb2         ID:602
---------------------------------------------------------------------ETCD Status----------------------------------------------------------------------
INSTANCE:ETCD1        ROLE:leader             STATUS:ONLINE       HOST:gaussdb1         ID:701      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
INSTANCE:ETCD2        ROLE:follower           STATUS:ONLINE       HOST:gaussdb2         ID:702      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
INSTANCE:ETCD3        ROLE:follower           STATUS:ONLINE       HOST:gaussdb3         ID:703      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
----------------------------------------------------------------------CN Status-----------------------------------------------------------------------
INSTANCE:cn_401       ROLE:no role            STATUS:ONLINE       HOST:gaussdb1         ID:401      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_402       ROLE:no role            STATUS:ONLINE       HOST:gaussdb2         ID:402      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_403       ROLE:no role            STATUS:ONLINE       HOST:gaussdb3         ID:403      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_404       ROLE:no role            STATUS:ONLINE       HOST:gaussdb4         ID:404      PORT:8000         DataDir:/gaussdb/data/cn
---------------------------------------------------------Instances Status in Group (group_1)----------------------------------------------------------
INSTANCE:DB1_1        ROLE:primary            STATUS:ONLINE       HOST:gaussdb1         ID:1        PORT:4000         DataDir:/gaussdb/data/dn1
INSTANCE:DB1_2        ROLE:standby            STATUS:ONLINE       HOST:gaussdb2         ID:2        PORT:4000         DataDir:/gaussdb/data/dn1
---------------------------------------------------------Instances Status in Group (group_2)----------------------------------------------------------
INSTANCE:DB2_3        ROLE:primary            STATUS:ONLINE       HOST:gaussdb3         ID:3        PORT:4000         DataDir:/gaussdb/data/dn3
INSTANCE:DB2_4        ROLE:standby            STATUS:ONLINE       HOST:gaussdb4         ID:4        PORT:4000         DataDir:/gaussdb/data/dn3
-----------------------------------------------------------------------Manage IP----------------------------------------------------------------------
HOST:gaussdb1         IP:10.111.76.22
HOST:gaussdb2         IP:10.111.76.23
HOST:gaussdb3         IP:10.111.76.24
HOST:gaussdb4         IP:10.111.76.25
-------------------------------------------------------------------Query Action Info------------------------------------------------------------------
HOSTNAME: gaussdb1     TIME: 2020-01-20 14:35:53.163805
------------------------------------------------------------------------Float Ip------------------------------------------------------------------
HOST:gaussdb3    DB2_3:10.111.76.24    IP:
HOST:gaussdb1    DB1_1:10.111.76.22    IP:
[omm@gaussdb1 ~]$

e)验证相关表数据恢复情况

[omm@gaussdb1 ~]$ zsql / as sysdba -D /gaussdb/data/dn1

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL> select * from test_full;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

SQL> select * from test_inc;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

SQL> select * from test;

GS-00843, [1:15]The table or view SYS.TEST does not exist.
SQL>

验证结果：恢复全备，会自动完成全备+增量备份的数据备份恢复工作。

7)增量备份恢复

a)增量恢复(删除增量备份包含的表并进行增量恢复)

SQL> drop table test_inc purge;

python GaussRoach.py --mode cluster -t restore --master-port 4444 --backup-key 20200120_135953 --validation-type sha256 --clean --metadata-destination /gaussdb/backup/metadata/ --media-destination /gaussdb/backup/media/


[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t restore --master-port 4444 --backup-key 20200120_135953 --validation-type sha256 --clean --metadata-destination /gaussdb/backup/metadata/ --media-destination /gaussdb/backup/media/
start run restore.
Parsing the configuration file.
Cleaning cluster.
Stopping cluster.
Successfully stopped cluster.
Successfully cleaned cluster.
Performing presetup activities...
gaussdb4 : ##################################################100%  0.0M/s
gaussdb3 : ##################################################100%  0.0M/s
gaussdb2 : ##################################################100%  0.0M/s
gaussdb1 : ##################################################100%  0.001M/s
Successfully restore data,  takes time: 00:17:23.
Performing restore completed.

b)启动集群

python GaussRoach.py -t start


[omm@gaussdb1 zroach]$ python GaussRoach.py -t start
start run start.
Parsing the configuration file.
Starting the cluster.
Successfully started all instance.
..............................
.
======================================================================
Successfully started the cluster.
Performing start completed.
[omm@gaussdb1 zroach]$

c)检查集群状态

[omm@gaussdb1 ~]$ gs_om -t status
Set output to terminal.
--------------------------------------------------------------------Cluster Status--------------------------------------------------------------------
az_state :      single_az
cluster_state : Normal
balanced :      true
----------------------------------------------------------------------AZ Status-----------------------------------------------------------------------
AZ:AZ1                ROLE:primary            STATUS:ONLINE      
---------------------------------------------------------------------Host Status----------------------------------------------------------------------
HOST:gaussdb1         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.22
HOST:gaussdb2         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.23
HOST:gaussdb3         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.24
HOST:gaussdb4         AZ:AZ1                  STATUS:ONLINE       IP:10.111.76.25
----------------------------------------------------------------Cluster Manager Status----------------------------------------------------------------
INSTANCE:CM1          ROLE:slave              STATUS:ONLINE       HOST:gaussdb1         ID:601
INSTANCE:CM2          ROLE:primary            STATUS:ONLINE       HOST:gaussdb2         ID:602
---------------------------------------------------------------------ETCD Status----------------------------------------------------------------------
INSTANCE:ETCD1        ROLE:follower           STATUS:ONLINE       HOST:gaussdb1         ID:701      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
INSTANCE:ETCD2        ROLE:leader             STATUS:ONLINE       HOST:gaussdb2         ID:702      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
INSTANCE:ETCD3        ROLE:follower           STATUS:ONLINE       HOST:gaussdb3         ID:703      PORT:2379         DataDir:/gaussdb/data/etcd/data_etcd1
----------------------------------------------------------------------CN Status-----------------------------------------------------------------------
INSTANCE:cn_401       ROLE:no role            STATUS:ONLINE       HOST:gaussdb1         ID:401      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_402       ROLE:no role            STATUS:ONLINE       HOST:gaussdb2         ID:402      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_403       ROLE:no role            STATUS:ONLINE       HOST:gaussdb3         ID:403      PORT:8000         DataDir:/gaussdb/data/cn
INSTANCE:cn_404       ROLE:no role            STATUS:ONLINE       HOST:gaussdb4         ID:404      PORT:8000         DataDir:/gaussdb/data/cn
---------------------------------------------------------Instances Status in Group (group_1)----------------------------------------------------------
INSTANCE:DB1_1        ROLE:primary            STATUS:ONLINE       HOST:gaussdb1         ID:1        PORT:4000         DataDir:/gaussdb/data/dn1
INSTANCE:DB1_2        ROLE:standby            STATUS:ONLINE       HOST:gaussdb2         ID:2        PORT:4000         DataDir:/gaussdb/data/dn1
---------------------------------------------------------Instances Status in Group (group_2)----------------------------------------------------------
INSTANCE:DB2_3        ROLE:primary            STATUS:ONLINE       HOST:gaussdb3         ID:3        PORT:4000         DataDir:/gaussdb/data/dn3
INSTANCE:DB2_4        ROLE:standby            STATUS:ONLINE       HOST:gaussdb4         ID:4        PORT:4000         DataDir:/gaussdb/data/dn3
-----------------------------------------------------------------------Manage IP----------------------------------------------------------------------
HOST:gaussdb1         IP:10.111.76.22
HOST:gaussdb2         IP:10.111.76.23
HOST:gaussdb3         IP:10.111.76.24
HOST:gaussdb4         IP:10.111.76.25
-------------------------------------------------------------------Query Action Info------------------------------------------------------------------
HOSTNAME: gaussdb1     TIME: 2020-01-20 13:45:27.126974
------------------------------------------------------------------------Float Ip------------------------------------------------------------------
HOST:gaussdb3    DB2_3:10.111.76.24    IP:
HOST:gaussdb1    DB1_1:10.111.76.22    IP:
[omm@gaussdb1 ~]$

d)验证表数据查看。


[omm@gaussdb1 ~]$ zsql / as sysdba -D /gaussdb/data/dn1 -q

Warning: SSL connection to server without CA certificate is insecure. Continue anyway? (y/n):y
connected.


SQL> select * from test_full;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

SQL> select * from test_inc;

ID                                       NAME                                    
---------------------------------------- ----------------------------------------
1                                        abc                                     

1 rows fetched.

SQL> select * from test;

GS-00843, [1:15]The table or view SYS.TEST does not exist.
SQL>

注：增量备份恢复完成后，创建的test_inc表可正常访问了。

8.删除备份集

python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata
python GaussRoach.py --mode cluster -t delete  --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media  --backup-key 20200120_135739 --cascade

[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t show --all-backups --metadata-destination=/gaussdb/backup/metadata
start run show.
Parsing the configuration file.

|  BACKUP KEY   |BKP TYPE|MEDIA |    START TIME     |     END TIME      |  BKP SIZE  |  STATUS   |
|===============|========|======|===================|===================|============|===========|
|20200120_135739|  FULL  | DISK |2020-01-20 13:57:39|2020-01-20 13:58:21|     0      |  SUCCESS  |
|20200120_135953|  INCR  | DISK |2020-01-20 13:59:53|2020-01-20 14:00:29|     0      |  SUCCESS  |

Performing show completed.

[omm@gaussdb1 zroach]$ python GaussRoach.py --mode cluster -t delete  --metadata-destination /gaussdb/backup/metadata --media-destination /gaussdb/backup/media  --backup-key 20200120_135739 --cascade
start run delete.
Parsing the configuration file.
start delete backup data.

Deleting backup-key: 20200120_135953    [1/2]

Deleting backup-key: 20200120_135739    [2/2]
Successfully delete backup data.
Performing delete completed.
gaussdb t
最后修改时间：2020-01-21 10:56:56
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。

文章被以下合辑收录

Muggle's DBALife（共18篇）
Muggle's DBALife,DBA生活每一天！
云和恩墨GaussDB团队（共40篇）
云和恩墨GaussDB团队，发表华为高斯数据库相关的技术文章以及最新资讯，包含GaussDB 100 和GaussDB 200。

评论