1.数据库增量备份配置

enable_cbm_tracking = on

2.初始化备份目录

[opgauss@ogsdb01 ~]$ gs_probackup init -B /opgauss/dbbackup/

INFO: Backup catalog '/opgauss/dbbackup' successfully inited

[opgauss@ogsdb01 ~]$  

3.添加数据库实例

[opgauss@ogsdb01 ~]$ gs_probackup add-instance -B /opgauss/dbbackup/ -D /opgauss/data --instance=gsdb01

INFO: Instance 'gsdb01' successfully inited

[opgauss@ogsdb01 ~]$

4.备份配置文件

[opgauss@ogsdb01 gsdb01]$ pwd

/opgauss/dbbackup/backups/gsdb01  

[opgauss@ogsdb01 gsdb01]$  

[opgauss@ogsdb01 gsdb01]$ more pg_probackup.conf  

# Backup instance information

pgdata = /opgauss/data

system-identifier = 3422977153384199

[opgauss@ogsdb01 gsdb01]$  

5.执行全备份

[opgauss@ogsdb01 ~]$ gs_probackup backup -d postgres -B /opgauss/dbbackup/ --instance=gsdb01 -b full -j 2  --compress –compress-level=9 –progress

INFO: Backup start, gs_probackup version: 2.4.2, instance: gsdb01, backup ID: R9VCRG, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: zlib, compress-level: 1

LOG: Backup destination is initialized

LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected

LOG: Database backup start

INFO: Cannot parse path "base"

INFO: PGDATA size: 619MB

LOG: started streaming WAL at 0/6000000 (timeline 1)

[2022-04-05 09:42:53]: check identify system success                                                

[2022-04-05 09:42:53]: send START_REPLICATION 0/6000000 success                                      

[2022-04-05 09:42:53]: keepalive message is received                                                

INFO: Start transferring data files

LOG: Creating page header map "/opgauss/dbbackup/backups/gsdb01/R9VCRG/page_header_map"

[2022-04-05 09:42:53]: keepalive message is received                                                

[2022-04-05 09:42:56]: keepalive message is received                                                

[2022-04-05 09:43:00]: keepalive message is received                                                

[2022-04-05 09:43:03]: keepalive message is received                                                

INFO: Data files are transferred, time elapsed: 12s

[2022-04-05 09:43:05]: keepalive message is received                                                

INFO: wait for pg_stop_backup()

INFO: pg_stop backup() successfully executed

LOG: stop_lsn: 0/60001E8

LOG: Looking for LSN 0/60001E8 in segment: 000000010000000000000006

INFO: Wait for LSN 0/60001E8 in streamed WAL segment /opgauss/dbbackup/backups/gsdb01/R9VCRG/database/pg_xlog/000000010000000000000006

LOG: Found WAL segment: /opgauss/dbbackup/backups/gsdb01/R9VCRG/database/pg_xlog/000000010000000000000006

LOG: Thread [0]: Opening WAL segment "/opgauss/dbbackup/backups/gsdb01/R9VCRG/database/pg_xlog/000000010000000000000006"

LOG: Found LSN: 0/60001E8

LOG: finished streaming WAL at 0/7000000 (timeline 1)

LOG: Getting the Recovery Time from WAL

LOG: Thread [0]: Opening WAL segment "/opgauss/dbbackup/backups/gsdb01/R9VCRG/database/pg_xlog/000000010000000000000006"

INFO: Syncing backup files to disk

INFO: Backup files are synced, time elapsed: 0

INFO: Validating backup R9VCRG

INFO: Backup R9VCRG data files are valid

INFO: Backup R9VCRG resident size: 608MB

INFO: Backup R9VCRG completed

[opgauss@ogsdb01 ~]$  

6.执行增量备份

[opgauss@ogsdb01 ~]$ gs_probackup backup -d postgres -B /opgauss/dbbackup/ --instance=gsdb01 -b ptrack -j 2  --compress –compress-level=9 –progress

INFO: Backup start, gs_probackup version: 2.4.2, instance: gsdb01, backup ID: R9VCW2, backup mode: PTRACK, wal mode: STREAM, remote: false, compress-algorithm: zlib, compress-level: 1

LOG: Backup destination is initialized

LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected

LOG: Database backup start

LOG: Latest valid FULL backup: R9VCRG

INFO: Parent backup: R9VCRG

INFO: Cannot parse path "base"

INFO: PGDATA size: 619MB

LOG: Current tli: 1

LOG: Parent start_lsn: 0/6000028

LOG: start_lsn: 0/8000028

INFO: Extracting pagemap of changed blocks

INFO: change bitmap start lsn location is 0/6000028

INFO: change bitmap end lsn location is 00000000/08000028

INFO: Pagemap successfully extracted, time elapsed: 0 sec

LOG: started streaming WAL at 0/8000000 (timeline 1)

[2022-04-05 09:45:38]: check identify system success                                                

