（268）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.RMAN> run

{

SET UNTIL TIME 'Nov 15 2007 11:00:00';

RESTORE DATABASE;

RECOVER DATABASE;

}

B.RMAN> run

{

SET UNTIL TIME 'Nov 15 2007 11:00:00';

RESTORE DATABASE;

RECOVER DATABASE USING BACKUP CONTROLFILE;

}

C.RMAN> run

{

RESTORE DATABASE;

RECOVER DATABASE UNTIL TIME 'Nov 15 2007 11:00:00';

}

D.RMAN> run

{

RESTORE TABLESPACE user_data;

RECOVER TABLESPACE user_data UNTIL TIME 'Nov 15 2007 11:00:00';

}

答案：（A）

解析：

常规，当还原控制文件后，需要recover database using backup control file

ITPub博客

Oracle 11G OCP 1Z0-053 268