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 |