How to Backup HFM Application for Disaster Recovery

How to Backup HFM Application for Disaster Recovery [ID 854951.1]
		Modified 05-AUG-2011     Type HOWTO     Status PUBLISHED

In this Document
  Goal
  Solution

---

Applies to:

Hyperion Financial Management - Version: 9.2.0.1.00 to 11.1.1.3.00 - Release: 9.2 to 11.1
Information in this document applies to any platform.

Goal

To describe how to backup the HFM database for Disaster Recovery.

Solution

There is no single, detailed white paper document on disaster recovery because each method is different and customer specific, but there are general procedures and guidelines that are recommended.

1. To preserve application integrity, perform standard backup and restoration procedures of HFM repository database as dictated by the RDBMS vendor. The database files should be backed up according to standard RDBMS procedures. Once the database is up, you would need to update the UDL file to point to the new database with a user who has access to the database. Please assure that you are backing up the entire database to a file or other media, NOT just the tables. More information can be found in the HFM Installation Guide within the section called, "Backing Up Database Information", which includes a table that lists the various backup and restore tasks.
2. You can also make back-up copies of the application. To make backup copies of applications, extract and save application files. For instructions on extracting files, see the Hyperion Financial Management Administrators Guide 
   Extract and save these application file types to the Temp directory on the application server:
   Security files (*.sec), Metadata files (*.xml or *.app), Member Lists files (*.lst), Rules files (*.rle)
   Data files (*.dat) - all applicable scenarios and years with data, Journals files (*.jlf) - all applicable scenarios and years with journal data
   Back up all of these files:
   Data Explorer grid files (*.hde), Web data grid files (*.xml), Web Data Entry Form files (*.wdf or *.grd), System Report files (*.rpt, *.xml, or *.html)
3. See EPM Backup and Recovery Guide for further information on this subject.

Documents mentioned in this article can be found on Enterprise Performance Management System Documentation website:
http://www.oracle.com/technetwork/middleware/performance-management/documentation/index.html