Oracle Database 12c: Advanced Administration — Question 75

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?

Answer options

• A. All the read-only tablespaces should be taken offline.
• B. All the read-only tablespaces should be restored separately.
• C. All the read-only tablespaces should be renamed to have the MISSING nnnn format.
• D. All the read-only tablespaces should be made online with logging disabled.

Correct answer: B

Explanation

Option B is correct because read-only tablespaces must be restored separately to ensure data integrity during the recovery process. The other options either suggest actions that are not necessary or could lead to issues, such as taking them offline or renaming them, which are not required for an incomplete recovery.