linux下oracle rman备份脚本

来源:这里教程网 时间:2026-03-03 14:11:49 作者:

#!/bin/bash # author:xjf # date:20190828 # desc:backup database # set environment variable export ORACLE_SID=orcl export ORACLE_BASE=/home/soft/oracle/app export ORACLE_HOME=$ORACLE_BASE/orcl export ORACLE_UNQNAME=orcl export PATH=$PATH:$ORACLE_HOME/bin #log file RMAN_LOG=/home/oracle/shell/logs/rman/$(date +%Y%m%d%H%M); TEMP_LOG=/home/oracle/bak/rman.log; #week WEEK_DAY=$(date +%w) if [ $WEEK_DAY -eq 7 ]; then         INCR_LVL="INCREMENTAL LEVEL=0" else         INCR_LVL="INCREMENTAL LEVEL=1" fi; echo "---------------------------------" >>${RMAN_LOG} echo "Rman Begin time at:"$(date +%Y%m%d%H%M) >>${RMAN_LOG} echo "Rman level: ${INCR_LVL}" >>${RMAN_LOG} #execute rman $ORACLE_HOME/bin/rman log=${TEMP_LOG}<<EOF connect target / RUN {         CONFIGURE DEVICE TYPE DISK PARALLELISM 8;         CONFIGURE RETENTION POLICY TO REDUNDANCY 2;         CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;         CONFIGURE BACKUP OPTIMIZATION ON;         CONFIGURE CONTROLFILE AUTOBACKUP ON;         CROSSCHECK BACKUP;         DELETE NOPROMPT EXPIRED BACKUP;         CROSSCHECK ARCHIVELOG ALL;         DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;         REPORT OBSOLETE;         DELETE NOPROMPT OBSOLETE;          #BACKUP ${INCR_LVL} DATABASE PLUS ARCHIVELOG DELETE INPUT; } EXIT; EOF #log cat ${TEMP_LOG}>>${RMAN_LOG} echo "Rman Stop working at time:"$(date +%Y%m%d%H%M)>>${RMAN_LOG} exit

相关推荐