--验证结果
[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恢复完成。 |