1Z0-531 · Question #25
Which six files are involved in database recovery for block storage option after a database crash?
The correct answer is A. Essn.pag ?data B. Essn.ind ?index E. Dbname.esm - kernel file that contains control information for db recovery F. Dbname.tct - transaction control table G. Dbname.ind - free fragment file for data and index free fragments H. DBname.otl. 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: dbname.esm (E) dbname.tct (F) dbname.ind (G) dbname.otl (for block storage databases) (H): Outline file, which stores all…
Question
Which six files are involved in database recovery for block storage option after a database crash?
Options
- AEssn.pag ?data
- BEssn.ind ?index
- CEssn.dat
- DTemp.dat
- EDbname.esm - kernel file that contains control information for db recovery
- FDbname.tct - transaction control table
- GDbname.ind - free fragment file for data and index free fragments
- HDBname.otl
How the community answered
(40 responses)- A83% (33)
- C5% (2)
- D13% (5)
Explanation
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: * 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. Using Backup and Restore for Block Storage Databases
Topics
Community Discussion
No community discussion yet for this question.