TSPITR(基于时间点的表空间恢复)(二)
EST_XDFA/datafile/o1_mf_temp_8g4nccog_.tmp deleted
auxiliary instance file /u01/tspitr/TSPITR_TEST_XDFA/onlinelog/o1_mf_1_8g4nbywr_.log deleted
auxiliary instance file /u01/tspitr/TSPITR_TEST_XDFA/onlinelog/o1_mf_2_8g4nc1q3_.log deleted
auxiliary instance file /u01/tspitr/TSPITR_TEST_XDFA/onlinelog/o1_mf_3_8g4nc49y_.log deleted
Finished recover at 2013-01-01 11:02:10
将表空间tspitr online, 检查表tspitr的数据是否找回来.
SQL> alter tablespace TSPITR_TBS online;
Tablespace altered.
SQL> select count(*) from tspitr;
COUNT(*)
----------
50324
记录一条也没有丢的回来了。表明顺利成功!!