#!/bin/bash
# backup_script.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`
# 配置参数
DB_NAME=”fgedudb”
BACKUP_DIR=”/kingbase/backup”
FULL_BACKUP_DIR=”${BACKUP_DIR}/full”
INCREMENTAL_BACKUP_DIR=”${BACKUP_DIR}/incremental”
ARCHIVE_DIR=”${BACKUP_DIR}/archive”
LOG_DIR=”${BACKUP_DIR}/log”
# 创建目录
mkdir -p ${FULL_BACKUP_DIR} ${INCREMENTAL_BACKUP_DIR} ${ARCHIVE_DIR} ${LOG_DIR}
# 日志文件
LOG_FILE=”${LOG_DIR}/backup_$(date +%Y%m%d_%H%M%S).log”
# 记录开始时间
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 开始备份” >> ${LOG_FILE}
# 执行全量备份（每周日执行）
if [ $(date +%u) -eq 7 ]; then
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 执行全量备份” >> ${LOG_FILE}
FULL_BACKUP_FILE=”${FULL_BACKUP_DIR}/${DB_NAME}_full_$(date +%Y%m%d).backup”
kbackup -U system -d ${DB_NAME} -f ${FULL_BACKUP_FILE}
# 验证备份
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 验证全量备份” >> ${LOG_FILE}
kbackup -U system -d ${DB_NAME} -f ${FULL_BACKUP_FILE} -C
# 清理过期全量备份（保留4周）
find ${FULL_BACKUP_DIR} -name “${DB_NAME}_full_*.backup” -mtime +28 -delete
else
# 执行增量备份
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 执行增量备份” >> ${LOG_FILE}
LAST_FULL_BACKUP=$(ls -t ${FULL_BACKUP_DIR}/${DB_NAME}_full_*.backup | head -n 1)
INCREMENTAL_BACKUP_FILE=”${INCREMENTAL_BACKUP_DIR}/${DB_NAME}_incremental_$(date +%Y%m%d_%H%M%S).backup”
kbackup -U system -d ${DB_NAME} -f ${INCREMENTAL_BACKUP_FILE} -i ${LAST_FULL_BACKUP}
# 验证备份
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 验证增量备份” >> ${LOG_FILE}
kbackup -U system -d ${DB_NAME} -f ${INCREMENTAL_BACKUP_FILE} -C
# 清理过期增量备份（保留1周）
find ${INCREMENTAL_BACKUP_DIR} -name “${DB_NAME}_incremental_*.backup” -mtime +7 -delete
fi
# 备份归档日志
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 备份归档日志” >> ${LOG_FILE}
rsync -av /kingbase/archive/ ${ARCHIVE_DIR}/
# 清理过期归档日志（保留到下一次全量备份）
if [ $(date +%u) -eq 7 ]; then
find ${ARCHIVE_DIR} -mtime +7 -delete
fi
# 记录结束时间
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 备份完成” >> ${LOG_FILE}

#!/bin/bash
# restore_test.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: `http://www.fgedu.net.cn`
# 配置参数
DB_NAME=”fgedudb”
BACKUP_DIR=”/kingbase/backup”
TEST_DIR=”/kingbase/test_restore”
LOG_FILE=”${BACKUP_DIR}/log/restore_test_$(date +%Y%m%d_%H%M%S).log”
# 创建测试目录
mkdir -p ${TEST_DIR}
# 记录开始时间
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 开始恢复测试” >> ${LOG_FILE}
# 获取最新全量备份
LAST_FULL_BACKUP=$(ls -t ${BACKUP_DIR}/full/${DB_NAME}_full_*.backup | head -n 1)
# 恢复到测试目录
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 恢复备份到测试目录” >> ${LOG_FILE}
krestore -U system -d ${DB_NAME} -f ${LAST_FULL_BACKUP} -D ${TEST_DIR}
# 启动测试数据库
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 启动测试数据库” >> ${LOG_FILE}
sys_ctl start -D ${TEST_DIR}
# 验证恢复
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 验证恢复” >> ${LOG_FILE}
ksql -U system -d ${DB_NAME} -h fgedu.localhost -p 54322 -c “SELECT count(*) FROM fgedu_user;”
# 停止测试数据库
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 停止测试数据库” >> ${LOG_FILE}
sys_ctl stop -D ${TEST_DIR}
# 清理测试目录
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 清理测试目录” >> ${LOG_FILE}
rm -rf ${TEST_DIR}
# 记录结束时间
echo “$(date ‘+%Y-%m-%d %H:%M:%S’) – 恢复测试完成” >> ${LOG_FILE}