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.
This question is a little ambiguous. The answer is between answer A and “none of these answers are correct” depending on how you interpret “You cannot perform the TSPITR with the constraints enabled.” (Is that transporting with or without the other tablespace INDEX_TBS?)
I suggest reading …
http://oracle.su/docs/11g/backup.112/e10642/rcmtspit.htm#i1015064
here you can find the text …
Step 2: Determine the Recovery Set
Initially, your recovery set includes the datafiles for the tablespaces 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 will have to account for this relationship 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
Why is B not a right right answer?
Answer B is not correct because you do have other options, see my previous comment, hence the “must” in answer D is wrong.