OCP-1Z0-053-V12.02-191题

 

191.While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of

corrupted data into the database. Pablo has discovered this problem and he needs you to recover the

database to the point in time prior to the introduction of the corruption. The logical corruption was

introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to

use to restore the database to a point in time before the orruption?

A. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008

06:30:00'); alter database open;

B. restore database until time '06-SEP-2008 06:30:00'); recover database until time '06-SEP-2008

06:30:00'); alter database open resetlogs;

C. restore database until time '06-SEP-2008 18:29:55'); recover database until time '06-SEP-2008

18:29:55'); alter database open resetlogs;

D. restore database until time '06-SEP-2008 18:29:55'); alter database open resetlogs;

E. restore database until time '06-SEP-2008 18:29:55'); recover database; alter database open resetlogs;

Answer: C

答案解析：

C基于时间点的还原和恢复，最后使用resetlogs打开数据库。

这里需注意B和C的区别。