053-367

Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in
that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement is true?
A. You cannot perform the TSPITR with the constraints enabled.
B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
C. You can perform TSPITR only on the USERS tablespace.
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it
automatically.
E. The TSPITR will only be successful if the constraint is enabled.

  If there is a constraint between tow objects in two different tablespaces,you must perform a TSPITR between the two tablespaces.As an alternative,you could disable or drop the constraint.You may not be able to reenable the constraint with validation after the TSPITR,however.

注:TSPITR基于时间点的表空间恢复tablespace point in time recover

posted @ 2017-11-13 14:09  巴啦啦大魔王  阅读(93)  评论(0编辑  收藏  举报