Which of the following restrictions are NOT true with respect to tablespace point-in-time
recovery? (Choose all that apply.)
A.
The target database must be in NOARCHIVELOG mode.
B.
No backup is required of the database before you perform a TSPITR.
C.
You must have all archived redo logs generated since the last backup up to the point to
which you want to restore the transport set.
D.
If you rename a tablespace, you can not perform a TSPITR to any point in time before
that rename operation occurred.
E.
If you have tables in tablespace_1 that have associated constraints in tablespace_2, then
you must transport both tablespaces.
A: False (so CORRECT answer)
You cannot perform TSPITR if you do not have archived redo logs or if the database runs in NOARCHIVELOG mode.
B: False (so CORRECT asnwer)
C: True (so WRONG answer)
D: True (so WRONG answer)
You cannot recover a renamed tablespace to a point in time before it was renamed. If you try to perform a TSPITR to an SCN earlier than the rename operation, then RMAN cannot find the new tablespace name in the repository as of that earlier SCN (because the tablespace did not have that name at that SCN).
In this situation, you must recover the entire database to a point in time before the tablespace was renamed. The tablespace will be found under the name it had at that earlier time.
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtspit.htm#BRADV89790
E: True (so WRONG answer)
If the constraints for the tables in tablespace tbs1 are contained in tablespace tbs2, then you cannot recover tbs1 without recovering tbs2 as well.
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtspit.htm#BRADV89790