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.
After you perform a TSPITR,you should back up the tablespace/datafile.If you do not,you will not be able to do a TSPITR to any point in time before the original TSPITR.
执行完全自动执行的 TSPITR
1. 配置在目标实例上执行 TSPITR 所需的通道。
2. 使用 AUXILIARY DESTINATION 选项指定辅助目标。
RMAN> CONNECT TARGET
RMAN> RECOVER TABLESPACE users, example
> UNTIL TIME '2007-06-29:08:00:00'
> AUXILIARY DESTINATION
> '/u01/app/oracle/oradata/aux';
3. 备份恢复的表空间并使它们联机。
RMAN>BACKUP TABLESPACE users, example;
RMAN> SQL "ALTER TABLESPACE users, example ONLINE";
执行完全自动执行的 TSPITR 时,还必须:
• 配置在目标实例上执行 TSPITR 所需的任何通道
• 指定 RMAN 用于数据文件辅助集和其它辅助实例文件的目标
在 TSPITR 完成之后,备份恢复的表空间并使它们联机。执行 TSPITR 之后,不能使用
TSPITR 之前创建的参与执行 TSPITR 的表空间的备份。