In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?
A.
The datafiles have an ONLINE status.
B.
The datafiles have an OFFLINE status.
C.
The datafiles have an ONLINE status and are in hot backup mode prepared for an online
backup.
D.
The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
E.
The datafiles are in STANDBY mode.
Correct answer is B:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmtspit.htm#BRADV374
“The recovery set tablespaces are left offline for you to back up and then bring back online.”
Tasks to Perform After Successful TSPITR
If TSPITR completes successfully, you must back up the recovered tablespaces, and then you can bring them online.
True