(1)远程TELNET备份数据到磁带机的SHLL脚本
if [ $ -eq 0 ]
then
echo "## Tape Check : Success/n" >> $FLOG
echo "## Tape Check : Success/n"
else
echo "## Tape Check : Error(Insert tape into Device)/n" >> $FLOG
echo "## Tape Check : Error(Insert tape into Device)/n"
exit ${FAIL}
fi
echo "## Step 1 : FULL Backup ###" >> $FLOG
cd /
find fz02/RMANBK/lgmfis/*${MM}${DD}* -print|sort -rn +1|head -9| cpio -ocv -H od
c -C 30720 -O $DEVFILn | tee -a $FLST
find u08/EXP_BK/FZLFMES/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEV
FILn | tee -a $FLST
mt -f $DEVFILn offline
echo "## Step 1 : FULL Backup End ###" >> $FLOG
echo "please insert the secound tape"
Getyn "Was the secound tape insert (y/n)"
echo "## Step 2 : lgmfis db file & EXP Backup ###" >> $FL
OG
/usr/bin/mt -f ${DEVFILn} rewind
cd /
find fz02/RMANBK/lgmfis/*${YY}${MM}${DD}* -print|sort -n +1|head -7| cpio -ocv -
H odc -C 30720 -O $DEVFILn | tee -a $FLST
#find u08/EXP_BK/lgmfis/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEV
FILn | tee -a $FLST
echo "## Step 2 : lgmfis db file & EXP Backup END ###" >>
$FLOG
mt -f $DEVFILn offline
echo "please insert the third tape"
Getyn "Was the third tape insert (y/n)"
/usr/bin/mt -f ${DEVFILn} rewind
cd /
echo "## Step 3 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup
###" >> $FLOG
find fz01/RMANBK/FZLFMES/*${MM}${DD}* -print | cpio -ocv -H odc -C 30720 -O $DEV
FILn | tee -a $FLST
find fz02/RMANBK/lgmfis/*${MM}${DD}* -print|sort -rn +1|sed -n '10,11p;11q'| cpi
o -ocv -H odc -C 30720 -O $DEVFILn | tee -a $FLST
echo "## Step 3 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup End
###" >> $FLOG
mt -f $DEVFILn offline
echo "please insert the fourth tape"
Getyn "Was the fourth tape insert (y/n)"
/usr/bin/mt -f ${DEVFILn} rewind
cd /
echo "## Step 4 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup
###" >> $FLOG
find u08/EXP_BK/lgmfis/*${MM}${DD}.* -print | cpio -ocv -H odc -C 30720 -O $DEVF
ILn | tee -a $FLST
find u08/RMANBK/lgmfis/*${MM}${DD}* -print | cpio -ocv -H odc -C 30720 -O $DEVFI
Ln | tee -a $FLST
echo "## Step 4 : lgmfis arch & FZLFMES DATAFILE & ARCH & export Backup End
###" >> $FLOG
cd /
(2)自动RMAN脚本:
[lgmfisu:root] /u01/oracle/CIC/BACKUP> cat DB_FULL_lgmfis.sh
MM=`date +%m`
DD=`date +%d`
YY=`date +%y`
RMAN_LOG_FILE=/u01/oracle/CIC/LOG/FULL_HOT_lgmfis_${YY}${MM}${DD}.log
ORACLE_HOME=/u01/app/oracle/product/9.2.0
export ORACLE_HOME
ORACLE_SID=lgmfis
export ORACLE_SID
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
#find /fz02/RMANBK/lgmfis -mtime +0 -exec rm {} /;
find /u08/RMANBK/lgmfis -mtime +0 -exec rm {} /;
rm -f /fz02/RMANBK/lgmfis/db_full*
/u01/app/oracle/product/9.2.0/bin/rman target / nocatalog msglog $RMAN_LOG_FILE
append << EOF
RUN {
BACKUP FULL
FILESPERSET 4
FORMAT '/fz02/RMANBK/lgmfis/db_full_%T_%s_%p'
DATABASE;
sql 'alter system archive log current';
BACKUP
filesperset 20
FORMAT '/u08/RMANBK/lgmfis/al_%T_%s_%p'
ARCHIVELOG ALL DELETE INPUT;
BACKUP
FORMAT '/fz02/RMANBK/lgmfis/cntrl_%T_%s_%p'
CURRENT CONTROLFILE;
}
EOF
#find /fz02/RMANBK/lgmfis -mtime +0 -exec rm {} /;
#find /u08/RMANBK/lgmfis -mtime +0 -exec rm {} /;
you have mail in /var/mail/root
[lgmfisu:root] /u01/oracle/CIC/BACKUP>
mt -f $DEVFILn offline
END_YMD=`date +%Y%m%d`
END_HMS=`date +%H%M%S`
echo " $HOST TAPE Backup Successfully Ended At $END_