KingbaseES 集群异机sys_rman物理备份恢复

最新推荐文章于 2024-07-12 14:26:59 发布

nevermore08

最新推荐文章于 2024-07-12 14:26:59 发布

阅读量296

点赞数 4

文章标签：数据库

本文链接：https://blog.csdn.net/qq_44906157/article/details/139639271

版权

实验目的：
验证集群在异机（cluster1）对cluster2进行rman物理备份后，在cluster1_node11使用rman备份集进行数据库实例恢复。

基础环境要求：
1.两个集群安装目录相同
2.集群节点之间配置免密

基础环境

集群名称	IP
cluster1_node11	192.168.43.11
cluster1_node12	192.168.43.12
cluster2_node20	192.168.43.20
cluster2_node21	192.168.43.21

集群1
在这里插入图片描述
集群2

在集群1数据库主节点192.168.43.11执行sys_rman初始化，对集群2做异机物理备份。在执行初始化前，先做好节点之间的互信.

kingbase用户执行
ssh-keygen -t rsa
ssh-copy-id -i /home/kingbase/.ssh/id_rsa.pub kingbase@192.168.43.11
ssh-copy-id -i /home/kingbase/.ssh/id_rsa.pub root@192.168.43.11
ssh-copy-id -i /home/kingbase/.ssh/id_rsa.pub kingbase@192.168.43.20
ssh-copy-id -i /home/kingbase/.ssh/id_rsa.pub root@192.168.43.20

在cluster1_node1节点进行sys_rman初始化
配置sys_rman.conf文件

在这里插入图片描述

#file: sys_backup.conf
#dest dir: <cluster_dir>/kingbase/bin/sys_backup.conf
#dest dir: <cluster_dir>/kingbase/share/sys_backup.conf

# target db style enum:  single/cluster
_target_db_style="cluster"
# one kingbase node IP
# just provide one IP, script will use 'repmgr cluster show' get other node IP
_one_db_ip="192.168.43.20"
# local repo IP, inner-REPO, must be same as one_db_ip, means repo located in one db node
# outer repo IP, outer-REPO, means repo located in outer node
_repo_ip="192.168.43.11"
# label of this cluster
_stanza_name="kingbase"
# OS user name of database
_os_user_name="kingbase"
# !!!! dir to store the backup files
# should be accessable for the OS user
_repo_path="/home/kingbase/kbbr_repo"
# count of keep, over the count FULL-backup will be remove
_repo_retention_full_count=5
# count of days, interval to do FULL-backup
_crond_full_days=7
# count of days, interval to do DIFF-backup
_crond_diff_days=0
# count of days, interval to do INCR-backup
_crond_incr_days=1
# HOUR to do the FULL-backup
_crond_full_hour=2
# HOUR to do the DIFF-backup
_crond_diff_hour=3
# HOUR to do the INCR-backup
_crond_incr_hour=4
# OS cmd define
_os_ip_cmd="/sbin/ip"
_os_rm_cmd="/bin/rm"
_os_sed_cmd="/bin/sed"
_os_grep_cmd="/bin/grep"
# !!! these follow 4 parameter ONLY for single style
# data dir of single
_single_data_dir="/home/kingbase/cluster/cluster/test/kingbase/data"
# bin dir of single
_single_bin_dir="/home/kingbase/cluster/cluster/test/kingbase/bin"
# database user of single
_single_db_user="system"
# database port of single
_single_db_port="54321"

执行sys_rman.sh init 初始化
在这里插入图片描述
查看cluster2 archive_command参数；

cluster2创建测试表

CREATE TABLE events (event_id char(7) PRIMARY KEY, occurred_at timestamptz);

INSERT INTO events (event_id, occurred_at)
  SELECT to_hex(i),
  TIMESTAMP '2024-01-01 00:00:00+08' + floor(random() * 100000)::int * '1 minutes'::interval
  FROM generate_series(x'1000000'::int, x'2000000'::int, 16) AS s(i);

在这里插入图片描述
cluster1_node11节点（192.168.43.11）查看归档文件

执行增量备份
(sys_rman初始化时会对数据库进行一次全备，所以这里我们做的是创建表后的增量备份)

sys_rman --config=/home/kingbase/kbbr_repo/sys_rman.conf --stanza=kingbase --archive-copy --type=incr backup

