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

 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.

Answer: B

答案解析：

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

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

题中如果想对USERS表空间执行TSPITR，但是有一个外键约束在INDEX_TBS在这个表空间，可以将两个表空间一起做TSPITR。

选B.

If constraints for the tables in tablespace tbs1 are contained in tablespace tbs2, then you cannot recover tbs1 without also recovering tbs2.

Step 2: Determine the Recovery Set

Initially, your recovery set includes the data files for the tablespaces that you intend to recover. However, if objects in the tablespaces that you need have relationships (such as constraints) to objects in other tablespaces, then you must account for these relationships before you can perform TSPITR. You have the following choices when faced with such a relationship:

• Add the tablespace including the related objects to your recovery set

• Remove the relationship

• Suspend the relationship for the duration of TSPITR

Identify and Resolve Dependencies on the Primary Database

RMAN TSPITR requires that the tablespace be self-contained and that no SYS -owned objects reside in the tablespace. You can use theDBMS_TTS.TRANSPORT_SET_CHECK procedure to locate objects outside the tablespace and identify relationships between objects that span the recovery set boundaries. If the TRANSPORT_SET_VIOLATIONS view returns rows, you must investigate and correct the problem according to the choices mentioned earlier in this step.