nerdexam
Oracle

1Z0-034 · Question #110

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…

The correct answer is A. Option A. See the full explanation below for the reasoning.

Question

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?

Exhibit

1Z0-034 question #110 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(37 responses)
  • A
    84% (31)
  • B
    3% (1)
  • C
    11% (4)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-034 Practice