linux如何开启oracle自动备份的脚本

来源：互联网发布：网络节目商业计划书编辑：程序博客网时间：2024/06/09 22:58

1.新建要备份的文件路径并赋予权限

<ol><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>cd /home/oracle</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>mkdir backup</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>chmod 777 backup </strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>cd backup</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>mkdir data</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>chmod 777 data </strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>mkdir logs</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>chmod 777 logs</strong></span></span></li><li><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-size:24px;color:#ff0000;"><strong>chmod 777 backup.sh</strong></span></span></li></ol>

2.编写backup.sh文件

<span style="font-size:24px;color:#ff0000;">#!/bin/sh    export ORACLE_BASE=/home/oracle  export ORACLE_HOME=$ORACLE_BASE/app/oracle/product/11.2.0/dbhome_1  export ORACLE_SID=orclexport PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin    export DATA_DIR=/home/backup/data  export LOGS_DIR=/home/backup/logs  export DELTIME=$(date -d "7 days ago" +%Y%m%d)  //删除七天前的备份export BAKUPTIME=$(date +%Y%m%d%H%M%S)   mkdir -p $DATA_DIR  mkdir -p $LOGS_DIR    echo "Starting bakup..."  echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"  exp dimdb/dbmdb@192.168.1.132/ORCL file=$DATA_DIR/$BAKUPTIME.dmp log=$LOGS_DIR/$BAKUPTIME.log    echo "Delete the file bakup before 7 days..."  rm -rf $DATA_DIR/$DELTIME*.dmp  rm -rf $LOGS_DIR/$DELTIME*.log  echo "Delete the file bakup successfully. "    echo "Bakup completed."  </span>

3.修改任务调度文件(root用户)

增加oracle用户的任务调度
crontab -u oracle -e
*/1 * * * * (sh /home/oracle/backup/backup.sh)//每分钟执行一次便于测试
查看oracle的任务分配
crontab -u oracle -l

4.启动crontab服务（root用户）

/sbin/service/ crond start

0 0