MogDB数据库从零到上生产：3、MogDB数据库BRM定时备份

BRM备份恢复工具的全称为：Backup and Recovery Manager。它主要设计目的是为了应对MogDB数据库集中式备份和恢复管理工作，同时提供CLI命令行工具和Web图形管理界面。

MogDB安装环境

安装环境及系统

操作系统：CentOS 7.6
内存：16G
交换空间：8G（大内存建议关闭）
硬盘：500G
网络：可访问外网（用于下载MogDB及相关软件安装包）

备节点安装BRM

1、创建brm目录

[root@mogdb2 ~]# mkdir -p /opt/brm/

2、把压缩包上传到/opt/brm目录下

3、解压压缩包

[root@mogdb2 brm]# unzip brm_0.0.10_linux_amd64.zip 
Archive:  brm_0.0.10_linux_amd64.zip
  inflating: LICENSE                 
  inflating: README.md               
  inflating: brm.1                   
  inflating: completions/brm.bash    
  inflating: completions/brm.fish    
  inflating: completions/brm.zsh     
  inflating: conf/brm.yaml           
  inflating: brm 

[root@mogdb2 brm]# chown -R omm. brm

4、配置brm初始化参数文件

omm在/home/omm/下创建目录.brm并将配置文件复制到/home/omm/.brm目录下

[omm@mogdb2 ~]$ mkdir -p /home/omm/.brm

[omm@mogdb2 ~]$ cp /opt/brm/conf/brm.yaml /home/omm/.brm/

修改配置文件brm.yaml，指定备份文件存放的路径和日志存放路径，所写路径需要omm用户具有创建目录权限。

备份文件存放路径：[root@mogdb2 brm]# mkdir -p /mogdb_brm_bak/data

备份日志存放路径：[root@mogdb2 brm]# mkdir -p /mogdb_brm_bak/log

[root@mogdb2 brm]# chmod -R 755 /mogdb_brm_bak

[root@mogdb2 brm]# chown -R omm.  /mogdb_brm_bak

[omm@mogdb2 ~]$ cat /home/omm/.brm/brm.yaml 

# 没有启用
backup_user: omm
# 备份文件存放目录
backup_home: /mogdb_brm_bak/data
# 日志目录
log_file: /mogdb_brm_bak/log
# 日志级别
log_level: DEBUG
# 没有启用
lock_directory: /var/lib/run
# wal全局备份几次 default 1
wal_retention_redundancy: 1
# 是否允许主库进行备份. default:false
no_allow_primary_backup: false
network_limit_rate: 10m
# default on
enable_backup_wal_file_check: on
## 启动备份文件中心同步
#enable_backup_push: on
## 当前Brm节点名称，当enable_backup_center_push为on时此项为必填
#brm_node_name: 127.0.0.1:5434
## brm 备份文件集中存储配置
#backup_center:
#  - host: 127.0.0.1
#    port: 44332
#  - host: 127.0.0.1
#    port: 44333

5、验证brm工具命令是否可以使用

查看当前工具版本。

[omm@mogdb2 ~]$ /opt/brm/brm version
time="2021-12-24 15:29:35.582999" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
Release version: 0.0.10
Git Commit hash: 5e96dcf
Git Tag        : v0.0.10
Build timestamp: 2021-06-15T03:31:55ZZ

BRM备份

1、 帮助使用：使用-h 在任何命令后直接获取帮助

[omm@mogdb2 ~]$ /opt/brm/brm -h
Backup and Recovery Manager.

Usage:
  brm [command]

Available Commands:
  add-server         add backup instance server
  backup             perform backup for the instance server
  backup-wal         perform backup wal for the instance server
  check              check backup instance server
  del-server         delete backup instance server
  delete             delete backup for the instance server
  gen                A collection of several useful generators
  help               Help about any command
  list-server        list backup instance server.
  receive-wal        receive wal for the instance server
  restore            restore a server at a given time, name, LSN or xid
  set-server         set backup instance server
  show-backup        list available backups for the instance server
  show-wal           list available WAL backups for the instance server
  switch-wal         execute the switch-wal command on the instance server
  sync               sync backup and wal file to the data center
  version            print version

