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