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.



Leave a Reply 13

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


feedback

feedback

To avoid these problems, use current control files rather than backups to recover the database. If you must use a backup control file, then you can also avoid this problem if the read-only tablespace has not suffered a media failure. You have the following alternatives for recovering read-only and slow media when using a backup control file:

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

aamir

aamir

I have one question!
In the real exam they will consider our right answers as right or they will consider their wrong answers as right.

Becuase in many dumps mostly answers are wrong.

Thanks,

aamir

aamir

Please answer my question, these wrong answers making me crazy.
They are selecting so much clear wrong answer.

Tim

Tim

The answers in the dumps are not from Oracle.
Just somebody answered it with more or less oracle skills. Most time less skills…