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
执行RMAN的表空间不完全恢复-TSPITR,目标恢复时间后创建的对象将丢失。
可以在不完全恢复之前导出并在不完全恢复之后导入这此对象。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2120414/
,如需转载,请注明出处,否则将追究法律责任。