A complete recovery mounted database b complete

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: ery scenario do you choose? A. Complete recovery - mounted database. B. Complete recovery - opened database, initially opened. C. Complete recovery - opened database, initially closed. D. You cannot recover from the corruption of a database file belonging to the SYSTEM tablespace except by going back to the last full backup. Answer: D Explanation: The loss of SYSTEM tablespace datafiles or datafiles from tablespaces containing rollback segments may cause Oracle to stop running. In this situation, full recovery using backup copies of all database files is required. The database cannot be open during recovery. Media failure will most likely be accompanied by disk failure, which you will need to have fixed. Incorrect Answers: A: You cannot do in this situation complete recovery for mounted database. B: You cannot do in this situation complete recovery for opened database: loss or damage of SYSTEM tablespace may not allow to Oracle instance to open the database. C: You cannot do in this situation complete recovery for...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online