How to take Informatica Repository Backup and restore it.
Informatica Repository backup can be taken in 2 ways
Using Admin Console
Using pmrep command
pmrep connect -r <repository_name> -d <domain_name> -n <user_name> -x <password>
pmrep backup -o <output_file_name> [-d <description>] [-f (overwrite existing output file)] [-b (skip workflow and session logs)] [-j (skip deploy group history)] [-q (skip MX data)] [-v (skip task statistics)]
Restore Backup:
Using pmrep command
To restore a repository backup, it is to be ensured that the repository database schema is empty as there is no option to forcefully restore a repository backup unlike domain restore.
However, a delete command may be issued to delete the repository contents before a repository backup in case if there is repository contents alreayd present in the schema.
To delete contents (if exists) and restore the repository contents from a backup file, do the following:
pmrep connect with user
pmrep connect -r repository_name <-d domain_name | -h portal_host_name -o portal_port_number> -n username -x password
pmrep delete
pmrep delete -x repository_password_for_confirmation -f (forceful delete: unregisters local repositories and delete)
pmrep connect without user -- This is required to connect to the repository does not have any content during restore i.e empty schema
pmrep connect -r repository_name <-d domain_name | -h portal_host_name -o portal_port_number>
pmrep restore
pmrep restore -u domain_user_name -s domain_user_security_domain -p domain_password -i input_file_name [-b (skip workflow and session logs) -j (skip deployment group history) -q (skip MX data) -f (skip task statistics)]
Using admin console
- Admin Console
- pmrep command
Using Admin Console
- Login to admin console.
- Select Repository service
- Select Backup contents under Actions menu to take backup of repository contents.
- Provide repository service username, password.
- provide a name for the backup that will create a backup file with .rep extension.
- the backup will be generally stored to infa_shared backup folder.
Using pmrep command
pmrep connect -r <repository_name> -d <domain_name> -n <user_name> -x <password>
pmrep backup -o <output_file_name> [-d <description>] [-f (overwrite existing output file)] [-b (skip workflow and session logs)] [-j (skip deploy group history)] [-q (skip MX data)] [-v (skip task statistics)]
Restore Backup:
Using pmrep command
To restore a repository backup, it is to be ensured that the repository database schema is empty as there is no option to forcefully restore a repository backup unlike domain restore.
However, a delete command may be issued to delete the repository contents before a repository backup in case if there is repository contents alreayd present in the schema.
To delete contents (if exists) and restore the repository contents from a backup file, do the following:
pmrep connect with user
pmrep connect -r repository_name <-d domain_name | -h portal_host_name -o portal_port_number> -n username -x password
pmrep delete
pmrep delete -x repository_password_for_confirmation -f (forceful delete: unregisters local repositories and delete)
pmrep connect without user -- This is required to connect to the repository does not have any content during restore i.e empty schema
pmrep connect -r repository_name <-d domain_name | -h portal_host_name -o portal_port_number>
pmrep restore
pmrep restore -u domain_user_name -s domain_user_security_domain -p domain_password -i input_file_name [-b (skip workflow and session logs) -j (skip deployment group history) -q (skip MX data) -f (skip task statistics)]
Using admin console
- Login to admin console.
- Select Repository service
- Select restore contents under Actions menu to restore repository contents.
- Provide repository service username, password.
- provide a name and path for the backup file to be restored.
Comments
Post a Comment