Objective :
To provide backup procedure for Informatica PowerCenter Production Server
PowerCenter Version : 9.5.1
Action Plan :
Server IP Address : 172.16.1.22
1-Back Up the Data Transformation Files
The following table lists the files & directories that you must back up:
| File or Directory | Location |
| Repository | $INFA_HOME/DataTransformation/ServiceDB |
| Custom Global Components directory (TGP files) | $INFA_HOME/DataTransformation/autoInclude/user |
| Configuration file | $INFA_HOME/DataTransformation/CMConfig.xml |
2-Repository Backup:
Using command line reference with skipping (workflow and session logs ,deploy group history ,MX data ,task statistics)
Note :
The Repository Service needs to be in ‘Enabled’ status
LIBPATH=$INFA_HOME/server/bin:$LIBPATH
echo “Retrieving Rep Service Name & Checking Repository Service Status ”
cd $INFA_HOME
./infacmd.sh ListServices -dn Domain_etl1 -un Administrator -pd ADMIN_APPSWD_HERE -st RS
./infacmd.sh GetServiceStatus -dn Domain_etl1 -un Administrator -pd ADMIN_APPSWD_HERE -sn Oracle_BI_DW_Prod
echo “Beginning Oracle_BI_DW_Prod Repository backup at `date`”>> backuplog.out
BACKUP_FILE=Oracle_BI_DW_Prod_Bkup.rep
BACKUP_FILE=${BACKUP_FILE%.*}_`date +%d%b%y`.${BACKUP_FILE#*.}
echo $BACKUP_FILE
pmrep connect -r Oracle_BI_DW_Prod -d Domain_etl1 -n Administrator -x ADMIN_APPSWD_HERE > backuplog.out 2>1
pmrep backup -o $BACKUP_FILE -b -j -q -v
echo “Done Oracle_BI_DW_Prod Repository backup at `date`”>> backuplog.out
3-Backup The Reference Data Directories :
the contents of the following reference data directories:
- $INFA_HOME/services/DQContent/INFA_Content/dictionaries/
Parent directory for the reference dictionary files.
- $INFA_HOME/services/DQContent/INFA_Content/av/
Parent directory for the address reference data files.
- $INFA_HOME/services/DQContent/INFA_Content/identity/
Parent directory for the identity population data files.
4-Back Up Databases
Use Oracle DB rman to back up the informatica schemas :
dbConnectString=”db1.data-and-analytics.com:1521:dwh”
Host IP : 192.168.1.2
Port : 1521
Service name : dwh
SCHEMAs : BIAPPS_INFA_DOMAIN , BIAPPS_INFA_REP
5-Back Up the odbc.ini File:
$INFA_HOME/obi/Informatica/ODBC7.0/odbc.ini
6- Backup the Domain Configuration: (backup of domain schema is sufficient)
- Run the infasetup BackupDomain command to back up the domain configuration database tables to a file.
- Back up the metadata configuration files to any directory accessible by the machines where you install Informatica.
Informatica infasetup includes command line programs to back up and restore the domain. infasetup is located in the following directory:
$INFA_HOME/isp/bin
To back up the domain with infasetup, use the following syntax:
infasetup BackupDomain
<<-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>]
<-DomainName|-dn> domain_name
[<-Tablespace|-ts> tablespace_name (used for IBM DB2 only)]
[<-SchemaName|-sc> schema_name (used for Microsoft SQL Server only)]
[<-DatabaseTlsEnabled|-dbtls> database_tls_enabled]
[<-DatabaseTruststorePassword|-dbtp> database_truststore_password]
[<-TrustedConnection|-tc> trusted_connection (used for Microsoft SQL Server only)]
[<-EncryptionKeyLocation|-kl> encryption_key_location]Back up the metadata configuration files to any directory accessible by the machines where you install Informatica. The following table describes the metadata files and the locations where you can find them:
| Metadata File | Description | Location |
| nodemeta.xml | Contains metadata for a node. | Stored in the isp/config directory on each node in the domain.
If you use the same backup directory name on all the nodes, rename nodemeta.xml before copying it to the backup location. For example, you back up nodemeta.xml to the /nodebak directory on nodeA and nodeB. Rename the configuration files so that on nodeA the file is backed up to /nodebak/nodemeta_A.xml, and on nodeB the file is backed up to /nodebak/nodemeta_B.xml. |
| domains.infa | Contains connectivity information for the gateway nodes. | Stored in one of the following locations:
· The Informatica installation directory on the client and server machines. · The location configured through the INFA_DOMAINS_FILE environment variable. |
References :
Informatica Administrator Guide Version 9.5.1 HotFix 2