Which six files are involved in database recovery for block storage option after a database crash?
Correct Answer: A,B,E,F,G,H
Explanation/Reference:
If there is a problem with any one of these essential database files, the entire database becomes corrupted and Essbase Server cannot start the database:
* essn.pag (A)
* essn.ind (B)
* dbname.esm (E)
* dbname.tct (F)
* dbname.ind (G)
* dbname.otl (for block storage databases) (H): Outline file, which stores all metadata for a database and defines how data is stored, but does not store data itself To restore the database, delete these file, restart the database, and reload from data files or from export files backed up before the corruption.
Reference: Hyperion, Backup and Recovery Guide
Using Backup and Restore for Block Storage Databases