You are using Recovery Manager (RMAN) for backup and recovery operations with a
recovery catalog. You have been taken database backups every evening. On November 15,
2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally
dropped. On investigation, you found that the tablespace existed until 11:00 AM, and
important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed
to perform recovery are intact. In NOMOUNT state you restored the control file that has
information about the USER_DATA tablespace from the latest backup. Then you mounted
the database. Identify the next set of commands that are required to accomplish the task?
A.
Option A
B.
Option B
C.
Option C
D.
Option D
Why not B ?
We restored control file from backup, so we should use option USING BACKUP CONTROL FILE.
The question says “important transactions were done after that”, so if the tablespace USER_DATA does not exist, then we can only assume that these transactions were carried out on other tablespaces, and if they are important, then they cannot be lost (right?) i.e. we should not touch the other tablespaces. Correct me if I am wrong, but this all points to a TSPITR with its associated “auxillary instance” etc.