KingbaseES-v8-物理备份和还原-图文

学习中。。。

已于 2024-01-02 14:14:14 修改

阅读量274

点赞数

分类专栏： Kingbase 文章标签：数据库 linux

于 2023-09-14 08:15:04 首次发布

本文链接：https://blog.csdn.net/weixin_37846115/article/details/132853563

版权

Kingbase 专栏收录该内容

29 篇文章 0 订阅

订阅专栏

1.开启归档模式

cat >> /data/kingbase.conf << EOF
archive_mode = on
archive_commond = ''
EOF

2.备份初始化设置

复制sys_backup.sh的配置文件“安装目录/Server/share/sys_backup.conf”到“安装目录/Server/bin/sys_backup.conf”

cp /KingbaseES/V8/Server/share/sys_backup.conf /KingbaseES/V8/Server/bin/

编辑sys_backup.conf
vim /KingbaseES/V8/Server/bin/sys_backup.conf

# target db style enum:  single/cluster/single-pro
_target_db_style="single"
# one kingbase node IP/hostname
# just provide one IP/hostname, script will use 'repmgr cluster show' get other node IP/hostname
_one_db_ip="127.0.0.1"
# local repo IP/hostname, inner-REPO, means repo located in one db node
# outer repo IP/hostname, outer-REPO, means repo located in outer node
_repo_ip="127.0.0.1"
# 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="/backup/rman"
# 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
# band witdh limit, fixed in Mb/s, default 0 means no limit
_band_width=0
# OS cmd define
_os_ip_cmd="/usr/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="/data"
# bin dir of single
_single_bin_dir="/KingbaseES/V8/Server/bin"
# database user of single
_single_db_user="system"
# database port of single
_single_db_port="54321"
# on means sys_securecmd, off means normal ssh
_use_scmd=off

配置客户端免密认证
vim /data/sys_hba.conf

host    all             all             127.0.0.1/32            trust

重启数据库
sys_ctl restart -D /data
执行备份初始化脚本
/KingbaseES/V8/Server/bin/sys_backup.sh init

查看备份信息

sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase info

在这里插入图片描述

4.手动执行备份

全量备份

sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=full backup

增量备份

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

差异备份

sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase --archive-copy --type=diff backup

5.备份还原

su - root
mkdir /data1
chown kingbase:kingbase /data1
chmod 700 /data1
su - kingbase
sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase --kb1-path=/data1 restore
echo 'port = 12345' >> /data1/kingbase.conf
sys_ctl start -D /data1
ksql test system -p 12345