1Z0-067 · Question #95
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on…
The correct answer is A. All the read-only tablespaces should be taken offline. Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery.
Question
In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file. What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
Options
- AAll the read-only tablespaces should be taken offline.
- BAll the read-only tablespaces should be restored separately.
- CAll the read-only tablespaces should be renamed to have the MISSINGnnnn format.
- DAll the read-only tablespaces should be made online with logging disabled.
How the community answered
(44 responses)- A80% (35)
- B11% (5)
- C2% (1)
- D7% (3)
Explanation
Take data files from read-only tablespaces offline before doing recovery with a backup control file, and then bring the files online at the end of media recovery.
Topics
Community Discussion
No community discussion yet for this question.