11/19/09

Essbase Integration Backup

To back up Integration Services:
1 Perform a complete backup of the Oracle Essbase Integration Services catalog repository.
2 Optional: Export all models and metaoutlines into XML files.
3 Create and save a list of all source Open Database Connectivity (ODBC) Data Source Names (DSNs) that were set up.
4 Keep a current copy of installed software, along with all property files such as ais.cfg.

To recover Integration Services:
. If Integration Services installation files are lost because of hardware failure, you must reinstall Integration Services.
. If the database containing the catalog is corrupted, you must restore it and then create an ODBC DSN to the catalog and use it to retrieve models and metaoutlines.
. If the backup catalog database is also corrupted, then, from Oracle Essbase Integration Services Console, create an empty catalog and import each model and metaoutline using XML files.