oracle备份脚本说明=============创建备份目录=============mkdir/data/db_backupmkdir/data/db_backup/expdp_backupmkdir/data/db_backup/rman_backupmkdir/data/db_backup/backup_shell=========创建目录=========SQL>createdirectoryexpdp_diras'/data/db_backup/expdp_backup';SQL>grantread,writeondirectoryexpdp_dirtonc65;==================创建expdp备份脚本==================#!/bin/bash#使用oracle环境变量source~/.bash_profile#设置变量days取系统日期格式为%Y%m%ddays=`date+%Y%m%d`#expdp导出语句expdpNC65/NC65directory=expdp_dirdumpfile=NC65_$days.dmplogfile=NC65_$days.logschemas=NC65#进入备份路径cd/home/data/db_backup/expdp_backup/#使用tar压缩模式对导出的.dump/.log文件进行压缩压缩格式为.tar.gztar-zcvfNC65_$days.dmp.tar.gzNC65_$days.dmpNC65_$days.log#找到导出格式为.dmp文件进行删除处理find/home/data/db_backup/expdp_backup/-typef-name"*.dmp"-execrm-rf{}\;#找到导出格式为.dmp文件进行删除处理find/home/data/db_backup/expdp_backup/-typef-name"*.log"-execrm-rf{}\;#制定保留策略，目前为7天压缩后的.dmp.tar.gz压缩备份集-mtime后参数可根据需求而定find/home/data/db_backup/expdp_backup/-mtime+7-name"*.dmp.tar.gz"-execrm-rf{}\;=============制定计划任务=============[oracle@erpora~]$crontab-l0003***/data/db_backup/backup_shell/expdp_nc65.sh
