Couchman p 721 chapter 15 advanced topics in data

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: dvanced Topics in Data Recovery QUESTION 76: Which three files should be backed up for a closed database backup? (Choose two) A. Data B. Alert C. Control D. Password Answer: A, C, D Explanation: Data, control and password files need to be backed up for a closed database backup. Incorrect Answers: B: Alert file does not need to be backed up during a closed database backup. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 574-594 Chapter 12: Overview of Backup and Recovery QUESTION 77: The instance crashed after the current online redo-log becomes corrupt. Which action can the DBA take to open the database? A. Perform a tablespace recovery. B. Recover the SYSTEM tablespace. C. Perform a complete recovery of the database. D. Skip recovery and open the database with the RESETLOGS option. E. Perform a time-based recovery that stops at the time that the current online redo-log became corrupt. Answer: E Explanation: To fix problem with corrupted current online redo log file after instance crash you need to perform a time-based recovery that stops at the time that the current online redo log became corrupt and open the database after that. Incorrect Answers: A: A time-b...
View Full Document

Ask a homework question - tutors are online