Oracle rman 自动备份脚本

Myth丶恋晨 2022-06-13 13:17 524阅读 0赞

oracle 备份脚本整理

1.fullbackup.sql 具体如下：

run\{  
   allocate channel d1 type disk;  
   backup filesperset 10 full format '/home/oracle/backup/orcl/fullback/FULLBAK\_%d\_%T\_%s\_%p' tag db\_full\_bak database;  
   sql 'alter system archive log current';  
   backup filesperset 50 archivelog all delete all input tag arch\_bak format '/home/oracle/backup/orcl/archivelog/ARCHBAK\_%d\_%T\_%s\_%p';  
   backup  format '/home/oracle/backup/ctlbackup/CTLBAK\_%d\_%T\_%s\_%p' tag ctl\_bak current controlfile;  
   backup  format '/home/oracle/backup/ctlbackup/INITBAK\_%d\_%T\_%s\_%p' tag initpara\_bak spfile;  
   release channel d1;  
    \}

2.archbackup.sql 具体如下

run\{  
  backup archivelog all format '/home/oracle/backup/orcl/archivelog/ARCHBAK\_%d\_%T\_%s' tag arch\_bak delete all input;  
   \}

3.startrman.sh

\#------------------------------------------------------------------------------------------------------------  
\#Environment variable setting  
\#------------------------------------------------------------------------------------------------------------  
source /home/oracle/.bash\_profile  
ORACLE\_SID=orcl  
export ORACLE\_SID  
SH\_HOME=/home/oracle/backup/orcl  
export SH\_HOME  
   
DATE=\`date +"%Y%m%d"\`  
week=\`date +"%w"\`  
rmanerror=$SH\_HOME/scripts/rmanerror.log  
   
\#-----------------------------------------------------------------------  
\#Confirm whether the oracle is runing  
\#-----------------------------------------------------------------------  
sqlplus -s  "/as sysdba"<<EOF  
whenever sqlerror exit 1  
whenever oserror exit 1  
select sysdate from dual;  
exit  
EOF  
   
if \[ $? -gt 0 \]; then  
exit  
fi  
   
\#-----------------------------------------------------------------------  
\#Begin to backup  
\#-----------------------------------------------------------------------  
   if \[ $week = "6" \] ; then  
      rman target / @$SH\_HOME/scripts/fullbackup.sql log=$SH\_HOME/log/rmanfullback\`date +"%Y%m%d"\`.log  
   else  
      rman target / @$SH\_HOME/scripts/archbackup.sql log=$SH\_HOME/logs/rmanarchback\`date +"%Y%m%d"\`.log  
   fi  
  
4.设置自动备份

crontab -e

0 0 \* \* \* /home/oracle/backup/orcl/scripts/startrman.sh