Tablespace point-in-time recovery (TSPITR) is enhanced as follows:
-
You now have the ability to recover a dropped tablespace.
-
TSPITR can be repeated multiple times for the same tablespace. Previously, once a tablespace had been recovered to an earlier point-in-time, it could not be recovered to another earlier point-in-time.
-
DBMS_TTS.TRANSPORT_SET_CHECK is automatically run to ensure that TSPITR is successful.
-
AUXNAME is no longer used for recovery set data files.
This feature improves usability with TSPITR.
實驗過程:http://www.oracledatabase12g.com/archives/11g-enhanced-tablespace-point-in-time-recover.html