Why should you back up a duplicated tablespace after a TSPITR is complete?
A.
The tablespace cannot be duplicated or restored to any point in time after the duplication.
B.
The tablespace cannot be duplicated or restored to the point in time before the
duplication.
C.
The entire database cannot be restored after a TSPITR, so a backup is required.
D.
You cannot bring the tablespace online until its been backed up.
E.
There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.
Justification:
Assume that you run TSPITR on a tablespace, and then bring the tablespace online at time t. Backups of the tablespace created before time t are no longer usable for recovery with a current control file. You cannot run TSPITR again on this tablespace to recover it to any time less than or equal to time t, nor can you use the current control file to recover the database to any time less than or equal to t. Therefore, you must back up the recovered tablespace as soon as TSPITR is complete.
@noe, your justification is quite clear and very likely completely true, however I do have one problem with it in that it is somewhat outdated, I found it in the 10g documentation.
Please note that the version of oracle exam-ed in IZO-053 is 11.2.0.1 as stated here
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Therefore please refer to the 11.2.0.1 documentation found in
http://oracle.su/docs/11g/nav/portal_booklist.htm
I suggest reading …
http://oracle.su/docs/11g/backup.112/e10642/rcmtspit.htm#CHDHBAFJ
In the section titled “Limitations of TSPITR”
you can see the text …
If you run TSPITR on a tablespace and bring the tablespace online at time t, then backups of the tablespace created before time t are no longer usable for recovery with a current control file.
You cannot use the current control file to recover the database to any time less than or equal to t.
although granted, this is somewhat ambiguous …
Although I will say that it is possible to run TSPITR multiple on the same tablespace only if you use an RC.
B and C are correct answers. I would choose C as the whole database is more relevant then just one tablespace.