[2022-04-05 09:45:38]: send START_REPLICATION 0/8000000 success                                      

[2022-04-05 09:45:38]: keepalive message is received                                                

INFO: Start transferring data files

LOG: Creating page header map "/opgauss/dbbackup/backups/gsdb01/R9VCW2/page_header_map"

[2022-04-05 09:45:39]: keepalive message is received                                                

[2022-04-05 09:45:42]: keepalive message is received                                                

INFO: Data files are transferred, time elapsed: 4s

INFO: wait for pg_stop_backup()

[2022-04-05 09:45:44]: keepalive message is received                                                

INFO: pg_stop backup() successfully executed

LOG: stop_lsn: 0/8000268

LOG: Looking for LSN 0/8000268 in segment: 000000010000000000000008

LOG: Found WAL segment: /opgauss/dbbackup/backups/gsdb01/R9VCW2/database/pg_xlog/000000010000000000000008

LOG: Thread [0]: Opening WAL segment "/opgauss/dbbackup/backups/gsdb01/R9VCW2/database/pg_xlog/000000010000000000000008"

LOG: Found LSN: 0/8000268

LOG: finished streaming WAL at 0/9000000 (timeline 1)

LOG: Getting the Recovery Time from WAL

LOG: Thread [0]: Opening WAL segment "/opgauss/dbbackup/backups/gsdb01/R9VCW2/database/pg_xlog/000000010000000000000008"

INFO: Syncing backup files to disk

INFO: Backup files are synced, time elapsed: 0

INFO: Validating backup R9VCW2

INFO: Backup R9VCW2 data files are valid

INFO: Backup R9VCW2 resident size: 273MB

INFO: Backup R9VCW2 completed

[opgauss@ogsdb01 ~]$  

7.检查备份信息

[opgauss@ogsdb01 ~]$ gs_probackup show -B /opgauss/dbbackup/ --instance=gsdb01  

=======================================================================================================================================

Instance  Version  ID      Recovery Time           Mode    WAL Mode  TLI     Time   Data   WAL  Zratio  Start LSN  Stop LSN   Status  

=======================================================================================================================================

gsdb01    9.2      R9VCW2  2022-04-05 09:45:42-04  PTRACK  STREAM    1/1      11s  257MB  16MB    1.00  0/8000028  0/8000268  OK      

gsdb01    9.2      R9VCRG  2022-04-05 09:43:05-04  FULL    STREAM    1/0      20s  592MB  16MB    1.05  0/6000028  0/60001E8  OK      

gsdb01    9.2      R9VCDM  ----                    FULL    STREAM    1/0  11m:45s  160kB     0    1.00  0/50000A8  0/0        RUNNING  

gsdb01    ----     R9VCDJ  ----                    FULL    STREAM    0/0        0      0     0    1.00  0/0        0/0        ERROR    

gsdb01    ----     R9VCBM  ----                    FULL    STREAM    0/0        0      0     0    1.00  0/0        0/0        ERROR    

[opgauss@ogsdb01 ~]$  

8.删除无效备份

8.1 删除ERROR备份

[opgauss@ogsdb01 ~]$ gs_probackup delete  -B /opgauss/dbbackup/ --instance=gsdb01 -i R9VCBM

LOG: Backups based on R9VCBM will be deleted

LOG: Backup R9VCBM will be deleted

INFO: Resident data size to free by delete of backup R9VCBM : 0

WARNING: Process 10421 which used backup R9VCBM no longer exists

INFO: Delete: R9VCBM 1969-12-31 19:00:00-05

[opgauss@ogsdb01 ~]$  

[opgauss@ogsdb01 ~]$ gs_probackup delete  -B /opgauss/dbbackup/ --instance=gsdb01 -i R9VCDJ

LOG: Backups based on R9VCDJ will be deleted

LOG: Backup R9VCDJ will be deleted

INFO: Resident data size to free by delete of backup R9VCDJ : 0

WARNING: Process 10460 which used backup R9VCDJ no longer exists

INFO: Delete: R9VCDJ 1969-12-31 19:00:00-05

[opgauss@ogsdb01 ~]$

8.2 删除RUNNING备份

8.2.1 尝试删除未成功

[opgauss@ogsdb01 ~]$ gs_probackup delete  -B /opgauss/dbbackup/ --instance=gsdb01 -i R9VCDM

LOG: Backups based on R9VCDM will be deleted

LOG: Backup R9VCDM will be deleted

INFO: Resident data size to free by delete of backup R9VCDM : 160kB

WARNING: Process 10462 is using backup R9VCDM and still is running

ERROR: Cannot lock backup R9VCDM directory

[opgauss@ogsdb01 ~]$  

[opgauss@ogsdb01 ~]$ gs_probackup show -B /opgauss/dbbackup/ --instance=gsdb01  

=======================================================================================================================================

