Informatica help

Informatica help and metadata report query

Informatica domain Backup

Informatica domain Backup step by step instruction

 ${INFA_HOME}/server/bin/infasetup.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> -f

STEP 1: account login

  • Login into the Linux Informatica accounts (source that you want to copy from)

STEP 2: execute domain backup command

  • run the following command, Update the values in between the marked in bold blue <>
 ${INFA_HOME}/server/bin/infasetup.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> -f

The command above will create a new file with an extension of .mrep

Remark

  • For “-bf <backup_file_name>” option, I Usally provide the following Information: <Full Path to backup file>/<Domain Name>_<time stamp>_DomainBackup

Usage.

<<-DatabaseAddress|-da> database_hostname:database_port|<-DatabaseConnectionString|-cs> database_connection_string>
 [<-DatabaseUserName|-du> database_user_name]
 [<-DatabasePassword|-dp> database_password]
 <-DatabaseType|-dt> database_type
 [<-DatabaseServiceName|-ds> database_service_name]
 <-BackupFile|-bf> backup_file_name
 [<-Force|-f> overwrite_file]
 <-DomainName|-dn> domain_name
 [<-Tablespace|-ts> tablespace_name]
 [<-SchemaName|-sc> schema_name (used for MSSQLServer only)]
 [<-TrustedConnection|-tc> trusted_connection (used for MSSQLServer only)]

All Done.

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast