表空间时间点恢复练习

最新推荐文章于 2024-10-02 00:27:17 发布

clbvxg9858

最新推荐文章于 2024-10-02 00:27:17 发布

阅读量82

点赞数

文章标签：数据库

表空间时间点(TSPITR)恢复步骤

1: alter tablespace test read only;
SQL> select * from test.t_date1;

C1 C2
---------- -------------------
714924 2006-12-21 13:34:36
715098 2006-12-21 13:35:39
715103 2006-12-21 13:35:51
715104 2006-12-21 13:35:54
2: exp parfile=exp
C:Documents and Settingsgjl>exp parfile=E:dbdataexpexpara.sql

Export: Release 9.2.0.1.0 - Production on Thu Dec 21 10:52:54 2006

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
EXP-00008: ORACLE error 1001 encountered
ORA-01001: invalid cursor
ORA-06512: at "SYS.DBMS_SYS_SQL", line 819
ORA-06512: at "SYS.DBMS_SQL", line 19
ORA-06512: at "SYS.DBMS_TTS", line 774
ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_PLUGTS", line 1093
ORA-06512: at line 1
EXP-00000: Export terminated unsuccessfully

--临时表空间数据文件没有加载修改
select *
from dba_temp_files;

C:Documents and Settingsgjl>exp parfile=E:dbdataexpexpara.sql

Export: Release 9.2.0.1.0 - Production on Thu Dec 21 13:20:33 2006

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses AL32UTF8 character set (possible charset conversion)
Note: table data (rows) will not be exported
About to export transportable tablespace metadata...
For tablespace TEST ...
. exporting cluster definitions
. exporting table definitions
. . exporting table T_DATE1
. . exporting table T_DATE2
. exporting referential integrity constraints
. exporting triggers
. end transportable tablespace metadata export
Export terminated successfully without warnings.

3: copy tablespace datafile;

4: alter tablespace test read write;

5: dml............
SQL> select * from test.t_date1;

C1 C2
---------- -------------------
714924 2006-12-21 13:34:36
715098 2006-12-21 13:35:39
715103 2006-12-21 13:35:51
715104 2006-12-21 13:35:54
715819 2006-12-21 13:40:15
715903 2006-12-21 13:40:28

6: drop tablespace test including contents and datafiles;

7: imp parfile=imp
C:Documents and Settingsgjl>imp parfile=E:dbdataexpimpara.sql

Import: Release 9.2.0.1.0 - Production on Thu Dec 21 13:43:16 2006

Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

Export file created by EXPORT:V09.02.00 via conventional path
About to import transportable tablespace(s) metadata...
import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing SYS's objects into SYS
. importing TEST's objects into TEST
. . importing table "T_DATE1"
. . importing table "T_DATE2"
Import terminated successfully without warnings.
SQL> select * from test.t_date2;

C1 C2
---------- -------------------
714924 2006-12-21 13:34:36
715098 2006-12-21 13:35:39
715103 2006-12-21 13:35:51
715104 2006-12-21 13:35:54

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/45259/viewspace-134910/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/45259/viewspace-134910/