Apr 5, 2011

Informatica Repository Backup and Restore

pmrep connect -r Repo name -n User_name -x Pass -h host -o Port
pmrep backup -o filename.rep


Shell Script:
#!/usr/bin/ksh

# Usage : bkp_rep.sh --repository name

REP=$1
REPUSER=repository user name
REPPWD=repository pwd
cd /opt/informatica/server/bin/  > /opt/informatica/server/bin/backup/$REP.rep
HOST=`hostname`
pmrep connect -r $REP -n $REPUSER -x $REPPWD -h $HOST -o 5001
# Check Status
STATUS=$?
if [ $STATUS -ne 0 ]
then
echo '[ERROR] : Repository Connection Failed'
return $STATUS
fi
# Backup Repository
FILENAME='Backup/'$REP
pmrep Backup -o $FILENAME -d backup -f -b -j -q
# Cleanup
pmrep cleanup
# Compress File
compress -f /opt/informatica/server/bin/Backup/$REP.rep
copied from link

For Restore(from Informatica Help)
restore -u administrator -p password -i repository1_backup.rep -y.

No comments:

Post a Comment