Oracle
1Z0-063 · Question #137
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 B. All the read-only tablespaces should be restored separately. See the full explanation below for the reasoning.
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
(30 responses)- A3% (1)
- B73% (22)
- C17% (5)
- D7% (2)
Community Discussion
No community discussion yet for this question.