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 ~]$