Oracle 表空间基于时间点恢复TSPITR

郑全

--验证结果

[oracle@dbserver ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.5.0 - Production on Fri May 9 18:29:46 2014

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

SQL> connect sztech/sztech

Connected.

SQL> select * from ttest;

select * from ttest

              *

ERROR at line 1:

ORA-00376: file 8 cannot be read at this time

ORA-01110: data file 8: '/u01/app/oracle/oradata/orcl/ts_sztech.dba'

表空间已经离线了，需要在线

SQL> conn / as sysdba

Connected.

SQL> alter tablespace TS_SZTECH online；

再次执行

SQL> conn sztech/sztech

Connected.

SQL> select * from ttest;

      I_ID C_NAME

---------- ----------

         1 1

         2 2

         3 3

         4 4

         5 5

         6 6

         7 7

         8 8

         8 9

        10 10

        11 11

11 rows selected.

到此，tspitr恢复完成。