Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Process of Configuring and Managing the Informatica Repository >

Process of Backing Up and Restoring the Informatica Repository (Optional)


To backup and restore the Informatica repository

  1. Start the Repository Server Administration Console in Informatica PowerCenter.
  2. Display the Informatica Repository Administration dialog, as follows:
    1. In the console navigator at the left hand side, double click the Informatica Repository Server to expand this node.
    2. Right click on the server machine name that holds the Informatica Repository Server
    3. Choose Action | Connect to display the Connecting to Repository Server <name> dialog.
    4. Enter the Administrator password for this machine (do not change the default port number 5001), and click OK.
    5. Double click the Repositories node.
    6. Double click the Oracle_BI_DW_Base repository.
      Click for full size image
  3. To backup the Informatica Repository, do the following:
    1. Click the Backup option to display the Backup Repository dialog.
    2. Enter the Informatica Repository Administrator username and password.
    3. In the File Name field, enter a short name for the repository backup (for example, Inf_rep_backup).
    4. Click OK to start the backup.

      Informatica backs up the repository to the <DRIVE>:\Program Files\Informatica PowerCenter 7.1.4\RepositoryServer\bin\Backup folder.

  4. To restore the Informatica Repository, do the following:

    NOTE:  As a pre-requisite step, you must have backed up the Informatica Repository, as described in the previous step 3.

    1. Right click on the Oracle_BI_DW_Base node and click Delete to remove the Informatica Repository.
    2. Click the Restore option to display the Restore Repository dialog.
    3. Select a backup version of the Informatica Repository.
    4. Click OK to start the procedure.
  5. Check the Activity Log dialog to make sure that the backup or restore executes without errors.
    Click for full size image
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.