2024-06-12 22:54:49.250 P00   INFO: backup command begin 2.27: --archive-copy --compress-level=3 --compress-type=gz --config=/home/kingbase/kbbr_repo/sys_rman.conf --log-level-console=info --log-level-file=info --log-path=/home/kingbase/cluster/cluster/test/kingbase/log --log-subprocess --kb1-host=192.168.43.20 --kb2-host=192.168.43.21 --kb1-host-user=kingbase --kb2-host-user=kingbase --kb1-path=/home/kingbase/cluster/cluster/test/kingbase/data --kb2-path=/home/kingbase/cluster/cluster/test/kingbase/data --kb1-port=54321 --kb2-port=54321 --kb1-user=esrep --kb2-user=esrep --process-max=4 --repo1-path=/home/kingbase/kbbr_repo --repo1-retention-full=5 --stanza=kingbase --type=incr
2024-06-12 22:54:52.098 P00   INFO: last backup label = 20240612-225110F, version = 2.27
2024-06-12 22:54:52.098 P00   INFO: execute non-exclusive sys_start_backup(): backup begins after the next regular checkpoint completes
2024-06-12 22:55:06.734 P00   INFO: backup start archive = 000000010000000000000010, lsn = 0/10000028
2024-06-12 22:55:09.401 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1249 (1016KB, 1%) checksum 754aad26cc73771b147c5ebb69a61197eddae351
2024-06-12 22:55:09.416 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2608 (776KB, 2%) checksum 164e42fbca8cb9f483d0accd30027aa28ff5a1d5
2024-06-12 22:55:09.456 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2673 (504KB, 3%) checksum ac03771bb5f4d47c7bb553374932eb48feaa7991
2024-06-12 22:55:09.469 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2674 (592KB, 3%) checksum 18376439799dfa6ada88d03021b92c96f828c1b9
2024-06-12 22:55:09.495 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/sys_csnlog/0000 (256KB, 4%) checksum 79719fb7a21e42fc721a78dea50648bd29c96573
2024-06-12 22:55:09.510 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2658 (248KB, 4%) checksum 3c667960819f04940cd2f608771b03b8d54a4b2a
2024-06-12 22:55:09.524 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1259 (240KB, 4%) checksum bacaa369135062209eb0bedd231916918d1fe13d
2024-06-12 22:55:09.549 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2659 (168KB, 5%) checksum 5b69cdefcc240d71e901dbe9db78d7bc8c8c575f
2024-06-12 22:55:09.570 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2619 (200KB, 5%) checksum ac96f20500b6cc6958912c73f1505a23092e5825
2024-06-12 22:55:09.583 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1247 (152KB, 5%) checksum 35ba14db737e4dfb02f7de17c6a7de0bb8e5f4f2
2024-06-12 22:55:09.591 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2663 (80KB, 5%) checksum 961c73cdfaeb5e9aaa929311c218c9349dbd2452
2024-06-12 22:55:09.606 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2704 (64KB, 5%) checksum ea54733caeb2e737911ae0fca0f99fae3cd3ae99
2024-06-12 22:55:09.609 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/3455 (56KB, 5%) checksum dea98f6d2965775815e4be35ec0be1f9ffcd8e15
2024-06-12 22:55:09.620 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2662 (48KB, 5%) checksum 71ef4efd3329712062ce0c6431781f882ab0dcac
2024-06-12 22:55:09.633 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2610 (40KB, 6%) checksum 8addaf2fa28247dcb0eb30b7d2edf7f8ae9c797a
2024-06-12 22:55:09.644 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2703 (40KB, 6%) checksum c3c0a379e7176ea71193e4ee3ad647373120dc3e
2024-06-12 22:55:09.659 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2696 (32KB, 6%) checksum ff3832771d71dd01633d5b7fa7fc6d6281fe33f3
2024-06-12 22:55:09.672 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/16460_fsm (32KB, 6%) checksum 6454493e05356f49fd7e96bb8005378ff273d535
2024-06-12 22:55:09.684 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2608_fsm (24KB, 6%) checksum a817bad894923e73e17ce8ba867e00fb84aa2412
2024-06-12 22:55:09.695 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1249_fsm (24KB, 6%) checksum d3aa26ca8ba0d577a4452e7afdcdd5229d091584
2024-06-12 22:55:09.695 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/8033 (16KB, 6%) checksum caa0db0aefe05092960ce83c7bcc844fc176d530
2024-06-12 22:55:09.708 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/8032 (16KB, 6%) checksum 6edc711c337a4d0447a9bf2659341cbf5b5cceba
2024-06-12 22:55:09.731 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2679 (16KB, 6%) checksum 1b3fed05cd8017822cee3f85c7574492a8cb860c
2024-06-12 22:55:09.747 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2678 (16KB, 6%) checksum 855f31b6abdd92988016e7632e4d6a747f1f202d
2024-06-12 22:55:09.773 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2667 (16KB, 6%) checksum 21aca558f0c3d770d8bdc0c7701b5d29be746892
2024-06-12 22:55:09.783 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2666 (16KB, 6%) checksum a9527bcded445d78d8f10656957ec85d15f7e1ed
2024-06-12 22:55:09.783 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2665 (16KB, 6%) checksum 674aa86d1139433fafe2cc7f7b0429eda3ecb43f
2024-06-12 22:55:09.795 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2664 (16KB, 6%) checksum e1715663fe85534bdcb07b965199af1d31ba8d40
2024-06-12 22:55:09.805 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2606 (16KB, 6%) checksum 258d38c00b09d012ad93cbc69c8f98a487089a33
2024-06-12 22:55:09.826 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2579 (16KB, 6%) checksum 52df6657cefdde2142d4d8b1510402456a722870
2024-06-12 22:55:09.837 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/sys_log/kingbase-2024-06-12_223934.log (11.5KB, 6%) checksum feb8de9ab91333ffdf22dda50f838dad0e1b075c
2024-06-12 22:55:09.854 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/sys_log/kingbase-2024-06-12_223934.csv (9.3KB, 6%) checksum cfd187eb6e6627e5b539e3225ac4ba085c62348a
2024-06-12 22:55:09.867 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/sys_xact/0000 (8KB, 6%) checksum 23c96f216e872250631f7a3142c34c906d0f24e8
2024-06-12 22:55:09.887 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/global/sys_control (8KB, 6%) checksum 09d8a9b952e4759cd0b96b48a51884640473971b
2024-06-12 22:55:09.894 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/8050_vm (8KB, 6%) checksum 3c5bcd899b606e4dc3695a46d6c9033caa068f21
2024-06-12 22:55:09.903 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/8050 (8KB, 6%) checksum c11f82d89c9ddd96b8e526f16f919c28a58ab81c
2024-06-12 22:55:09.912 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2619_vm (8KB, 6%) checksum a2b73929aaca439a5d5ff03231a475a5f7763953
2024-06-12 22:55:09.930 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2610_vm (8KB, 6%) checksum a1677ad99c12e2b73f549c90d3a5a496340ef246
2024-06-12 22:55:09.942 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2608_vm (8KB, 6%) checksum 30cba4652861a6efeaf9cf33cd00648798f93ee5
2024-06-12 22:55:09.955 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/2606_vm (8KB, 6%) checksum 997ce4a565802cc2372b1ed877530c090efbd39b
2024-06-12 22:55:09.966 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1259_vm (8KB, 6%) checksum 7ccc8d1ce501644a6077270162eaf319651a3351
2024-06-12 22:55:09.977 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1249_vm (8KB, 6%) checksum 5bebafd079dc4c207796351fb7cfac4c0ec10f09
2024-06-12 22:55:09.990 P04   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/1247_vm (8KB, 6%) checksum 6fca15186bed45dcddd57439d3a673738eef778e
2024-06-12 22:55:10.009 P03   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/sys_logical/replorigin_checkpoint (8B, 6%) checksum 347fc8f2df71bd4436e38bd1516ccd7ea0d46532
2024-06-12 22:55:10.570 P02   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/16463 (22.6MB, 38%) checksum fe512a30f2d09f1f1efc225498ef8d9edcf61a23
2024-06-12 22:55:11.820 P01   INFO: backup file 192.168.43.20:/home/kingbase/cluster/cluster/test/kingbase/data/base/16166/16460 (44.5MB, 100%) checksum a49a356becf7367244753c745ecf40283c5c915d
2024-06-12 22:55:11.824 P00   INFO: incr backup size = 71.9MB
2024-06-12 22:55:11.824 P00   INFO: execute non-exclusive sys_stop_backup() and wait for all WAL segments to archive
2024-06-12 22:55:12.031 P00   INFO: backup stop archive = 000000010000000000000010, lsn = 0/100001D0
2024-06-12 22:55:12.136 P00   INFO: check archive for segment(s) 000000010000000000000010:000000010000000000000010
2024-06-12 22:55:13.445 P00   INFO: new backup label = 20240612-225110F_20240612-225451I
2024-06-12 22:55:13.665 P00   INFO: backup command end: completed successfully (24425ms)
2024-06-12 22:55:13.666 P00   INFO: expire command begin 2.27: --config=/home/kingbase/kbbr_repo/sys_rman.conf --log-level-console=info --log-level-file=info --log-path=/home/kingbase/cluster/cluster/test/kingbase/log --log-subprocess --kb1-host=192.168.43.20 --kb2-host=192.168.43.21 --kb1-host-user=kingbase --kb2-host-user=kingbase --repo1-path=/home/kingbase/kbbr_repo --repo1-retention-full=5 --stanza=kingbase
2024-06-12 22:55:14.595 P00   INFO: expire command end: completed successfully (930ms)

