Informatica自动备份folder和repository脚本

http://b2daf797.wiz03.com/share/s/2OSLun3V44CI2LVCy70ROCI329BUvc1SIApq2Uw4ZH3WjDQt
配置文件

[oracle@uz22199 script]$ more export_folder.cfg ETL_10.4.2.37ETL_10.4.3.100ETL_10.4.3.27los_promote_2.0.0los_promote_etlsd_etl_bi199[oracle@uz22199 script]$ more rep.cfg Repository_LOT Domain_UUZZ Administrator Administrator

脚本

#!/usr/bin/sh# Usage: export_folder_script.sh##Informatica##export LANG=Cexport PM_CODEPAGENAME="MS936"export INFA_HOME=/home/oracle/Informatica/PowerCenter8.6.1export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$INFA_HOME/server/binexport JAVA_HOME=$INFA_HOME/java/export NLS_LANG=AMERICAN_AMERICA.AL32UTF8export PM=/file/sqlDATE=`date +%Y%m%d`cd /home/oracle/Informatica/backuppmrep connect -r Repository_LOT -d Domain_UUZZ -n zhuhongjun -x zhuhongjun!@#321for a in `cat /home/oracle/Informatica/PowerCenter8.6.1/server/script/export_folder.cfg`;dofolder=$a;pmrep objectexport -f $folder -u ${folder}_${DATE}.xml -l ${folder}_${DATE}.logdonepmrep cleanupecho "backup complete!"cat /home/oracle/Informatica/PowerCenter8.6.1/server/script/rep.cfg|while read line;do a=`echo $line|awk '{print $1}'`;b=`echo $line|awk '{print $2}'`;c=`echo $line|awk '{print $3}'`;d=`echo $line|awk '{print $4}'`;pmrep connect -r $a -d $b -n $c -x $d# Check StatusSTATUS=$?if [ $STATUS -ne 0 ]thenecho 'Repository Connection Failed:Invaid username/password'return $STATUSfi# Backup RepositoryFilename=$a'_'$(date +%Y%m%d)pmrep Backup -o /home/oracle/Informatica/backup/$Filenameecho 'Backup Successfull : '$Filenamepmrep cleanupdonetar zcvf /home/oracle/Informatica/backup/INFA_Folder_backup_${DATE}.tar.gz -C /home/oracle/Informatica/backup/ {*.xml,*.log,*.rep}rm /home/oracle/Informatica/backup/{*.xml,*.log,*.rep}TO_MAIL=[e-mail],[e-mail] "Informatica folder repository $DATE" |/usr/bin/mutt -s "Informatica folder repository autobackup" $TO_MAIL -a /home/oracle/Informatica/backup/INFA_Folder_backup_${DATE}.tar.gzfind /home/oracle/Informatica/backup/ -mtime +7 -exec rm -rf {} \;#0 12 * * 5 /bin/sh /home/oracle/Informatica/PowerCenter8.6.1/server/script/backup_infa.sh