Saturday, 19 October 2019

Which six files are involved in database recovery for block storage option after a database crash?

    Which six files are involved in database recovery for block storage option after a database crash? 

    A. Essn.pag 
    B.
    Essn.ind
    C. Essn.dat
    D. Temp.dat
    E. Dbname.esm
    F. Dbname.tct
    G. Dbname.ind

    H. DBname.otl
    I. Metadata folder 

     

    Correct Answer: ABEFGH
    Explanation/Reference:

    Tip : BSO cubes store data in the form of .pag files, ASO Cubes store data in the form of .dat files. So C&D can not be the answer.

    Answer is available at the below two references,

    Book - Look Smarter than you are with Hyperion Essbase 11.1.2 Page # 509
    Link - Using Backup and Restore for Block Storage Databases  https://docs.oracle.com/cd/E57185_01/EPMBK/ch04s01s02s02.html

Connect Direct

One point to note below is node_id is for the Unix/Linux server file irrespective of whether it is at source or destination, for Mainframe o...