Informatica自动备份folder和repository脚本

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

[oracle@uz22199 script]$ more export_folder.cfg 
ETL_10.4.2.37
ETL_10.4.3.100
ETL_10.4.3.27
los_promote_2.0.0
los_promote_etl
sd_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=C
export PM_CODEPAGENAME="MS936"
export INFA_HOME=/home/oracle/Informatica/PowerCenter8.6.1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib32:$INFA_HOME/server/bin
export JAVA_HOME=$INFA_HOME/java/
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export PM=/file/sql

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

cd /home/oracle/Informatica/backup
pmrep connect -r Repository_LOT -d Domain_UUZZ -n zhuhongjun -x zhuhongjun!@#321
for a in `cat /home/oracle/Informatica/PowerCenter8.6.1/server/script/export_folder.cfg`;
do
folder=$a;
pmrep objectexport -f $folder -u ${folder}_${DATE}.xml -l ${folder}_${DATE}.log
done
pmrep cleanup
echo "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 Status
STATUS=$?
if [ $STATUS -ne 0 ]
then
echo 'Repository Connection Failed:Invaid username/password'
return $STATUS
fi

# Backup Repository
Filename=$a'_'$(date +%Y%m%d)
pmrep Backup -o /home/oracle/Informatica/backup/$Filename
echo 'Backup Successfull : '$Filename
pmrep cleanup
done

tar 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=fanboshi@uuzz.com,songqi@uuzz.com
echo "Informatica folder repository $DATE" |/usr/bin/mutt -s "Informatica folder repository autobackup" $TO_MAIL -a /home/oracle/Informatica/backup/INFA_Folder_backup_${DATE}.tar.gz

find /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