linux 下oracle备份脚本,linux下oracle rman备份脚本

#!/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}<

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