Flags:
  -c, --config string   config file (default is /etc/brm/brm.yaml,/etc/brm.yaml,$HOME/.brm/brm.yaml)
      --debug string    debug
  -h, --help            help for brm
  -t, --toggle          Help message for toggle

Use "brm [command] --help" for more information about a command.


[omm@mogdb2 ~]$ /opt/brm/brm add-server -h
add backup instance server.

Usage:
  brm add-server [flags]

Aliases:
  add-server, add-instance

Examples:

  # add opengauss instance
  brm add-instance -i testdb -D /var/lib/opengauss/data
  # add opengauss instance with database name and port
  brm add-instance -i testdb -D /var/lib/opengauss/data -d postgres -p 26000

Flags:
  -i, --instance string                name of the new backup instance server
  -D, --pgdata string                  location of the database storage area
  -d, --pgdatabase string              the openGauss database name (default "postgres")
      --pghost string                  database server host or socket directory (default "localhost")
  -p, --pgport int                     the openGauss database port
  -U, --pguser string                  the openGauss database user (default:current user)
  -E, --external-dirs string           backup some directories not from pgdata
                                       (example: --external-dirs=/tmp/dir1:/tmp/dir2) (default "none")
      --retention-redundancy int       number of full backups to keep; 0 disables; (default -1)
      --retention-window int           number of days of recoverability; 0 disables; (default -1)
      --compress-algorithm string      available options: 'zlib', 'pglz', 'none' (default: none)
      --compress-level int             level of compression [0-9] (default -1)
      --archive-timeout string         wait timeout for WAL segment archiving (default "5min")
  -n, --node-name string               node name of backup instance server
      --archive-dir string             archive directory of backup instance server
      --no-archive-dir                 close archive directory of backup instance server
      --streaming-archiver string      choice on,off.set openGauss database WAL streaming settings
      --slot-name string               slot name (default "brm")
      --auto-create-slot string        set auto create slot (default "true")
      --wal-retention-redundancy int   wal-retention-redundancy (default -1)
      --primary-host string            primary host
      --primary-host-user string       primary host user. default: current user
      --primary-host-password string   primary host password
      --primary-host-prv-file string   primary host ssh key file. default:$HOME/.ssh/id_rsa
      --network-limit-rate string      network limit rate
  -h, --help                           help for add-server

Global Flags:
  -c, --config string   config file (default is /etc/brm/brm.yaml,/etc/brm.yaml,$HOME/.brm/brm.yaml)
      --debug string    debug

2、备份测试

 添加备份实例:

[omm@mogdb2 ~]$ /opt/brm/brm add-server --instance=mogdbha --pgdata=/mogdb/data/db1 --pgdatabase=postgres --pgport=26000 --retention-redundancy=1 --retention-window=7 --archive-dir=/ogarchive


 查看备份实例配置：

[omm@mogdb2 ~]$ /opt/brm/brm list-server --instance=mogdbha  –format=json
time="2021-12-24 16:35:40.807567" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
time="2021-12-24 16:35:40.807999" level=info msg="the gs_probackup path /opt/mogdb/app/bin/gs_probackup"
time="2021-12-24 16:35:40.820118" level=info msg="the gs_probackup version 2.0.1"
time="2021-12-24 16:35:40.820168" level=info msg="the gs_ctl path /opt/mogdb/app/bin/gs_ctl"
time="2021-12-24 16:35:40.830979" level=info msg="gs_ctl version 9.2.4 "
[
  {
    "name": "mogdbha",
    "pg_data": "/mogdb/data/db1",
    "system_identifier": "18020659542178473280",
    "pgDatabase": "postgres",
    "pgPort": 26000,
    "retention_redundancy": 1,
    "retention_window": 7,
    "unixSocket": "/opt/mogdb/tools/omm_mppdb",
    "openGaussVersion": "2.0.1",
    "xLogSegSize": 16777216,
    "brmServerWalConfig": {
      "nodeName": "",
      "archiveDir": "/ogarchive",
      "archiveWal": false,
      "streamingArchiver": false,
      "streamingArchiverName": "brm_receive_wal",
      "slotName": "brm",
      "autoCreateSlot": true,
      "streamingArchiverBatchSize": 50,
      "walRetentionRedundancy": 1
    }
  }
]


 检查备份配置:

