以TSPITR方式恢复表空间数据一例 - 数据库编程

^'\)\)$CONNECT_DATA=\(SID=xvBc$\)\) as sysdba\" point_in_time_recover=y tablespaces= TSPITR file= tspitr_a.dmp'; # shutdown clone before import shutdown clone immediate # import the tablespaces in the recovery set host 'imp userid =\"/@ as sysdba\" point_in_time_recover=y file= tspitr_a.dmp'; # online/offline the tablespace imported sql "alter tablespace TSPITR online"; sql "alter tablespace TSPITR offline"; # enable autobackups in case user does open resetlogs from RMAN after TSPITR sql 'begin dbms_backup_restore.AutoBackupFlag(TRUE); end;'; } executing Memory Script

Export: Release 10.2.0.1.0 - Production on Fri Dec 26 16:58:55 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options Export done in US7ASCII character set and AL16UTF16 NCHAR character set server uses ZHS16GBK character set (possible charset conversion) Note: table data (rows) will not be exported
About to export Tablespace Point-in-time Recovery objects... --执行导出TSPITR对象 For tablespace TSPITR ... . exporting cluster definitions . exporting table definitions . . exporting table T . . exporting table T1 --导出误删除的测试表 . exporting referential integrity constraints . exporting triggers . end point-in-time recovery Export terminated successfully without warnings. --导出完成无报错 host command complete
database closed database dismounted Oracle instance shut down

Import: Release 10.2.0.1.0 - Production on Fri Dec 26 16:59:17 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.02.01 via conventional path About to import Tablespace Point-in-time Recovery objects... import done in US7ASCII character set and AL16UTF16 NCHAR character set import server uses ZHS16GBK character set (possible charset conversion) . importing SYS's objects into SYS . importing ZLM's objects into ZLM . . importing table "T" . . importing table "T1" --导入误删除的测试表 . importing SYS's objects into SYS Import terminated successfully without warnings. host command complete
sql statement: alter tablespace TSPITR online
sql statement: alter tablespace TSPITR offline --最后一步操作是把要恢复的表空间offline的
sql statement: begin dbms_backup_restore.AutoBackupFlag(TRUE); end;
Removing automatic instance --删除自动化实例以及相关文件 Automatic instance removed auxiliary instance file /u01/aux/cntrl_tspitr_ORA10G_xvBc.f deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/datafile/o1_mf_system_b9t8nvw3_.dbf deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/datafile/o1_mf_undotbs1_b9t8nvx5_.dbf deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/datafile/o1_mf_temp_b9t8t370_.tmp deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/onlinelog/o1_mf_1_b9t8srrv_.log deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/onlinelog/o1_mf_2_b9t8svp8_.log deleted auxiliary instance file /u01/aux/TSPITR_ORA10G_XVBC/onlinelog/o1_mf_3_b9t8sy5v_.log deleted Finished recover at 26-DEC-14
RMAN> exit

Recovery Manager complete. [oracle@bak ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Dec 26 17:03:26 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> conn zlm/zlm@

以TSPITR方式恢复表空间数据一例(六)