KingbaseES R6 单节点数据库异机恢复案例
阅读原文时间:2023年07月10日阅读:3

数据库运行硬件或系统环境如果发生了不可恢复的故障,这时只能采用异机恢复的方式恢复数据库。以下通过例子介绍异机恢复的过程。

一、硬件环境

192.168.237.101

数据库运行源主机

192.168.237.102

数据库恢复目标机(异机)

192.168.237.103

数据库备份所在主机 REPO_DB

二、初始化备份环境

在 103 主机配置 sys_backup.conf ,内容如下:

# target db style enum: single/cluster
_target_db_style="single"

one kingbase node IP

just provide one IP, script will use 'repmgr cluster show' get other node IP

_one_db_ip="192.168.237.101"

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.237.103"

label of this cluster

_stanza_name="kingbase"

OS user name of database

_os_user_name="c5"

!!!! dir to store the backup files

should be accessable for the OS user

_repo_path="/home/c5/bak"

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/c5/ES/V8/data"

bin dir of single

_single_bin_dir="/home/c5/ES/V8/Server/bin"

database user of single

_single_db_user="system"

database port of single

_single_db_port="54321"

运行 sys_backup.sh init , 验证数据库备份正常。

三、进行异机恢复

这里模拟101 环境宕机的情况。

1、ssh 互信配置

需要配置新的数据库主机 (102) 与备份主机 (103) 间的互信关系。因为数据库恢复时,需要从远程拷贝文件,需要配置相互间免密登录。

2、修改 REPO_IP 103 主机的 sys_rman.conf

[c5@nn03 bak]$ cat sys_rman.conf

Genarate by script at 20220114162108, should not change manually

[kingbase]
kb1-path=/home/c5/ES/V8/data --新数据库主机数据目录
kb1-port=54321
kb1-user=system
kb1-host=192.168.237.102 --新数据库主机
kb1-host-user=c5

[global]
repo1-path=/home/c5/bak
repo1-retention-full=5
log-path=/home/c5/ES/V8/Server/log
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

3、102 主机配置备份目录

创建目录:/home/c5/bak

创建 sys_rman.conf 文件

这个文件可以从原主机(101)拷贝,也可以从 备份主机拷贝,再进行修改

[c5@nn02 bak]$ cat sys_rman.conf

Genarate by script at 20220114162109, should not change manually

[kingbase]
kb1-path=/home/c5/ES/V8/data --目标数据库路径
[global]
repo1-host=192.168.237.103 --REPO数据库所在主机
repo1-host-user=c5
repo1-host-config=/home/c5/bak/sys_rman.conf
repo1-path=/home/c5/bak
log-path=/home/c5/ES/V8/Server/log
log-level-file=info
log-level-console=info

4、在新数据库主机进行恢复

在102 主机进行恢复:

[c5@nn02 ~]$ sys_rman --config=/home/c5/bak/sys_rman.conf --stanza=kingbase --log-path=/tmp restore

5、验证恢复准确性

手机扫一扫

移动阅读更方便

阿里云服务器
腾讯云服务器
七牛云服务器

你可能感兴趣的文章