[omm@mogdb2 ~]$ /opt/brm/brm check --instance=mogdbha
time="2021-12-24 16:17:56.331023" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
time="2021-12-24 16:17:56.331369" level=info msg="the gs_probackup path /opt/mogdb/app/bin/gs_probackup"
time="2021-12-24 16:17:56.343746" level=info msg="the gs_probackup version 2.0.1"
time="2021-12-24 16:17:56.343793" level=info msg="the gs_ctl path /opt/mogdb/app/bin/gs_ctl"
time="2021-12-24 16:17:56.354358" level=info msg="gs_ctl version 9.2.4 "
                                           openGauss connect: OK
                                           openGauss version: OK (2.0.1)
           superuser or standard user with backup privileges: OK
                                                archive mode: OK
                                           archive directory: OK
                                   retention policy settings: OK (define retention redundancy)

 执行备份：

[omm@mogdb2 ~]$ /opt/brm/brm backup --instance=mogdbha --delete-expired
time="2021-12-24 16:00:32.041873" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
time="2021-12-24 16:00:32.042232" level=info msg="the gs_probackup path /opt/mogdb/app/bin/gs_probackup"
time="2021-12-24 16:00:32.054344" level=info msg="the gs_probackup version 2.0.1"
time="2021-12-24 16:00:32.054439" level=info msg="the gs_ctl path /opt/mogdb/app/bin/gs_ctl"
time="2021-12-24 16:00:32.065316" level=info msg="gs_ctl version 9.2.4 "
time="2021-12-24 16:00:32.078051" level=info msg="Instance mogdbha standby"
time="2021-12-24 16:00:32.078725" level=info msg="Run Backup Process Id 13322"
time="2021-12-24 16:00:32.089735" level=info msg="INFO: Backup start, gs_probackup version: 2.4.2, instance: mogdbha, backup ID: R4M0WW, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1"
time="2021-12-24 16:00:32.092351" level=info msg="LOG: Backup destination is initialized"
time="2021-12-24 16:00:32.100656" level=info msg="VERBOSE: (query) SELECT pg_catalog.current_setting($1)"
time="2021-12-24 16:00:32.10072" level=info msg="VERBOSE: 	(param:0) = block_size"
time="2021-12-24 16:00:32.101107" level=info msg="VERBOSE: (query) SELECT pg_catalog.current_setting($1)"
time="2021-12-24 16:00:32.101151" level=info msg="VERBOSE: 	(param:0) = wal_block_size"
time="2021-12-24 16:00:32.10133" level=info msg="VERBOSE: (query) SELECT proname FROM pg_proc WHERE proname='pgpro_edition'"
time="2021-12-24 16:00:32.102185" level=info msg="VERBOSE: (query) SELECT pg_catalog.pg_is_in_recovery()"
time="2021-12-24 16:00:32.102399" level=info msg="WARNING: This openGauss instance was initialized without data block checksums. gs_probackup have no way to detect data block corruption without them. Reinitialize PGDATA with option '--data-checksums'."
time="2021-12-24 16:00:32.10245" level=info msg="INFO: Backup R4M0WW is going to be taken from standby"
time="2021-12-24 16:00:32.10248" level=info msg="LOG: Database backup start"
time="2021-12-24 16:00:32.102503" level=info msg="VERBOSE: (query) SELECT pg_catalog.pg_start_backup($1, $2, false)"
time="2021-12-24 16:00:32.102525" level=info msg="VERBOSE: 	(param:0) = 2021-12-24 16:00:32+08 with pg_probackup"
time="2021-12-24 16:00:32.102549" level=info msg="VERBOSE: 	(param:1) = true"
time="2021-12-24 16:00:32.204776" level=info msg="VERBOSE: (query) show checkpoint_timeout"
time="2021-12-24 16:00:32.209495" level=info msg="VERBOSE: (query) IDENTIFY_SYSTEM"
time="2021-12-24 16:00:32.209796" level=info msg="LOG: started streaming WAL at 0/1A000000 (timeline 1)"
time="2021-12-24 16:00:32.209896" level=info msg="VERBOSE:                                                                                             Excluding directory content: pg_replslot"
time="2021-12-24 16:00:32.209928" level=info msg="[2021-12-24 16:00:32]: check identify system success"
time="2021-12-24 16:00:32.20996" level=info msg="VERBOSE: Excluding file: postmaster.opts"
time="2021-12-24 16:00:32.209984" level=info msg="VERBOSE: Excluding directory content: pg_xlog"
time="2021-12-24 16:00:32.210221" level=info msg="VERBOSE: Excluding directory content: pg_notify"
time="2021-12-24 16:00:32.210261" level=info msg="VERBOSE: Excluding directory content: pg_serial"
time="2021-12-24 16:00:32.210292" level=info msg="VERBOSE: Excluding directory content: pg_snapshots"
time="2021-12-24 16:00:32.21032" level=info msg="INFO: Cannot parse path "base""
time="2021-12-24 16:00:32.211632" level=info msg="[2021-12-24 16:00:32]: send START_REPLICATION 0/1A000000 success"
time="2021-12-24 16:00:32.2117" level=info msg="[2021-12-24 16:00:32]: keepalive message is received"
time="2021-12-24 16:00:32.214655" level=info msg="VERBOSE: Excluding directory content: pg_stat_tmp"
time="2021-12-24 16:00:32.214713" level=info msg="VERBOSE: Excluding file: postmaster.pid"
time="2021-12-24 16:00:32.214744" level=info msg="VERBOSE: (query) SELECT oid, datname FROM pg_catalog.pg_database WHERE datname NOT IN ('template1', 'template0', 'postgres')"
time="2021-12-24 16:00:32.215967" level=info msg="INFO: PGDATA size: 861MB"
time="2021-12-24 16:00:32.216352" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/base'"
time="2021-12-24 16:00:32.2164" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/base/1'"
time="2021-12-24 16:00:32.216426" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/base/15098'"
time="2021-12-24 16:00:32.216452" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/base/15103'"
time="2021-12-24 16:00:32.216482" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/global'"
time="2021-12-24 16:00:32.216506" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_clog'"
time="2021-12-24 16:00:32.216555" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_csnlog'"
time="2021-12-24 16:00:32.216601" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_errorinfo'"
time="2021-12-24 16:00:32.216636" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_llog'"
time="2021-12-24 16:00:32.216658" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_llog/mappings'"
time="2021-12-24 16:00:32.216686" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_llog/snapshots'"
time="2021-12-24 16:00:32.216707" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_location'"
time="2021-12-24 16:00:32.21675" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_multixact'"
time="2021-12-24 16:00:32.216802" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_multixact/members'"
time="2021-12-24 16:00:32.216827" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_multixact/offsets'"
time="2021-12-24 16:00:32.216873" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_notify'"
time="2021-12-24 16:00:32.216904" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_replslot'"
time="2021-12-24 16:00:32.216925" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_serial'"
time="2021-12-24 16:00:32.216945" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_snapshots'"
time="2021-12-24 16:00:32.216965" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_stat_tmp'"
time="2021-12-24 16:00:32.216988" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_tblspc'"
time="2021-12-24 16:00:32.217016" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_twophase'"
time="2021-12-24 16:00:32.217041" level=info msg="VERBOSE: Create directory '/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_xlog'"
time="2021-12-24 16:00:32.223611" level=info msg="INFO: Start transferring data files"
time="2021-12-24 16:00:32.223695" level=info msg="VERBOSE: Start thread num: 0"
time="2021-12-24 16:00:32.22404" level=info msg="LOG: Creating page header map "/mogdb_brm_bak/data/backups/mogdbha/R4M0WW/page_header_map""
time="2021-12-24 16:00:32.247016" level=info msg="[2021-12-24 16:00:32]: keepalive message is received"
time="2021-12-24 16:00:34.123286" level=info msg="INFO: Data files are transferred, time elapsed: 2s"
time="2021-12-24 16:00:34.123381" level=info msg="VERBOSE: (query) SET client_min_messages = warning;"
time="2021-12-24 16:00:34.12366" level=info msg="VERBOSE: (query) SET datestyle = 'ISO, DMY';"
time="2021-12-24 16:00:34.123805" level=info msg="VERBOSE: (query) SELECT pg_catalog.txid_snapshot_xmax(pg_catalog.txid_current_snapshot()), current_timestamp(0)::timestamptz, lsn, labelfile, spcmapfile FROM pg_catalog.pg_stop_backup(false)"
time="2021-12-24 16:00:35.123963" level=info msg="INFO: wait for pg_stop_backup()"
time="2021-12-24 16:00:35.124073" level=info msg="INFO: pg_stop backup() successfully executed"
time="2021-12-24 16:00:35.124108" level=info msg="LOG: stop_lsn: 0/1A88D450"
time="2021-12-24 16:00:35.124141" level=info msg="LOG: Looking for LSN 0/1A88D450 in segment: 00000001000000000000001A"
time="2021-12-24 16:00:36.12431" level=info msg="INFO: Wait for LSN 0/1A88D450 in streamed WAL segment /mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_xlog/00000001000000000000001A"
time="2021-12-24 16:00:37.25847" level=info msg="LOG: finished streaming WAL at 0/1A88E058 (timeline 1)"
time="2021-12-24 16:00:38.12456" level=info msg="LOG: Found WAL segment: /mogdb_brm_bak/data/backups/mogdbha/R4M0WW/database/pg_xlog/00000001000000000000001A"
time="2021-12-24 16:00:38.124691" level=info msg="INFO: Wait a few minutes to get the target LSN or the last valid record prior to the target LSN"
time="2021-12-24 16:00:38.12476" level=info msg="VERBOSE: Thread [0]: Need to switch to the next WAL segment, page LSN 0/1A88C000, record being read LSN 0/1A88D450"
time="2021-12-24 16:00:38.124822" level=info msg="LOG: Found LSN: 0/1A88D450"
time="2021-12-24 16:00:38.124863" level=info msg="LOG: Getting the Recovery Time from WAL"
time="2021-12-24 16:00:38.12489" level=info msg="VERBOSE: Thread [0]: Need to switch to the next WAL segment, page LSN 0/1A88C000, record being read LSN 0/1A88D450"
time="2021-12-24 16:00:38.124912" level=info msg="LOG: Current minRecPoint 0/1A88E058"
time="2021-12-24 16:00:38.124932" level=info msg="LOG: Setting minRecPoint to 0/1A88D450"
time="2021-12-24 16:00:38.141789" level=info msg="INFO: Syncing backup files to disk"
time="2021-12-24 16:00:40.576739" level=info msg="INFO: Backup files are synced, time elapsed: 2s"
time="2021-12-24 16:00:40.578206" level=info msg="INFO: Validating backup R4M0WW"
time="2021-12-24 16:00:41.031944" level=info msg="INFO: Backup R4M0WW data files are valid"
time="2021-12-24 16:00:41.032039" level=info msg="INFO: Backup R4M0WW resident size: 878MB"
time="2021-12-24 16:00:41.032072" level=info msg="INFO: Backup R4M0WW completed"
time="2021-12-24 16:00:41.032116" level=info msg="LOG: REDUNDANCY=1"
time="2021-12-24 16:00:41.032152" level=info msg="LOG: WINDOW=7"
time="2021-12-24 16:00:41.032176" level=info msg="INFO: Evaluate backups by retention"
time="2021-12-24 16:00:41.032208" level=info msg="INFO: Backup R4M0WW, mode: FULL, status: OK. Redundancy: 1/1, Time Window: 0d/7d. Active"
time="2021-12-24 16:00:41.032231" level=info msg="INFO: There are no backups to merge by retention policy"
time="2021-12-24 16:00:41.032252" level=info msg="INFO: There are no backups to delete by retention policy"
time="2021-12-24 16:00:41.032273" level=info msg="INFO: There is no WAL to purge by retention policy"


 显示所有数据备份集:

