Oracle 11G OCP 1Z0-053 268

（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1268140/，如需轉載，請註明出處，否則將追究法律責任。