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
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;
This comment has been removed by a blog administrator.
ReplyDeleteIt is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletehttp://chennaitraining.in/oracle-training-in-chennai/
http://chennaitraining.in/oracle-dba-training-in-chennai/
http://chennaitraining.in/odi-training-in-chennai/
http://chennaitraining.in/oracle-soa-training-in-chennai/
http://chennaitraining.in/teradata-training-in-chennai/
http://chennaitraining.in/informix-training-in-chennai/
http://chennaitraining.in/sybase-training-in-chennai/
http://chennaitraining.in/sql-server-dba-training-in-chennai/
It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...
ReplyDeletehttp://chennaitraining.in/sap-rem-training-in-chennai/
http://chennaitraining.in/sap-scm-training-in-chennai/
http://chennaitraining.in/sap-sd-training-in-chennai/
http://chennaitraining.in/sap-sm-training-in-chennai/
http://chennaitraining.in/sap-srm-training-in-chennai/
http://chennaitraining.in/sap-success-factor-training-in-chennai/
http://chennaitraining.in/sap-tr-training-in-chennai/
http://chennaitraining.in/sap-wf-training-in-chennai/
Interesting blog, here a lot of valuable information is available, it is very useful information Keep do posting i like to follow this informatica online training
ReplyDeleteinformatica online course
informatica bdm training
informatica developer training
informatica training
informatica course
informatica axon training
Thanks a lot for sharing a great blog I was just browsing through the internet looking for some information and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject. Bookmarked this page, will come back for more keep going on it helped me a lot I have gained a lot of knowledge by reading your blog.
ReplyDeleteOracle SOA Training
Oracle SOA 12c Training
Oracle soa online training
Oracle soa course
oracle soa suite training
Thanks a lot for sharing a valuable blog on Oracle SOA Training. I was browsing through the internet looking for Oracle SOA Training and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can find more information about Oracle SOA by attending Oracle SOA Training. You can learn about interview questions by visiting fusion Interview Questions
ReplyDeleteThanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle SOA Interview Questions and Answers
ReplyDelete. Actually, I was looking for the same information on internet for
Oracle SOA Training and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more about Oracle SOA Tutorial also.
thank you for the article it is very interesting, please read our article
ReplyDeleteDeposit Sbobet Bola Sakuku
Daftar Slot Joker
Deposit IDN Poker Dana 10rb
Daftar IDN Poker Shopeepay
Daftar IDN Poker Tanpa Rekening
Agen Club388
Daftar Club388 Sakuku
Situs IBCBET