[omm@mogdb2 ~]$  /opt/brm/brm show-backup
time="2021-12-24 16:03:20.338443" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
time="2021-12-24 16:03:20.338835" level=info msg="the gs_probackup path /opt/mogdb/app/bin/gs_probackup"
time="2021-12-24 16:03:20.350814" level=info msg="the gs_probackup version 2.0.1"
time="2021-12-24 16:03:20.350863" level=info msg="the gs_ctl path /opt/mogdb/app/bin/gs_ctl"
time="2021-12-24 16:03:20.361473" level=info msg="gs_ctl version 9.2.4 "
data source: local
===================================================================================================================================
 Instance  Version  ID      Recovery Time           Mode  WAL Mode  TLI  Time   Data   WAL  Zratio  Start LSN   Stop LSN    Status 
===================================================================================================================================
 mogdbha   9.2      R4M0WW  2021-12-24 16:00:33+08  FULL  STREAM    1/0    8s  862MB  16MB    1.00  0/1A868EB8  0/1A88D450  OK  


 WAL备份:

[omm@mogdb2 ~]$ /opt/brm/brm backup-wal --instance=mogdbha --primary-host=192.168.***.*** --primary-host-password=****** --primary-host-user=omm
time="2021-12-24 16:09:45.450563" level=info msg="Using config file:/home/omm/.brm/brm.yaml"
time="2021-12-24 16:09:45.450919" level=info msg="the gs_probackup path /opt/mogdb/app/bin/gs_probackup"
time="2021-12-24 16:09:45.462979" level=info msg="the gs_probackup version 2.0.1"
time="2021-12-24 16:09:45.463036" level=info msg="the gs_ctl path /opt/mogdb/app/bin/gs_ctl"
time="2021-12-24 16:09:45.473632" level=info msg="gs_ctl version 9.2.4 "
time="2021-12-24 16:09:45.480419" level=info msg="Instance mogdbha backup wal by ssh archive dir"
time="2021-12-24 16:09:45.48048" level=info msg="the host 192.168.26.164 user omm pri file "
time="2021-12-24 16:09:45.588493" level=info msg="Instance mogdbha backup wal from /ogarchive"
time="2021-12-24 16:09:45.645723" level=info msg="Download file 000000010000000000000004 size 16777216"
time="2021-12-24 16:09:46.629269" level=info msg="Download file /ogarchive/000000010000000000000004 is finished"
time="2021-12-24 16:09:46.73121" level=info msg="Download file 000000010000000000000005 size 16777216"
time="2021-12-24 16:09:47.705047" level=info msg="Download file /ogarchive/000000010000000000000005 is finished"
time="2021-12-24 16:09:47.806621" level=info msg="Download file 000000010000000000000006 size 16777216"
time="2021-12-24 16:09:48.78705" level=info msg="Download file /ogarchive/000000010000000000000006 is finished"
time="2021-12-24 16:09:48.88786" level=info msg="Download file 000000010000000000000007 size 16777216"
time="2021-12-24 16:09:49.873929" level=info msg="Download file /ogarchive/000000010000000000000007 is finished"
time="2021-12-24 16:09:49.976185" level=info msg="Download file 000000010000000000000008 size 16777216"
time="2021-12-24 16:09:51.009903" level=info msg="Download file /ogarchive/000000010000000000000008 is finished"
time="2021-12-24 16:09:51.111713" level=info msg="Download file 000000010000000000000009 size 16777216"
time="2021-12-24 16:09:52.107553" level=info msg="Download file /ogarchive/000000010000000000000009 is finished"
time="2021-12-24 16:09:52.208434" level=info msg="Download file 00000001000000000000000A size 16777216"
time="2021-12-24 16:09:53.203188" level=info msg="Download file /ogarchive/00000001000000000000000A is finished"
time="2021-12-24 16:09:53.304238" level=info msg="Download file 00000001000000000000000B size 16777216"
time="2021-12-24 16:09:54.302076" level=info msg="Download file /ogarchive/00000001000000000000000B is finished"
time="2021-12-24 16:09:54.402994" level=info msg="Download file 00000001000000000000000C size 16777216"
time="2021-12-24 16:09:55.471067" level=info msg="Download file /ogarchive/00000001000000000000000C is finished"
time="2021-12-24 16:09:55.574649" level=info msg="Download file 00000001000000000000000D size 16777216"
time="2021-12-24 16:09:56.566192" level=info msg="Download file /ogarchive/00000001000000000000000D is finished"
time="2021-12-24 16:09:56.669257" level=info msg="Download file 00000001000000000000000E size 16777216"
time="2021-12-24 16:09:57.660784" level=info msg="Download file /ogarchive/00000001000000000000000E is finished"
time="2021-12-24 16:09:57.76388" level=info msg="Download file 00000001000000000000000F size 16777216"
time="2021-12-24 16:09:58.741894" level=info msg="Download file /ogarchive/00000001000000000000000F is finished"
time="2021-12-24 16:09:58.843447" level=info msg="Download file 000000010000000000000010 size 16777216"
time="2021-12-24 16:09:59.836635" level=info msg="Download file /ogarchive/000000010000000000000010 is finished"
time="2021-12-24 16:09:59.942059" level=info msg="Download file 000000010000000000000011 size 16777216"
time="2021-12-24 16:10:01.003673" level=info msg="Download file /ogarchive/000000010000000000000011 is finished"
time="2021-12-24 16:10:01.105757" level=info msg="Download file 000000010000000000000012 size 16777216"
time="2021-12-24 16:10:02.09824" level=info msg="Download file /ogarchive/000000010000000000000012 is finished"
time="2021-12-24 16:10:02.198976" level=info msg="Download file 000000010000000000000013 size 16777216"
time="2021-12-24 16:10:03.205815" level=info msg="Download file /ogarchive/000000010000000000000013 is finished"
time="2021-12-24 16:10:03.307058" level=info msg="Download file 000000010000000000000014 size 16777216"
time="2021-12-24 16:10:04.350882" level=info msg="Download file /ogarchive/000000010000000000000014 is finished"
time="2021-12-24 16:10:04.451968" level=info msg="Download file 000000010000000000000015 size 16777216"
time="2021-12-24 16:10:05.528908" level=info msg="Download file /ogarchive/000000010000000000000015 is finished"
time="2021-12-24 16:10:05.632298" level=info msg="Download file 000000010000000000000016 size 16777216"
time="2021-12-24 16:10:06.641274" level=info msg="Download file /ogarchive/000000010000000000000016 is finished"
time="2021-12-24 16:10:06.744125" level=info msg="Download file 000000010000000000000017 size 16777216"
time="2021-12-24 16:10:07.733474" level=info msg="Download file /ogarchive/000000010000000000000017 is finished"
time="2021-12-24 16:10:07.835423" level=info msg="Download file 000000010000000000000018 size 16777216"
time="2021-12-24 16:10:08.816898" level=info msg="Download file /ogarchive/000000010000000000000018 is finished"
time="2021-12-24 16:10:08.918557" level=info msg="Download file 000000010000000000000019 size 16777216"
time="2021-12-24 16:10:09.915109" level=info msg="Download file /ogarchive/000000010000000000000019 is finished"

创建定时备份任务

[omm@mogdb2 ~]$ crontab -l
30 0 * * * source /home/omm/.bashrc;/opt/brm/brm backup --instance=mogdbha --delete-expired
1 0 * * * source /home/omm/.bashrc;/opt/brm/brm backup-wal --instance=mogdbha --primary-host=192.168.***.*** --primary-host-password=*** --primary-host-user=omm

至此全部部署完毕！！！