Oracle备份脚本

#!/bin/bash

#db0 level backup

foldername=`date +%Y%m%d`

cd /oradata1/backup

if [ -d $foldername ]

then

        echo    'go on'

else

        echo    'need mkdir'

         mkdir $foldername

 fi

 

 export ORACLE_BASE=/opt/app/oracle/

 export ORACLE_HOME=/opt/app/oracle/product/11.2.0/dbhome_1/

 export ORACLE_SID=OGGTEST

 export NLS_LANG="simplified chinese_china.ZHS16GBK"

 export NLS_DATE_FORMAT="YYYY-MM-DD HH24:Mi:SS"

 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32

 export PATH=/bin:/usr/bin:/usr/ucb:/etc:$ORACLE_HOME/bin:.

 

 rman target /  log=/U01/backup/$foldername/full_LOG.log << RMAN_BACKUP

 run{

 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

 CONFIGURE CONTROLFILE AUTOBACKUP ON;

 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/U01/backup/$foldername/controlfile%F';

 allocate channel c1 device type disk;

 allocate channel c2 device type disk;

 allocate channel c3 device type disk;

 allocate channel c4 device type disk;

 backup incremental level 0 tag 'db0' database format '/U01/backup/$foldername/db0_%d_%T_%s' include current controlfile;

 delete noprompt obsolete;

 release channel c1;

 release channel c2;

 release channel c3;

 release channel c4;

 }

 RMAN_BACKUP