C make the tablespace locally managed d after the

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: ly-managed. D. After the tablespace to become read-only. Answer: B Explanation: There is only one complex recovery situation for read-only tablespaces. This is when youir read-only tablespace experiences media failure, and the backup you have was taken when the tablespace was in read-write state. In order to manage this recovery, you must first recover the tablespace from backups taken when it was a writable tablespace and apply redo logs to update the objects in that tablespace up to point when the tablespace was made read-only. Then, you can change the tablespace state to read-only. A DBA needs to do complete media recovery if restores a read-only tablespace from a backup taken BEFORE the tablespace was made read-only. Incorrect Answers: A: A DBA does not need to recreate the control file in this case. C: A DBA does not need to make the tablespace locally managed in this case. D: A DBA can use the tablespace BEFORE it became read-only. Actualtests.com - The Power of Knowing 1Z0-025 Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 721 Chapter 15: A...
View Full Document

Ask a homework question - tutors are online