[ORACLE] RMAN FULLBACKUP Shell Script

내가 쓸거 참조용

 

+ archive log file도 같이 받음

+ tnsnames.ora에 명시된 DB(@EM19)로 접속

##########################################################################
#
# ORACLE ENV
#
##########################################################################
#!/usr/bin/bash
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
ORACLE_SID=EM191
ORACLE_UNQNAME=EM19
BACKUP_LOG_PATH=/u01/rman/99.log/EM19
export ORACLE_BASE
export ORACLE_HOME
export ORACLE_SID
export ORACLE_UNQNAME
export BACKUP_LOG_PATH
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"
LOG_FILE=${BACKUP_LOG_PATH}/UG191_rman_fullimg.log
TRACE_FILE=${BACKUP_LOG_PATH}/UG191_rman_fullimg.trc
START_TIME=`date`

echo ""
echo $ORACLE_BASE;echo $ORACLE_HOME;echo $ORACLE_SID;echo $ORACLE_UNQNAME
echo ""
echo ""


$ORACLE_HOME/bin/rman msglog=${LOG_FILE} <<EOF
connect target sys/welcome1@EM19

run{
configure backup optimization on;
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '+FRA/EM19/RMAN/autobackup_%F.ctl';
allocate channel ch01 device type disk format '+FRA/EM19/RMAN/FULL_%u.dbf';
allocate channel ch02 device type disk format '+FRA/EM19/RMAN/FULL_%u.dbf';
backup as copy database reuse plus archivelog format '+FRA/EM19/RMAN/ARCH_%u.arc';
sql 'alter system archive log current';
release channel ch01;
release channel ch02;
}
exit;
EOF
END_TIME=`date`

echo ""
echo "===================================================="
echo "               RMAN Image Full Backup "
echo "===================================================="
echo $START_TIME
echo $END_TIME