查看备份集

sys_rman --config=/home/kingbase/kbbr_repo/sys_rman.conf --stanza=kingbase info

stanza: kingbase
    status: ok
    cipher: none

    db (current)
        wal archive min/max (V008R006C005B0023-1): 000000010000000000000004/000000010000000000000010

        full backup: 20240612-225110F
            timestamp start/stop: 2024-06-12 22:51:10 / 2024-06-12 22:51:19
            wal start/stop: 000000010000000000000006 / 000000010000000000000006
            database size: 80.2MB, backup size: 80.2MB
            repository size: 9.3MB, repository backup size: 9.3MB

        incr backup: 20240612-225110F_20240612-225451I
            timestamp start/stop: 2024-06-12 22:54:51 / 2024-06-12 22:55:11
            wal start/stop: 000000010000000000000010 / 000000010000000000000010
            database size: 147.4MB, backup size: 87.9MB
            repository size: 27.2MB, repository backup size: 18.6MB
            backup reference list: 20240612-225110F

在这里插入图片描述

修改sys_rman.conf文件，进行本地恢复

vi sys_rman.conf.bak
# Genarate by script at 20240612225043, should not change manually
[kingbase]
kb1-path=/home/kingbase/data_test   <恢复目标目录
>


[global]
repo1-host-user=kingbase  <备份服务器的操作系统用户名>
repo1-host-config=/home/kingbase/kbbr_repo/sys_rman.conf.bak <备份服务器的全路径sys_rman.conf>
repo1-path=/home/kingbase/kbbr_repo  <备份服务器的REPO全路径>
repo1-retention-full=5
log-path=/home/kingbase/  <本地日志目录>
log-level-file=info
log-level-console=info
log-subprocess=y
process-max=4
#### default gz, support: gz none
compress-type=gz
compress-level=3

执行还原

sys_rman --config=/home/kingbase/kbbr_repo/sys_rman.conf.bak --stanza=kingbase --delta restore

查看日志输出

