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.