Instance  Version  ID      Recovery Time           Mode    WAL Mode  TLI     Time   Data   WAL  Zratio  Start LSN  Stop LSN   Status  

=======================================================================================================================================

gsdb01    9.2      R9VCW2  2022-04-05 09:45:42-04  PTRACK  STREAM    1/1      11s  257MB  16MB    1.00  0/8000028  0/8000268  OK      

gsdb01    9.2      R9VCRG  2022-04-05 09:43:05-04  FULL    STREAM    1/0      20s  592MB  16MB    1.05  0/6000028  0/60001E8  OK      

gsdb01    9.2      R9VCDM  ----                    FULL    STREAM    1/0  17m:18s  160kB     0    1.00  0/50000A8  0/0        RUNNING  

[opgauss@ogsdb01 ~]$  

8.2.2 kill running备份的进程

[opgauss@ogsdb01 ~]$ ps ux|

[opgauss@ogsdb01 ~]$ kill -9 10462

-bash: kill: (10462) - No such process

[opgauss@ogsdb01 ~]$  

8.2.3 检查备份进程killed后备份状态

[opgauss@ogsdb01 ~]$ gs_probackup show -B /opgauss/dbbackup/ --instance=gsdb01  

=======================================================================================================================================

Instance  Version  ID      Recovery Time           Mode    WAL Mode  TLI     Time   Data   WAL  Zratio  Start LSN  Stop LSN   Status  

=======================================================================================================================================

gsdb01    9.2      R9VCW2  2022-04-05 09:45:42-04  PTRACK  STREAM    1/1      11s  257MB  16MB    1.00  0/8000028  0/8000268  OK      

gsdb01    9.2      R9VCRG  2022-04-05 09:43:05-04  FULL    STREAM    1/0      20s  592MB  16MB    1.05  0/6000028  0/60001E8  OK      

gsdb01    9.2      R9VCDM  ----                    FULL    STREAM    1/0  23m:18s  160kB     0    1.00  0/50000A8  0/0        RUNNING  

[opgauss@ogsdb01 ~]$

8.2.4 验证确认指定备份状态

[opgauss@ogsdb01 ~]$ gs_probackup validate  -B /opgauss/dbbackup/ --instance=gsdb01 -i R9VCDM

LOG: Validate begin.

WARNING: Backup R9VCDM has status: RUNNING

WARNING: Process 10462 which used backup R9VCDM no longer exists

WARNING: Backup R9VCDM has status RUNNING, change it to ERROR and skip validation

ERROR: Backup R9VCDM has status: ERROR

[opgauss@ogsdb01 ~]$  

8.2.5 检查验证后备份状态

[opgauss@ogsdb01 ~]$ gs_probackup show -B /opgauss/dbbackup/ --instance=gsdb01  

===================================================================================================================================

Instance  Version  ID      Recovery Time           Mode    WAL Mode  TLI  Time   Data   WAL  Zratio  Start LSN  Stop LSN   Status  

===================================================================================================================================

gsdb01    9.2      R9VCW2  2022-04-05 09:45:42-04  PTRACK  STREAM    1/1   11s  257MB  16MB    1.00  0/8000028  0/8000268  OK      

gsdb01    9.2      R9VCRG  2022-04-05 09:43:05-04  FULL    STREAM    1/0   20s  592MB  16MB    1.05  0/6000028  0/60001E8  OK      

gsdb01    9.2      R9VCDM  ----                    FULL    STREAM    1/0  ----  160kB     0    1.00  0/50000A8  0/0        ERROR  

[opgauss@ogsdb01 ~]$

8.2.6 清除异常备份

[opgauss@ogsdb01 ~]$ gs_probackup delete  -B /opgauss/dbbackup/ --instance=gsdb01 -i R9VCDM

LOG: Backups based on R9VCDM will be deleted

LOG: Backup R9VCDM will be deleted

INFO: Resident data size to free by delete of backup R9VCDM : 160kB

WARNING: Process 10845 which used backup R9VCDM no longer exists

INFO: Delete: R9VCDM 1969-12-31 19:00:00-05

[opgauss@ogsdb01 ~]$

8.2.7 检查备份状态

[opgauss@ogsdb01 ~]$ gs_probackup show -B /opgauss/dbbackup/ --instance=gsdb01  

===================================================================================================================================

Instance  Version  ID      Recovery Time           Mode    WAL Mode  TLI  Time   Data   WAL  Zratio  Start LSN  Stop LSN   Status  

===================================================================================================================================

gsdb01    9.2      R9VCW2  2022-04-05 09:45:42-04  PTRACK  STREAM    1/1   11s  257MB  16MB    1.00  0/8000028  0/8000268  OK      

gsdb01    9.2      R9VCRG  2022-04-05 09:43:05-04  FULL    STREAM    1/0   20s  592MB  16MB    1.05  0/6000028  0/60001E8  OK      

[opgauss@ogsdb01 ~]$