1,建立脚本test.sh,并chmod 777
2、
#! /bin/bash
# backup table
CURRENT_DATE=`date +%Y%m%d`
echo "show time"
echo $CURRENT_DATE
DATABASE_BACKUP_FILENAME="database_$CURRENT_DATE.dmp"
DATABASE_BACKUP_LOGFILE="database_$CURRENT_DATE.log"
DATABASE_BACKUP_DIR="/media/raid/database_backups"
DATABASE_BACKUP_HOST_DIR="/root/Downloads/backup/dmdb_files"
#backup all tables
docker exec -i container_name /bin/bash -c "cd /opt/dmdbms/bin && ./dexp SYSDBA/SYSDBA file=$DATABASE_BACKUP_FILENAME log=$DATABASE_BACKUP_LOGFILE tables=tablename directory=$DATABASE_BACKUP_DIR"
#move backup to host
docker cp container_name:"$DATABASE_BACKUP_DIR/$DATABASE_BACKUP_FILENAME" "$DATABASE_BACKUP_HOST_DIR/$DATABASE_BACKUP_FILENAME"
docker cp container_name:"$DATABASE_BACKUP_DIR/$DATABASE_BACKUP_LOGFILE" "$DATABASE_BACKUP_HOST_DIR/$DATABASE_BACKUP_LOGFILE"
3、crontab -e 添加脚本
4、到出库删除tables即可,记得换成自己的模式ID与密码