Linux定时备份数据库与脚本加密

来源：互联网发布：js点击空白处触发事件编辑：程序博客网时间：2024/06/15 21:08

1.创建备份目录

mkdir /home/oracle/backup

2.授权对应权限

chmod +x backup.shchown oracle.oinstall /home/oracle/backup

3.oracle字符集查询

SQL> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------AMERICAN_AMERICA.ZHS16GBK

4.backup.sh脚本内容

#!/bin/bashexport NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"export ORACLE_BASE=/u01/oracleexport ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1export ORACLE_SID=orclexport PATH=$ORACLE_HOME/bin:$PATHexport DAYS=`date -d "15 days ago" +'%Y%m%d'`export BAKUPTIME=`date +'%Y%m%d%H%M'`echo "Starting bakup..."exp scott/tiger@orcl file=/home/oracle/backup/$BAKUPTIME.dmp log=/home/oracle/backup/$BAKUPTIME.logecho "Starting zip..."cd /home/oracle/backup/zip -m $BAKUPTIME.zip $BAKUPTIME.dmp $BAKUPTIME.logecho "Delete the file bakup before 15 days..."rm -rf /home/oracle/backup/$DAYS*.dmpecho "Delete the file bakup successfully. "echo "Bakup completed."

5.定时任务

--切换oracle用户su - oracle--编辑定时任务文件crontab -e--每天的凌晨2点,中午12点，晚上18点执行backup.sh0 2,12,18 * * * /home/oracle/backup/backup.sh--重启crond服务service crond restart--查看每天会收到mailcat /var/spool/mail/oracle

6.如有必要可以对脚本进行加密

第一种：

--下载shc文件(官网下载地址: http://www.datsi.fi.upm.es/~frosal/sources/)--解压文件tax xf shc-3.8.3.tgzcd shc-3.8.3--执行安装make test && make strings && make install--执行加密shc -r -f backup.sh

第二种：

gzexe backup.sh

0 0