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?
Question:
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?
Options:
All the read-only tablespaces should be taken offline.
All the read-only tablespaces should be restored separately.
All the read-only tablespaces should be renamed to have the MISSING nnnn format.
All the read-only tablespaces should be made online with logging disabled.
Correct Answer
The Correct Answer for this Question is
All the read-only tablespaces should be restored separately.