Monday, November 27, 2017

Steps for backup and restore informatica domain

Backup Informatica Domain:

1. Stop all the informatica services and server

2. Backup the domain using infasetup BackupDomain command utility


infasetup.(bat | sh) BackupDomain -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -bf <backup_file_name> -dn <domain_name>

Check for the backup file

Restoring Informatica Domain:

1. Copy the backup file to the new machine
2. Create a database schema and a user account in a supported database
3.  Install informatica on the new machine but do not configure 
4. Copy the files in the <INFA_HOME>/server/infa_shared directories on the original machine to the new machine.
5. Restore the domain configuration backup to the database schema.

Run the infasetup RestoreDomain command to restore the domain configuration in the backup file to the
specified database schema.


infasetup.(bat | sh) RestoreDomain -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -bf <backup_file_name>

6. Update the database connection information for each gateway node.Gateway nodes must have a connection to the domain configuration database to retrieve and update domain configuration. Run the infasetup Update Gateway Node command on each gateway node to update the database connection information for each gateway node.


infasetup.(bat | sh) UpdateGatewayNode -da <database_hostname:database_port> -du<database_user_name> -dp <database_password> -dt <database_type> -ds<database_service_name> -dn <domain_name>

7. Start all the nodes and enable all application services in domain


  1. Its very informative blog and useful article thank you for sharing with us , keep posting learn
    more about Informatica Online Training Hyderabad

  2. Extremely useful guide, very grateful

  3. Calculated science and circle arithmetic can be helpful in the plotting of the innovative scene. how to write a blog post that converts

  4. On the off chance that you need to make a site that will be marked like Pinterest or Flickr, you can be somewhat more innovative. Domain Appraisal

  5. I think this is a really good article. You make this information interesting and engaging. You give readers a lot to think about and I appreciate that kind of writing.

  6. I feel this is the best way of providing some useful and more aspects of Informatica in order to make it more usable for the IT world.

    Informatica Read Soap API

  7. This article was written by a real thinking writer without a doubt. I agree many of the with the solid points made by the writer. I’ll be back day in and day for further new updates. store name ideas

  8. Legitimate domainers stay away from domain names that encroach on licensed innovation and they stay away from typosquatting domain names that are like licensed innovation.

  9. I think this is an informative post and it is very useful and knowledgeable. therefore, I would like to thank you for the efforts you have made in writing this article.


SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...