Oracle
1Z0-043 · Question #25
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the…
The correct answer is A. take data files from the read-only tablespace offline before performing a recovery. See the full explanation below for the reasoning.
Question
You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider?
Options
- Atake data files from the read-only tablespace offline before performing a recovery
- Brecovery using backup control file is not possible, so restore all the files from the last full database
- Cdrop the read-only tablespace and re-create the tablespace after recovery
- Dperform a recovery; status of the tablespace in control file will be changed automatically
How the community answered
(27 responses)- A81% (22)
- B4% (1)
- C11% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.