Informatica Power Center Backup: 6 Ultimate Steps to Avoid Data Loss

Quick Summary About Informatica Power Center Backup:

• Securing Informatica PowerCenter 9.5.1 requires a comprehensive six step backup procedure to prevent data loss.
• The process begins with backing up Data Transformation files and the Custom Global Components directory.
• A repository backup is then performed using the pmrep command line utility while the service is enabled.
• Reference data for address validation and identity populations must be backed up from the DQContent directory.
• The underlying Oracle database schemas should be secured using RMAN for both the domain and repository.
• System configurations including the odbc.ini file and the domain metadata via infasetup are essential for recovery.
• Final steps include safeguarding nodemeta.xml and domains.infa files to ensure node connectivity after restoration.

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:

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:

References :

Informatica Administrator Guide Version 9.5.1 HotFix 2

 People Also Asked (FAQs)