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?

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?

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 MISSINGnnnn format.

D.
All the read-only tablespaces should be made online with logging disabled.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


yogui

yogui

A

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.