#!/bin/bash
# full_backup.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn
# 设置环境变量
export DM_HOME=/dm/app
export PATH=$DM_HOME/bin:$PATH
export LD_LIBRARY_PATH=$DM_HOME/bin:$LD_LIBRARY_PATH
# 配置参数
DB_HOST=192.168.1.10
DB_PORT=5236
DB_USER=SYSDBA
DB_PASS=SYSDBA
BACKUP_DIR=/dm/backup/full
LOG_DIR=/dm/backup/log
DATE=$(date +%Y%m%d_%H%M%S)
BACKUP_NAME=DB_FULL_${DATE}
# 创建备份目录
mkdir -p $BACKUP_DIR
mkdir -p $LOG_DIR
# 记录开始时间
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 开始全库备份…” >> $LOG_DIR/full_backup_${DATE}.log
# 执行全库备份
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF >> $LOG_DIR/full_backup_${DATE}.log 2>&1
backup database full to ‘$BACKUP_DIR/${BACKUP_NAME}.bak’ compressed;
EOF
# 检查备份结果
if [ $? -eq 0 ]; then
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 全库备份成功” >> $LOG_DIR/full_backup_${DATE}.log
# 验证备份集
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF >> $LOG_DIR/full_backup_${DATE}.log 2>&1
check backupset ‘$BACKUP_DIR/${BACKUP_NAME}.bak’;
EOF
# 清理过期备份（保留30天）
find $BACKUP_DIR -name “DB_FULL_*.bak” -mtime +30 -delete
find $LOG_DIR -name “full_backup_*.log” -mtime +30 -delete
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 备份任务完成” >> $LOG_DIR/full_backup_${DATE}.log
else
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] 全库备份失败” >> $LOG_DIR/full_backup_${DATE}.log
fi

# 业务表空间备份脚本
#!/bin/bash
# tablespace_backup.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
export DM_HOME=/dm/app
export PATH=$DM_HOME/bin:$PATH
DB_USER=SYSDBA
DB_PASS=SYSDBA
DB_HOST=192.168.1.10
DB_PORT=5236
BACKUP_DIR=/dm/backup/tablespace
DATE=$(date +%Y%m%d)
# 备份业务表空间
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF backup tablespace fgedutbs to '$BACKUP_DIR/tbs_fgedutbs_${DATE}.bak' compressed; backup tablespace fgedu_idx to '$BACKUP_DIR/tbs_fgedu_idx_${DATE}.bak' compressed; EOF # 输出结果 [2025-04-09 02:30:00] 开始备份表空间FGEDUTBS 操作已执行 已用时间: 00:02:15.123 [2025-04-09 02:32:15] 开始备份表空间FGEDU_IDX 操作已执行 已用时间: 00:01:45.678 [2025-04-09 02:34:01] 表空间备份完成

#!/bin/bash
# dm_backup_scheduler.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn
export DM_HOME=/dm/app
export PATH=$DM_HOME/bin:$PATH
# 备份配置
BACKUP_BASE=/dm/backup
FULL_BACKUP_DIR=$BACKUP_BASE/full
INCR_BACKUP_DIR=$BACKUP_BASE/incremental
ARCH_BACKUP_DIR=$BACKUP_BASE/archivelog
LOG_DIR=$BACKUP_BASE/log
DB_HOST=192.168.1.10
DB_PORT=5236
DB_USER=SYSDBA
DB_PASS=SYSDBA
# 创建目录
mkdir -p $FULL_BACKUP_DIR $INCR_BACKUP_DIR $ARCH_BACKUP_DIR $LOG_DIR
# 日志函数
log() {
echo “[$(date ‘+%Y-%m-%d %H:%M:%S’)] $1” >> $LOG_DIR/backup_scheduler.log
}
# 判断是否为全量备份日（周日）
is_full_backup_day() {
weekday=$(date +%w)
if [ “$weekday” = “0” ]; then
return 0
else
return 1
fi
}
# 执行备份
if is_full_backup_day; then
log “开始执行全量备份…”
DATE=$(date +%Y%m%d_%H%M%S)
# 全量备份
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF >> $LOG_DIR/full_${DATE}.log 2>&1
backup database full to ‘$FULL_BACKUP_DIR/DB_FULL_${DATE}.bak’ compressed;
EOF
log “全量备份完成”
else
log “开始执行增量备份…”
DATE=$(date +%Y%m%d_%H%M%S)
# 增量备份
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF >> $LOG_DIR/incr_${DATE}.log 2>&1
backup database incremental to ‘$INCR_BACKUP_DIR/DB_INCR_${DATE}.bak’;
EOF
log “增量备份完成”
fi
# 归档日志备份
log “开始备份归档日志…”
disql $DB_USER/$DB_PASS@$DB_HOST:$DB_PORT << EOF >> $LOG_DIR/archive_${DATE}.log 2>&1
backup archivelog all to ‘$ARCH_BACKUP_DIR/ARCH_${DATE}.bak’ delete input;
EOF
log “归档日志备份完成”