2024-06-12 23:06:38.151 P00   INFO: restore command begin 2.27: --config=/home/kingbase/kbbr_repo/sys_rman.conf.bak --delta --log-level-console=info --log-level-file=info --log-path=/home/kingbase --log-subprocess --kb1-path=/home/kingbase/data_test --process-max=4 --repo1-path=/home/kingbase/kbbr_repo --stanza=kingbase
WARN: --delta or --force specified but unable to find 'SYS_VERSION' or 'backup.manifest' in '/home/kingbase/data_test' to confirm that this is a valid $KBDATA directory.  --delta and --force have been disabled and if any files exist in the destination directories the restore will be aborted.
2024-06-12 23:06:38.264 P00   INFO: restore backup set 20240612-225110F_20240612-225451I
2024-06-12 23:06:38.265 P00   INFO: remap data directory to '/home/kingbase/data_test'
2024-06-12 23:06:38.603 P04   INFO: restore file /home/kingbase/data_test/base/16385/2838 (1MB, 0%) checksum 49db4b120d18ce702f43a01cbf09afde6eef4f43
2024-06-12 23:06:38.604 P00   INFO: Restore Process: FILE: 1 / 2328 0%       SZIE: 1056768 bytes / 154536520 bytes 1MB / 147.4MB 0%
2024-06-12 23:06:38.671 P04   INFO: restore file /home/kingbase/data_test/base/16385/1249 (1MB, 1%) checksum 624d56b1b045e042ed55a9907990070fa5acaae1
2024-06-12 23:06:38.671 P00   INFO: Restore Process: FILE: 2 / 2328 0%       SZIE: 2113536 bytes / 154536520 bytes 2MB / 147.4MB 1%
2024-06-12 23:06:38.844 P04   INFO: restore file /home/kingbase/data_test/base/16167/2838 (1MB, 2%) checksum 810f0d1c392f3044d94d9b042c161dd0c8dd1c8a
2024-06-12 23:06:38.844 P00   INFO: Restore Process: FILE: 3 / 2328 0%       SZIE: 3170304 bytes / 154536520 bytes 3MB / 147.4MB 2%
2024-06-12 23:06:38.873 P02   INFO: restore file /home/kingbase/data_test/base/16166/16463 (22.6MB, 17%) checksum fe512a30f2d09f1f1efc225498ef8d9edcf61a23
2024-06-12 23:06:38.873 P00   INFO: Restore Process: FILE: 4 / 2328 0%       SZIE: 26869760 bytes / 154536520 bytes 25.6MB / 147.4MB 17%
2024-06-12 23:06:38.906 P04   INFO: restore file /home/kingbase/data_test/base/16167/1249 (1MB, 18%) checksum 8956b76b00a2142b4adaf4cbe7c37795f85fd2c2
2024-06-12 23:06:38.906 P00   INFO: Restore Process: FILE: 5 / 2328 0%       SZIE: 27926528 bytes / 154536520 bytes 26.6MB / 147.4MB 18%
2024-06-12 23:06:38.947 P02   INFO: restore file /home/kingbase/data_test/base/16166/2838 (1MB, 18%) checksum 81989b6aaf9579506b3640c449986b0706da199d
2024-06-12 23:06:38.947 P00   INFO: Restore Process: FILE: 6 / 2328 0%       SZIE: 28975104 bytes / 154536520 bytes 27.6MB / 147.4MB 18%
2024-06-12 23:06:38.995 P04   INFO: restore file /home/kingbase/data_test/base/16165/2838 (1MB, 19%) checksum 81989b6aaf9579506b3640c449986b0706da199d
2024-06-12 23:06:38.995 P00   INFO: Restore Process: FILE: 7 / 2328 0%       SZIE: 30023680 bytes / 154536520 bytes 28.6MB / 147.4MB 19%
2024-06-12 23:06:39.016 P02   INFO: restore file /home/kingbase/data_test/base/1/2838 (1MB, 20%) checksum 81989b6aaf9579506b3640c449986b0706da199d
2024-06-12 23:06:39.016 P00   INFO: Restore Process: FILE: 8 / 2328 0%       SZIE: 31072256 bytes / 154536520 bytes 29.6MB / 147.4MB 20%
2024-06-12 23:06:39.052 P03   INFO: restore file /home/kingbase/data_test/sys_wal/000000010000000000000010 (16MB, 30%) checksum ade2c5b16b5b7f933806ec6d504f4740cc1017a4
2024-06-12 23:06:39.052 P00   INFO: Restore Process: FILE: 9 / 2328 0%       SZIE: 47849472 bytes / 154536520 bytes 45.6MB / 147.4MB 30%
2024-06-12 23:06:39.053 P02   INFO: restore file /home/kingbase/data_test/base/16165/1249 (1016KB, 31%) checksum 20e00960a6757e8adca94e7aea635d9595cfd8b3
2024-06-12 23:06:39.053 P00   INFO: Restore Process: FILE: 10 / 2328 0%       SZIE: 48889856 bytes / 154536520 bytes 46.6MB / 147.4MB 31%
2024-06-12 23:06:39.203 P04   INFO: restore file /home/kingbase/data_test/base/16166/1249 (1016KB, 32%) checksum 754aad26cc73771b147c5ebb69a61197eddae351
2024-06-12 23:06:39.203 P00   INFO: Restore Process: FILE: 11 / 2328 0%       SZIE: 49930240 bytes / 154536520 bytes 47.6MB / 147.4MB 32%
2024-06-12 23:06:39.242 P02   INFO: restore file /home/kingbase/data_test/base/16385/1255 (936KB, 32%) checksum d63990461573be325b31000cbf303b347d362843
2024-06-12 23:06:39.242 P00   INFO: Restore Process: FILE: 12 / 2328 0%       SZIE: 50888704 bytes / 154536520 bytes 48.5MB / 147.4MB 32%
2024-06-12 23:06:39.287 P03   INFO: restore file /home/kingbase/data_test/base/1/1249 (1016KB, 33%) checksum 20e00960a6757e8adca94e7aea635d9595cfd8b3
2024-06-12 23:06:39.287 P00   INFO: Restore Process: FILE: 13 / 2328 0%       SZIE: 51929088 bytes / 154536520 bytes 49.5MB / 147.4MB 33%
2024-06-12 23:06:39.287 P04   INFO: restore file /home/kingbase/data_test/base/16167/1255 (936KB, 34%) checksum 6ce9db68eeb21551f515e2c73f68bd90accb766b
2024-06-12 23:06:39.287 P00   INFO: Restore Process: FILE: 14 / 2328 0%       SZIE: 52887552 bytes / 154536520 bytes 50.4MB / 147.4MB 34%
2024-06-12 23:06:39.297 P02   INFO: restore file /home/kingbase/data_test/base/16166/1255 (936KB, 34%) checksum 6ce9db68eeb21551f515e2c73f68bd90accb766b
2024-06-12 23:06:39.297 P00   INFO: Restore Process: FILE: 15 / 2328 0%       SZIE: 53846016 bytes / 154536520 bytes 51.4MB / 147.4MB 34%
2024-06-12 23:06:39.336 P03   INFO: restore file /home/kingbase/data_test/base/16165/1255 (936KB, 35%) checksum 6ce9db68eeb21551f515e2c73f68bd90accb766b
2024-06-12 23:06:39.336 P00   INFO: Restore Process: FILE: 16 / 2328 0%       SZIE: 54804480 bytes / 154536520 bytes 52.3MB / 147.4MB 35%
2024-06-12 23:06:39.351 P04   INFO: restore file /home/kingbase/data_test/base/1/1255 (936KB, 36%) checksum 6ce9db68eeb21551f515e2c73f68bd90accb766b
2024-06-12 23:06:39.351 P00   INFO: Restore Process: FILE: 17 / 2328 0%       SZIE: 55762944 bytes / 154536520 bytes 53.2MB / 147.4MB 36%
2024-06-12 23:06:39.367 P02   INFO: restore file /home/kingbase/data_test/base/16385/2608 (784KB, 36%) checksum 827517438f8e42ddb7baf916e15d5983af735bc0
2024-06-12 23:06:39.367 P00   INFO: Restore Process: FILE: 18 / 2328 0%       SZIE: 56565760 bytes / 154536520 bytes 53.9MB / 147.4MB 36%
2024-06-12 23:06:39.389 P03   INFO: restore file /home/kingbase/data_test/base/16167/2608 (776KB, 37%) checksum c152798044f571e177efaf64f6b631c70a7f987d
2024-06-12 23:06:39.389 P00   INFO: Restore Process: FILE: 19 / 2328 0%       SZIE: 57360384 bytes / 154536520 bytes 54.7MB / 147.4MB 37%
2024-06-12 23:06:39.402 P04   INFO: restore file /home/kingbase/data_test/base/16166/2608 (776KB, 37%) checksum 164e42fbca8cb9f483d0accd30027aa28ff5a1d5
2024-06-12 23:06:39.403 P00   INFO: Restore Process: FILE: 20 / 2328 0%       SZIE: 58155008 bytes / 154536520 bytes 55.5MB / 147.4MB 37%
2024-06-12 23:06:39.415 P02   INFO: restore file /home/kingbase/data_test/base/16165/2608 (776KB, 38%) checksum 6faaba61884da882baa3cad45dd60b203cde2127
2024-06-12 23:06:39.416 P00   INFO: Restore Process: FILE: 21 / 2328 0%       SZIE: 58949632 bytes / 154536520 bytes 56.2MB / 147.4MB 38%
2024-06-12 23:06:39.417 P03   INFO: restore file /home/kingbase/data_test/base/1/2608 (776KB, 38%) checksum 6faaba61884da882baa3cad45dd60b203cde2127
2024-06-12 23:06:39.417 P00   INFO: Restore Process: FILE: 22 / 2328 0%       SZIE: 59744256 bytes / 154536520 bytes 57.0MB / 147.4MB 38%
2024-06-12 23:06:39.434 P04   INFO: restore file /home/kingbase/data_test/base/16385/2674 (592KB, 39%) checksum 6c314b49f94899f802cf8bf28e5db5e1277163b6
2024-06-12 23:06:39.435 P00   INFO: Restore Process: FILE: 23 / 2328 0%       SZIE: 60350464 bytes / 154536520 bytes 57.6MB / 147.4MB 39%
2024-06-12 23:06:39.445 P02   INFO: restore file /home/kingbase/data_test/base/16167/2674 (592KB, 39%) checksum 5b00e06502df83ae99f86118b1b512a8fef505ae
2024-06-12 23:06:39.445 P00   INFO: Restore Process: FILE: 24 / 2328 1%       SZIE: 60956672 bytes / 154536520 bytes 58.1MB / 147.4MB 39%
2024-06-12 23:06:39.445 P03   INFO: restore file /home/kingbase/data_test/base/16166/2674 (592KB, 39%) checksum 18376439799dfa6ada88d03021b92c96f828c1b9
2024-06-12 23:06:39.445 P00   INFO: Restore Process: FILE: 25 / 2328 1%       SZIE: 61562880 bytes / 154536520 bytes 58.7MB / 147.4MB 39%
2024-06-12 23:06:39.466 P04   INFO: restore file /home/kingbase/data_test/base/16165/2674 (592KB, 40%) checksum f42498fa1bde5d06e4e1fea95e9430c57231e547
2024-06-12 23:06:39.466 P00   INFO: Restore Process: FILE: 26 / 2328 1%       SZIE: 62169088 bytes / 154536520 bytes 59.3MB / 147.4MB 40%
2024-06-12 23:06:39.492 P02   INFO: restore file /home/kingbase/data_test/base/1/2674 (592KB, 40%) checksum f42498fa1bde5d06e4e1fea95e9430c57231e547
2024-06-12 23:06:39.492 P00   INFO: Restore Process: FILE: 27 / 2328 1%       SZIE: 62775296 bytes / 154536520 bytes 59.9MB / 147.4MB 40%
2024-06-12 23:06:39.492 P03   INFO: restore file /home/kingbase/data_test/base/16385/2673 (512KB, 40%) checksum eacc68d06cd5cefd52769b9736de94340cdcc88d
2024-06-12 23:06:39.492 P00   INFO: Restore Process: FILE: 28 / 2328 1%       SZIE: 63299584 bytes / 154536520 bytes 60.4MB / 147.4MB 40%
2024-06-12 23:06:39.515 P04   INFO: restore file /home/kingbase/data_test/base/16167/2673 (504KB, 41%) checksum 3492b97f2f259e764c66887995bf9d130f8eafbd
2024-06-12 23:06:39.515 P00   INFO: Restore Process: FILE: 29 / 2328 1%       SZIE: 63815680 bytes / 154536520 bytes 60.9MB / 147.4MB 41%
2024-06-12 23:06:39.527 P03   INFO: restore file /home/kingbase/data_test/base/16165/2673 (504KB, 41%) checksum 6e1784d16dd3c910bf5191cd3be367281dffaca0
2024-06-12 23:06:39.527 P00   INFO: Restore Process: FILE: 30 / 2328 1%       SZIE: 64331776 bytes / 154536520 bytes 61.4MB / 147.4MB 41%
2024-06-12 23:06:39.535 P04   INFO: restore file /home/kingbase/data_test/base/1/2673 (504KB, 41%) checksum 6e1784d16dd3c910bf5191cd3be367281dffaca0
2024-06-12 23:06:39.535 P00   INFO: Restore Process: FILE: 31 / 2328 1%       SZIE: 64847872 bytes / 154536520 bytes 61.8MB / 147.4MB 41%
2024-06-12 23:06:39.543 P02   INFO: restore file /home/kingbase/data_test/base/16166/2673 (504KB, 42%) checksum ac03771bb5f4d47c7bb553374932eb48feaa7991
2024-06-12 23:06:39.543 P00   INFO: Restore Process: FILE: 32 / 2328 1%       SZIE: 65363968 bytes / 154536520 bytes 62.3MB / 147.4MB 42%
2024-06-12 23:06:39.553 P03   INFO: restore file /home/kingbase/data_test/base/16385/2691 (432KB, 42%) checksum b44bf50508730d427d30cc058b5aabf6f174358d
2024-06-12 23:06:39.553 P00   INFO: Restore Process: FILE: 33 / 2328 1%       SZIE: 65806336 bytes / 154536520 bytes 62.8MB / 147.4MB 42%
2024-06-12 23:06:39.560 P04   INFO: restore file /home/kingbase/data_test/base/16167/2691 (432KB, 42%) checksum 1863e2e04f0aa60fd35ff387ee216bd967f76b01
2024-06-12 23:06:39.560 P00   INFO: Restore Process: FILE: 34 / 2328 1%       SZIE: 66248704 bytes / 154536520 bytes 63.2MB / 147.4MB 42%
2024-06-12 23:06:39.569 P02   INFO: restore file /home/kingbase/data_test/base/16166/2691 (432KB, 43%) checksum 1863e2e04f0aa60fd35ff387ee216bd967f76b01
2024-06-12 23:06:39.569 P00   INFO: Restore Process: FILE: 35 / 2328 1%       SZIE: 66691072 bytes / 154536520 bytes 63.6MB / 147.4MB 43%
2024-06-12 23:06:39.579 P03   INFO: restore file /home/kingbase/data_test/base/16165/2691 (432KB, 43%) checksum 1863e2e04f0aa60fd35ff387ee216bd967f76b01
2024-06-12 23:06:39.579 P00   INFO: Restore Process: FILE: 36 / 2328 1%       SZIE: 67133440 bytes / 154536520 bytes 64MB / 147.4MB 43%
2024-06-12 23:06:39.588 P04   INFO: restore file /home/kingbase/data_test/base/1/2691 (432KB, 43%) checksum 1863e2e04f0aa60fd35ff387ee216bd967f76b01
2024-06-12 23:06:39.588 P00   INFO: Restore Process: FILE: 37 / 2328 1%       SZIE: 67575808 bytes / 154536520 bytes 64.4MB / 147.4MB 43%
2024-06-12 23:06:39.602 P02   INFO: restore file /home/kingbase/data_test/base/16385/2618 (368KB, 43%) checksum dfbf1b57d7555f27a647802267a1e36880172ee1
2024-06-12 23:06:39.602 P00   INFO: Restore Process: FILE: 38 / 2328 1%       SZIE: 67952640 bytes / 154536520 bytes 64.8MB / 147.4MB 43%
2024-06-12 23:06:39.612 P03   INFO: restore file /home/kingbase/data_test/base/16167/2618 (368KB, 44%) checksum 760df1929e5058c495eb4a4f7e986edeec691248
2024-06-12 23:06:39.612 P00   INFO: Restore Process: FILE: 39 / 2328 1%       SZIE: 68329472 bytes / 154536520 bytes 65.2MB / 147.4MB 44%
2024-06-12 23:06:39.621 P04   INFO: restore file /home/kingbase/data_test/base/16166/2618 (368KB, 44%) checksum cbe1f5aeb381967e540405cc75f7d8f0f761c892
2024-06-12 23:06:39.621 P00   INFO: Restore Process: FILE: 40 / 2328 1%       SZIE: 68706304 bytes / 154536520 bytes 65.5MB / 147.4MB 44%
2024-06-12 23:06:39.634 P02   INFO: restore file /home/kingbase/data_test/base/16165/2618 (368KB, 44%) checksum cbe1f5aeb381967e540405cc75f7d8f0f761c892
2024-06-12 23:06:39.634 P00   INFO: Restore Process: FILE: 41 / 2328 1%       SZIE: 69083136 bytes / 154536520 bytes 65.9MB / 147.4MB 44%
2024-06-12 23:06:39.642 P04   INFO: restore file /home/kingbase/data_test/base/16385/2609 (320KB, 44%) checksum 2a3a8011017dc19bf6d1aa8ff87f012960faf569
2024-06-12 23:06:39.642 P00   INFO: Restore Process: FILE: 42 / 2328 1%       SZIE: 69410816 bytes / 154536520 bytes 66.2MB / 147.4MB 44%
2024-06-12 23:06:39.642 P03   INFO: restore file /home/kingbase/data_test/base/1/2618 (368KB, 45%) checksum cbe1f5aeb381967e540405cc75f7d8f0f761c892
2024-06-12 23:06:39.642 P00   INFO: Restore Process: FILE: 43 / 2328 1%       SZIE: 69787648 bytes / 154536520 bytes 66.6MB / 147.4MB 45%
2024-06-12 23:06:39.656 P02   INFO: restore file /home/kingbase/data_test/base/16167/2609 (320KB, 45%) checksum 5e43732023a8e61d919d6500dfda071881b30e15
2024-06-12 23:06:39.656 P00   INFO: Restore Process: FILE: 44 / 2328 1%       SZIE: 70115328 bytes / 154536520 bytes 66.9MB / 147.4MB 45%
2024-06-12 23:06:39.667 P03   INFO: restore file /home/kingbase/data_test/base/16165/2609 (320KB, 45%) checksum 5e43732023a8e61d919d6500dfda071881b30e15
2024-06-12 23:06:39.667 P00   INFO: Restore Process: FILE: 45 / 2328 1%       SZIE: 70443008 bytes / 154536520 bytes 67.2MB / 147.4MB 45%
2024-06-12 23:06:39.669 P04   INFO: restore file /home/kingbase/data_test/base/16166/2609 (320KB, 45%) checksum 5e43732023a8e61d919d6500dfda071881b30e15
2024-06-12 23:06:39.669 P00   INFO: Restore Process: FILE: 46 / 2328 1%       SZIE: 70770688 bytes / 154536520 bytes 67.5MB / 147.4MB 45%
2024-06-12 23:06:39.671 P02   INFO: restore file /home/kingbase/data_test/base/1/2609 (320KB, 46%) checksum 5e43732023a8e61d919d6500dfda071881b30e15
2024-06-12 23:06:39.671 P00   INFO: Restore Process: FILE: 47 / 2328 2%       SZIE: 71098368 bytes / 154536520 bytes 67.8MB / 147.4MB 46%
2024-06-12 23:06:39.674 P03   INFO: restore file /home/kingbase/data_test/sys_csnlog/0003 (256KB, 46%) checksum 2e000fa7e85759c7f4c254d4d9c33ef481e459a7
2024-06-12 23:06:39.674 P00   INFO: Restore Process: FILE: 48 / 2328 2%       SZIE: 71360512 bytes / 154536520 bytes 68MB / 147.4MB 46%
2024-06-12 23:06:39.678 P04   INFO: restore file /home/kingbase/data_test/sys_csnlog/0002 (256KB, 46%) checksum 2e000fa7e85759c7f4c254d4d9c33ef481e459a7
2024-06-12 23:06:39.678 P00   INFO: Restore Process: FILE: 49 / 2328 2%       SZIE: 71622656 bytes / 154536520 bytes 68.3MB / 147.4MB 46%
2024-06-12 23:06:39.686 P02   INFO: restore file /home/kingbase/data_test/sys_csnlog/0001 (256KB, 46%) checksum 2e000fa7e85759c7f4c254d4d9c33ef481e459a7
2024-06-12 23:06:39.686 P00   INFO: Restore Process: FILE: 50 / 2328 2%       SZIE: 71884800 bytes / 154536520 bytes 68.6MB / 147.4MB 46%
2024-06-12 23:06:39.688 P03   INFO: restore file /home/kingbase/data_test/sys_csnlog/0000 (256KB, 46%) checksum 79719fb7a21e42fc721a78dea50648bd29c96573
2024-06-12 23:06:39.688 P00   INFO: Restore Process: FILE: 51 / 2328 2%       SZIE: 72146944 bytes / 154536520 bytes 68.8MB / 147.4MB 46%
2024-06-12 23:06:39.694 P04   INFO: restore file /home/kingbase/data_test/base/16385/2658 (248KB, 46%) checksum 7bf3f054ecbaa1ad431c6b905c59f8120382ebbd
2024-06-12 23:06:39.694 P00   INFO: Restore Process: FILE: 52 / 2328 2%       SZIE: 72400896 bytes / 154536520 bytes 69MB / 147.4MB 46%
2024-06-12 23:06:39.706 P00   INFO: Restore Process: FILE: 53 / 2328 2%       SZIE: 72654848 bytes / 154536520 bytes 69.3MB / 147.4MB 47%
2024-06-12 23:06:39.706 P03   INFO: restore file /home/kingbase/data_test/base/16166/2658 (248KB, 47%) checksum 3c667960819f04940cd2f608771b03b8d54a4b2a
2024-06-12 23:06:39.706 P00   INFO: Restore Process: FILE: 54 / 2328 2%       SZIE: 72908800 bytes / 154536520 bytes 69.5MB / 147.4MB 47%
2024-06-12 23:06:39.711 P04   INFO: restore file /home/kingbase/data_test/base/16165/2658 (248KB, 47%) checksum 261ff3885eaf08923041b7549096f1c24e1ebad4
2024-06-12 23:06:39.711 P00   INFO: Restore Process: FILE: 55 / 2328 2%       SZIE: 73162752 bytes / 154536520 bytes 69.8MB / 147.4MB 47%
2024-06-12 23:06:39.723 P03   INFO: restore file /home/kingbase/data_test/base/16385/3456 (240KB, 47%) checksum daf3546fe3b0c2423718c2b3247673e560d7c607
2024-06-12 23:06:39.723 P00   INFO: Restore Process: FILE: 56 / 2328 2%       SZIE: 73408512 bytes / 154536520 bytes 70MB / 147.4MB 47%
2024-06-12 23:06:39.729 P04   INFO: restore file /home/kingbase/data_test/base/16385/1259 (240KB, 47%) checksum aedc6873a746032a665b1188e126b718d45ba71c
2024-06-12 23:06:39.729 P00   INFO: Restore Process: FILE: 57 / 2328 2%       SZIE: 73654272 bytes / 154536520 bytes 70.2MB / 147.4MB 47%
2024-06-12 23:06:39.734 P03   INFO: restore file /home/kingbase/data_test/base/16167/3456 (240KB, 47%) checksum daf3546fe3b0c2423718c2b3247673e560d7c607
2024-06-12 23:06:39.734 P00   INFO: Restore Process: FILE: 58 / 2328 2%       SZIE: 73900032 bytes / 154536520 bytes 70.5MB / 147.4MB 47%
2024-06-12 23:06:39.734 P02   INFO: restore file /home/kingbase/data_test/base/1/2658 (248KB, 47%) checksum 261ff3885eaf08923041b7549096f1c24e1ebad4
2024-06-12 23:06:39.734 P00   INFO: Restore Process: FILE: 59 / 2328 2%       SZIE: 74153984 bytes / 154536520 bytes 70.7MB / 147.4MB 47%
........
中间省略
2024-06-12 23:06:41.842 P02   INFO: restore file /home/kingbase/data_test/.wallet/userkey.kr (0B, 100%)
2024-06-12 23:06:41.842 P00   INFO: Restore Process: FILE: 2326 / 2328 99%       SZIE: 154536520 bytes / 154536520 bytes 147.4MB / 147.4MB 100%
2024-06-12 23:06:41.843 P04   INFO: restore file /home/kingbase/data_test/.wallet/tbcolkey.kr (0B, 100%)
2024-06-12 23:06:41.843 P00   INFO: Restore Process: FILE: 2327 / 2328 99%       SZIE: 154536520 bytes / 154536520 bytes 147.4MB / 147.4MB 100%
2024-06-12 23:06:41.843 P03   INFO: restore file /home/kingbase/data_test/.wallet/tspkey.kr (0B, 100%)
2024-06-12 23:06:41.843 P00   INFO: Restore Process: FILE: 2328 / 2328 100%       SZIE: 154536520 bytes / 154536520 bytes 147.4MB / 147.4MB 100%
2024-06-12 23:06:41.844 P00   INFO: write updated /home/kingbase/data_test/kingbase.auto.conf
2024-06-12 23:06:41.847 P00   INFO: restore global/sys_control (performed last to ensure aborted restores cannot be started)
2024-06-12 23:06:42.253 P00   INFO: restore command end: completed successfully (4111ms)

进入data_test修改kingbase.conf 端口port=64321
在这里插入图片描述
启动数据库，验证events表
集群1 cluster1_node11节点

集群2 cluster2_node20节点
在这里插入图片描述
对比新恢复的实例里的events表的数据量和集群2一致，恢复成功。

总结：
此次恢复测试，是在异机上构建了和原备份主机相同的数据库存储目录，异机恢复数据成功。在做异机的物理备份恢复时，尽量选择和原备份主机相同的目录，这样恢复过程一般不容易出现错误，对于不同数据存储目录结构的恢复，还需再做测试。

nevermore08

关注

4
点赞
踩
4

收藏

觉得还不错? 一键收藏
0
评论
KingbaseES 集群异机sys_rman物理备份恢复

验证集群在异机（cluster1）对cluster2进行rman物理备份后，在cluster1_node11使用rman备份集进行数据库实例恢复。在集群1数据库主节点192.168.43.11执行sys_rman初始化，对集群2做异机物理备份。(sys_rman初始化时会对数据库进行一次全备，所以这里我们做的是创建表后的增量备份)对比新恢复的实例里的events表的数据量和集群2一致，恢复成功。集群1 cluster1_node11节点。集群2 cluster2_node20节点。
复制链接

扫一扫