Restoring the File Backup
To restore a database, replace the files on disk with the corresponding files from backup.The application should be stopped, unless you are restoring from an export file. In that case,ensure the application is not accepting client connections.
Restoring the Data Backup
➤ To reload exported data, use a tool:
| Tool | Topic | Location |
|---|---|---|
| Administration Services | Performing a Data Load or Dimension Build | Essbase Administration Services Online Help |
| ESSCMD | IMPORT | Essbase Technical Reference |
| MaxL | import data | Essbase Technical Reference |
| Calculation script | DATAIMPORTBIN (exported binary files only) | Essbase Technical Reference |
When you reload data that has been exported, the data is marked as input data. If you reload data exported from level 0 blocks or input blocks, you must recalculate the database after reloading. When Essbase recalculates the database, it recalculates every data block.
If you export all data in a database and then reload, Essbase marks all blocks in the database as input blocks. Consequently, if you try to clear data, no data is cleared because the database contains no non-input blocks.
When you reload data that has been exported, Essbase also marks the data blocks as dirty. If you had calculated the database prior to exporting it, to save time during the next calculation, you should set the status of the blocks as clean. If you had not calculated the database prior to exporting it, it is not necessary to set the status of the blocks as clean.
➤ To clean block status in a database after exporting all data and reloading, you can run the following calculation script:
Set ClearUpdateStatus Only;
Calc All;
Restoring Corrupted Databases
If there is a problem with any one of the following essential database files, the entire database becomes corrupted and Essbase Server cannot start the database:
● essn.pag
● essn.ind
● dbname.esm
● dbname.tct
● dbname.ind
To restore the database, delete these file, restart the database, and reload from data files or from export files backed up prior to the corruption.
0 comments:
Post a Comment