[大数据]金仓kingbase数据库备份脚本以及非交互式启动和还原的命令

vim backup.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 ##########################

# 数据库安装目录
kdb_home="/opt/Kingbase/ES/V8/Server"

# 数据库备份的目标路径
kdbback_dest="/opt/kingbaseback"

# 数据库用户名
kdb_user="system"

# 数据库用户密码
kdb_pass="123456"

# 数据库端口号
kdb_port="54321"

# 数据库访问ip
kdb_host="1.1.1.1"

# 数据库的库，多个库可用逗号分隔，如"TEST,SAMPLE"
kdb_list="TEST"

# 保留时间
keep_time="7"

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

####################### 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的服务是否正常启动状态，输出日志信息到日志文件
        ${kdb_home}/bin/ksql "host=${kdb_host} port=${kdb_port}  dbname=${db}  user=${kdb_user}  password=${kdb_pass}"  -c "select now();"> /dev/null 2>&1
        if [ $? -ne 0 ] ;then
            echo "${date} 对不起，检测到kingbase数据库未启动，请先启动" >> backup_${db}_${date}.log
            mv backup_${db}_${date}.log ${kdbback_final}
            exit 1
        else
            echo "${date} kingbase数据库正常运行中,${db}库正常" >> backup_${db}_${date}.log
        fi
        ##### end
        ##### 数据库的备份操作
        ${kdb_home}/bin/sys_dump "host=${kdb_host} port=${kdb_port}  dbname=${db}  user=${kdb_user}  password=${kdb_pass}" -F c -f ${db}_${date}.dmp>>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
        ###### 日志的备份操作
        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
exit 0
~
~

非交互式数据库还原

 PGPASSWORD=123456 sys_restore -h127.0.0.1   -Usystem -d abc xxx.dmp      //非交互式还原数据库

非交互式数据库登录

ksql "host=1.1.1.1 post=54321 user=system dbname=test password=123456"  //R6非交互式的方式登录数据库