linux备份金仓数据库

1.创建 backup8.conf  kdb_host必须是127.0.0.1

kdb_home="/home/kingbase/cluster/kingbase"
kdbback_dest="/home/kingbaser6/backup1"
kdb_user="system"
kdb_pass="123456"
kdb_port="54321"
kdb_host="127.0.0.1"
kdb_list="test"
keep_time="7"

2.创建backup8.sh

#!/bin/bash
####################################################################################################################
###
###Descipt: this script is used for kingbase database backup,before you run it,you should set the variables such as
###         kdb_home,kdbback_dest,kdb_user,kdb_pass,kdb_host,kdb_port,kdb_list,keep_time and so on.
###
####################################################################################################################
####################### variable define ##########################

#load the backup confuration
#TODO:this cmd have error
#source backup8.conf 
#source /root/kb_scripts/kb_scripts/kb_backup/logical/backup8.conf

echo "kingbase database logical backup begin : $(date '+%Y-%m-%d %H:%M:%S')"

conf_file=$(dirname $(readlink -f "$0"))"/backup8.conf"
echo "conf file is: $conf_file"
source $conf_file


# modify the backup8.conf style: use "xxxx" replace xxxx, just benifit to source the conf file
#kdb_home=`cat backup8.conf |grep kdb_home|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdbback_dest=`cat backup8.conf |grep kdbback_dest|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdb_user=`cat backup8.conf |grep kdb_user|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdb_pass=`cat backup8.conf |grep kdb_pass|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdb_port=`cat backup8.conf |grep kdb_port|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdb_host=`cat backup8.conf |grep kdb_host|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#kdb_list=`cat backup8.conf |grep kdb_list|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`
#keep_time=`cat backup8.conf |grep keep_time|awk -F'=' '{print $2}'|sed s/[[:space:]]//g`

date=$(date '+%Y%m%d%H%M%S')
kdbback_final="${kdbback_dest}/kdbback_final"
LD_LIBRARY_PATH="${kdb_home}/lib"

####################### kingbase backup dest test ##################

[ -d ${kdbback_dest} ] || mkdir -p ${kdbback_dest}
[ -d ${kdbback_final} ] || mkdir -p ${kdbback_final}

####################### kingbase backup start  #######################

cd ${kdbback_dest}
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH
for db in `echo $kdb_list | sed 's/,/ /g'`; do
    [ -d ${db} ] || mkdir -p ${db}
        cd ${db}
    ##### kingbase server check as follows
        ${kdb_home}/bin/ksql -h ${kdb_host} -p ${kdb_port} -U ${kdb_user}   -c "select now();" template1 > /dev/null 2>&1
        if [ $? -ne 0 ] ;then
        echo "${date} sorry, please run the script in a kingbase server" >> backup_${db}_${date}.log 
        mv backup_${db}_${date}.log ${kdbback_final}
        exit 1
        else
        echo "${date} kingbase server is ok,kingbase backup ${db} is beginning ..." >> backup_${db}_${date}.log
        fi
    ##### end
        ##### kingbase backup files process as follows
    ${kdb_home}/bin/sys_dump -p ${kdb_port} -U ${kdb_user} -h ${kdb_host} -Fc -f ${db}_${date}.dmp ${db} -v >> backup_${db}_${date}.log 2>&1
        if [ $? -eq 0 ] ;then
            tar zcvf ${db}_${date}.tar.gz ${db}_${date}.dmp*
            if [ $? -eq 0 ] ;then
               rm -f ${db}_${date}.dmp*
            else
               mv ${db}_${date}.dmp* ${kdbback_final} 
            fi
            find . -mtime +${keep_time} -name ${db}'_*' | xargs -I {} rm {}
        else
        rm -f ${db}_${date}.dmp*
        fi
        ###### end
        ###### kingbase backup log files process as follows
    tar zcvf backup_log_${db}_${date}.tar.gz backup_${db}_${date}.log
        if [ $? -eq 0 ] ;then
           rm -f backup_${db}_${date}.log
    else
           mv backup_${db}_${date}.log ${kdbback_final}
        fi
        find . -mtime +${keep_time} -name backup_log_${db}'_*' | xargs -I {} rm {}
        ###### end
       cd ${kdbback_dest}
done

echo "kingbase database logical backup end : $(date '+%Y-%m-%d %H:%M:%S')"
echo ""

exit 0

将backup8.conf和backup8.sh文件放到/home/kingbase/task目录，没有task目录就手动创建一个

赋予可执行权限：chmod +x backup8.sh

 

编辑backup8.conf：vi backup8.conf

 

kdb_home 修改为数据库实际安装路径


kdbback_dest修改为数据库备份目录，该目录需存在，空间足够


kdb_user 和kdb_pass修改为实际的用户名和密码


kdb_list修改为实际的数据库名，如果有多个数据库，则以逗号分隔


keep_time为保存天数，按需调整

查询数据库安装路径：

ps -ef|grep data

 

就写到画框的那：/home/kingbase/cluster/kingbase

修改完成之后添加定时任务执行：

crontab -e

增加
10 02 * * * /home/kingbase/task/backup8.sh

保存退出

每天凌晨2时10分开始备份，该时间可以根据实际情况调整

 

 

现在执行会让输入密码，需要修改配置文件：sys_hba.conf  这个配置文件在data目录下

 

 

show hba_file;   就能找到data目录

 

 

编辑sys_hba.conf配置文件：

vi /dbdata/data/data/sys_hba.conf

 

改为trust

 

改完重启数据库：

su - kingbase 
/home/kingbase/cluster/kingbase/bin/sys_ctl -D /dbdata/data/data restart

 不重启数据库命令：

su - kingbase 

/home/kingbase/cluster/kingbase/bin/sys_ctl -D /dbdata/data/data reload