TABLE OF CONTENTS
1 Overview
2 Backup Production Repo file
3 Steps to Restore Repository
3.1 Step 1 – Connect to Dev Repository
3.2 Step 2 – Disable Dev Repo Services
3.3 Step 3 – Update Repository Service of Dev to run in Exclusive mode
3.4 Step 4 – Enable Repository Service
3.5 Step 5 – Re Connect to DEV repo to confirm Repo is in Exclusive mode
3.6 Step 6 – Delete DEV Repo Contents
3.7 Step 7 – Get latest backup of Prod Repo file
3.8 Step 8 – Connect to DEV repo using without repo user and repo pwd
3.9 Step 9 – Restore DEV repo using Prod backup file
3.9 Step 9 – Restore DEV repo using Prod backup file
3.10 Step 10 – Disable repo service
3.11 Step 11 – Update repository metadata table and fetch Scheduled workflow list
3.12 Step 12 – Switch Repository Service to run in Normal mode
3.12 Step 12 – Switch Repository Service to run in Normal mode
3.13 Step 13 – Identify and cleanse Scheduled Workflows in List
3.14 Step 14 – Enable repo service
3.15 Step 15 – Repository Service to run in Normal mode
3.16 Step 16 – Ping Integration Service
3.17 Step 17 – Disable Repository
3.18 Step 18 – Enable Repository Service
3.19 Step 19 – Disable Integration Service
3.20 Step 20 – Enable Integration Service
3.21 Step 21 – Ping Integration Services
3.22 Step 22 — UnSchedule Scheduled Workflows
3.23 Step 23 – Reconnect to repo run test workflow
3.24 Step 24 – Get List of wf Names from Admin Folder
3.25 Step 25 – Running test workflow
1 Overview
This document is intended for Informatica Administration Team to restore / refresh prod repository with dev repository using informatica command line utilities (pmrep, infacmd). This script can be scheduled in case if you want to refresh a repository with your prod repository on daily wise. Please be very careful and make sure have proper backups before execution of below commands.
2 Backup Production Repo file
Backup script on prod will take backup of repo on daily wise and schedule another script to sftp latest backup file to dev server to backup directory.
ABC8_PRD_REPO_backup_20120201_063017.rep
ABC8_PRD_REPO_backup_20120202_063015.rep
ABC8_PRD_REPO_backup_20120203_063016.rep
3 Steps to Restore Repository
Environment Variable Declarations
${Restored_Repo} – Repo Name
${ENV_INFA_PWD} – Administrator User id
${ENV_INFA_PWD} – Administrator Pwd
${DOMAIN} – Domain Name
${ENV_REPBKUP_DIR}
Restored_Repo=ABC8_DEV_REPO
‘Domain = domain_etldev202’
‘hostnode = servername’
‘Homer = /infa/informatica/pc86’
BackDir = /infa/informatica/pc86/server/infa_shared/Backup’
ScriptDir=’ /infa/scripts’
3.1 Step 1 – Connect to Dev Repository
pmrep connect -r ${Restored_Repo} -n ${ENV_INFA_ID} -x ${ENV_INFA_PWD} -d ${DOMAIN}
3.2 Step 2 – Disable Dev Repo Services
infacmd.sh DisableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -mo Abort
3.3 Step 3 – Update Repository Service of Dev to run in Exclusive mode
infacmd.sh updateRepositoryService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -so OperatingMode=Exclusive
sleep 180
3.4 Step 4 – Enable Repository Service
infacmd.sh EnableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo
sleep 60
3.5 Step 5 – Re Connect to DEV repo to confirm Repo is in Exclusive mode
pmrep connect -r ${Restored_Repo} -n ${ENV_INFA_ID} -x ${ENV_INFA_PWD} -d ${DOMAIN}
3.6 Step 6 – Delete DEV Repo Contents
pmrep delete -x ${ENV_INFA_PWD}
3.7 Step 7 – Get latest backup of Prod Repo file
Get latest backup file of prod repo from step 2 location
Latest_bkp_file=`ls -ltr $ENV_REPBKUP_DIR/ABC8_PRD_REPO_backup*|awk ‘{print $9}’|tail -1`
3.8 Step 8 – Connect to DEV repo using without repo user and repo pwd
pmrep connect -r ${Restored_Repo} -d ${DOMAIN}
3.9 Step 9 – Restore DEV repo using Prod backup file
pmrep restore -u ${ENV_INFA_ID} -p ${ENV_INFA_PWD} -i $Latest_bkp_file
3.10 Step 10 – Disable repo service
infacmd.sh DisableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -mo Abort
3.11 Step 11 – Update repository metadata table and fetch Scheduled workflow list
update opb_server_info set server_name = ‘ servername_iserv_dev ‘,domain_name = ‘domain_servername’
Commit;
select subject_area||’ ‘||workflow_name from rep_workflows where start_time is not null and RUN_OPTIONS in (4,8) order by 1;
Copy list of workflow names to a test file infa_vlt_schwf.txt
sleep 30
3.12 Step 12 – Switch Repository Service to run in Normal mode
infacmd.sh updateRepositoryService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -so OperatingMode=Normal
sleep 60
3.13 Step 13 – Identify and cleanse Scheduled Workflows in List
#— Remove first 1 Junk line from infa_vlt_schwf.txt
sed 1,1d ifx_vlt_schwf.txt > ${ScriptDir}/ifx_vlt1.txt
#—– Remove last 1 lines from vlt1.txt >> ${LogFile}
sed -n -e :a -e ‘1,1!{P;N;D;};N;ba’ ${ScriptDir}/ifx_vlt1.txt > ${ScriptDir}/ifx_vlt2.txt
3.14 Step 14 – Enable repo service
infacmd.sh EnableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo
3.15 Step 15 – Repository Service to run in Normal mode
infacmd.sh updateRepositoryService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -so OperatingMode=Normal
3.16 Step 16 – Ping Integration Service
infacmd.sh ping -dn ${DOMAIN} -sn ${INTEGRATION_SERVICE_vlt}
3.17 Step 17 – Disable Repository
infacmd.sh DisableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo -mo Abort
3.18 Step 18 – Enable Repository Service
infacmd.sh EnableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn $Restored_Repo
3.19 Step 19 – Disable Integration Service
infacmd.sh DisableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn ${INTEGRATION_SERVICE_vlt} -mo Abort
3.20 Step 20 – Enable Integration Service
infacmd.sh EnableService -dn ${DOMAIN} -un ${ENV_INFA_ID} -pd ${ENV_INFA_PWD} -sn ${INTEGRATION_SERVICE_vlt}
3.21 Step 21 – Ping Integration Services
infacmd.sh ping -dn ${DOMAIN} -sn ${INTEGRATION_SERVICE_vlt}
3.22 Step 22 — UnSchedule Scheduled Workflows
${ENV_SCRIPT_DIR}/ifx_vlt_unsch.ksh
3.23 Step 23 – Reconnect to repo run test workflow
pmrep connect -r ${Restored_Repo} -n ${ENV_INFA_ID} -x ${ENV_INFA_PWD} -d ${DOMAIN}
3.24 Step 24 – Get List of wf Names from Admin Folder
pmrep listobjects -o workflow -f IFX | sed ‘1,8d;/successfully/,$d’ > $SCRHOME/ifx_wf_restore_list.txt
3.25 Step 25 – Running test workflows
for a in `cat $SCRHOME/ifx_wf_restore_run.txt`;
do export WF=$a;
echo ‘Workflow Name’ = $WF >> ${LogFile}
echo “Starting the IFX test Workflow $WF” >> $logfile
${LIBRARY_PATH}/pmcmd startworkflow -sv ${INTEGRATION_SERVICE_vlt} -d ${DOMAIN} -u ${ENV_INFA_ID} -p ${ENV_INFA_PWD} -f ${INFA_FOLDER} -nowait $WF
done;