What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

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.

Leave a Comment