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

642.In your production database, users report that they are unable to generate reports on an important

table because it does not contain any data. While investigating the reason, you realize that another user

executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want

to recover the lost data of the table without affecting objects in other schemas.

Which method must you use to recover the lost data?

A. Complete Recovery with online redo log

B. Complete Recovery with archived redo log

C. Tablespace Point-in-Time Recovery (TSPITR)

D. Incomplete Recovery with system change number (SCN)

Answer: C

答案解析：

参考：http://blog.csdn.net/rlhua/article/details/12659769

题问：因为执行了 TRUNCATE TABLE命令导致表中数据丢失，怎么恢复而不会影响别的schemas？

使用RMAN 自动表空间时间点恢复(TSPITR) 可将Oracle DB 中的一个或多个表空间快速恢复到以前的某个时间，而不会影响数据库中其它表空间和对象的状态。