OCP-1Z0-053-V12.02-16题_because of a logical corruption in your production-优快云博客

本文链接：https://blog.youkuaiyun.com/rlhua/article/details/13747047

本文讨论了在执行表空间时间点恢复(TSPITR)时如何避免丢失创建于目标恢复时间之后的对象。通过在TSPITR之前使用Data Pump Export导出这些对象并在恢复后重新导入的方法，可以有效地解决这一问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

16.Because of a logical corruption in your production database, you wanted to perform Tablespace Point

in Time Recovery (TSPITR). But before you start the recovery, you queried the

TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that

would be dropped when you start the recovery by using this method. You want to preserve these objects.

Which option must you use to perform TSPITR and preserve the object?

A. Perform Export before TSPITR and Import after TSPITR

B. Move objects to another schema that has the same tablespace assigned

C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)

D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV89795

When you perform RMAN TSPITR on a tablespace, objects created after the target recovery time are lost. You can preserve such objects after they are identified by exporting them before TSPITR with the Data Pump Export utility and reimporting them afterward with Data Pump Import.

To determine which objects are lost in TSPITR, query the TS_PITR_OBJECTS_TO_BE_DROPPED view on the primary database.