Essbase Backup and Recovery

Backup

To prevent data loss we use backup and recovery. You take of backup of data base so that when any miss happening accord. You can get back your data. There are many type of database backup.

Types of backup

1)     Hot Backup: - Perform backup while server is up and running mode.

2)     Cold Backup: - Perform backup while server is not in running mode.

File System Backup Types

A complete file system backup includes an entire system directory. For example, backing up the Hyperion home directory backs up all installed EOM system Products. You can also perform file system backup of these types and frequencies:

1. Post installation - Directories created or modified if you reconfigure products
2. Daily incremental - New directories or files or those modified those modified since the previous day
3. Weekly full- All files in the directories for which you perform daily incremental backups
4. As needed - Data that is modified infrequently

 Common Backup

1. Preparing for Backup: - Server required to be prepared for performing backup. Server should be in read only mode or it should be in idle mode. 

2. Database Backup: - First take backup of database files. You must take database backup in form of text file or other database form. 

3. File System Backup: - Secondary you should have backup of all supporting files. It is difficult to recover database without supporting files like outline files. Rule files or index file.

 Steps for taking backup

You should fallow fallowing steps for performing backup operation.

1)     Server should be in Read-Only mode.

2)     Perform backup operation.

3)     Revert back server in to Read-Write mode.