Disaster Recovery Plan For Informatica Infrastructure

Disaster Recovery is the most crucial part in the BI environment to ensure the smooth running of BI environment as well as availability of resources and reports to the business. The purpose of Disaster Recovery is to make sure whether the Qa environment or DR backup environment will perform or behave in the same as  how the production environment behaves in case of non-availability of production environment.

Below are the steps involved in Disaster Recovery per my expertise.
  • Take the backup of the production repository database schema.  Which will be the DR Instance for us.
  • Bring down the Informatica Qa environment.
  • Take the backup of the Application mount ($INFA_HOME)and remove all the directories under($INFA_HOME)  from QA environment from all the nodes (servers)
  • Restore the production Application mount ($INFA_HOME) backup to Qa Application mount ($INFA_HOME).
  • Restore the new schema (DR Instance) as a new repository and create the repository service (same name as prod repository) in the QA environment and make up all the services.
  • Remove the Integration services from all the workflows.
  • Assign the Integration services to point to new repository service.
  • Assign the Integration services to the workflows which are going to undergo DR Drill.
  • Change the database credentials Relational connections, ODBC and .MLBT files to point them to QA for those sessions which will undergo the DR Drill.
  • Map the production sequence generator values to Qa sequences. In case of any sequence generators.
  • Enable the integration service to start the jobs.
  • Allow project support teams to verify the data loading.
  • Once the drill is completed disable the integration service, disable the repository, and re-point the integration services to QA repository.
  • Storage team will revert the NAS mount changes and DBA team will remove the schema.


  1. A solid disaster recovery plan in place can make all the difference. I know from experience in both having a plan in place and not.. that it is in everyone's interest to get one set up!

    1. Yes Sean... For Big Organization it's always recommended to have their DR environments...

  2. say i have some 100's of sftp connections both ways then this plan doesn't work

  3. It will work, Unless your using the Virtual IP adress configuration, While you are doing DR drill involve Network Team.

  4. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing.. Need to learn Software Testing Services

  5. Thank you for your post, I look for such article along time, today i find it finally. this post give me lots of advise it is very useful for me.

  6. Thanks for the valuable information. Keep your business alive with BCP after a disaster Business Continuity Management service. IARM, Information Security Services happy to assist you with your Business Continuity Planning (BCP) strategy for the Business Continuity Planning Services

  7. Good piece of work it contains all the matters with regards to the disaster recovery services. Good luck to you and your well performed job.

  8. Well stated, you have furnished the right information that will be useful to everybody. Thank you for sharing your thoughts. Security measures protect your company not only from data breaches, but also from excessive financial losses, a loss of people's trust, and potential risks to brand reputation and future benefits.
    IT infrastructure services
    Cybersecurity Service Provider


Featured Post

Cloud : A Trendsetter Technology