Identify the next set of commands that are required to accomplish the task?

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?

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



Leave a Reply 0

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