DATABASE 12C 新功能rman RECOVER TABLE

柔光的暖阳◎ 2022-08-19 04:55 13阅读 0赞

RECOVER TABLE 命令在 12C 中是一个新功能，它可以针对于表及表分区按时间点进行恢复。 表可以被恢复至辅助库中，并且可以有下面的选择：

*  使用 REMAP 选项将表恢复至一个新表或者分区中。
 *  只生成一个需要被恢复表的 expdp 格式的 dump 文件，选择后期再进行恢复。

必要条件：

*  目标数据库必须被置于读写模式。
 *  目标数据库必须被置于归档模式。
 *  如果要恢复表或者分区，你必须拥有这些表或者分区存在后的时间的备份。
 *  想要恢复单个表分区， COMPATIBLE 初始化参数所在的目标库必须设置为 11.1.0 或以上。

设置想要恢复的表和表分区的时间点：  
  
选项：

*  SCN
 *  Time
 *  归档序列号

SMEDS 下的表 RECTEST 被恢复到新表 MEDS.TEST4\_RECTEST。  
辅助实例的数据文件将被恢复至'/testcases/SR3-6629539201/rectbl'。

% rman target sys/oracle@t12ccdb log recover\_table5.log  
RMAN> RECOVER TABLE SMEDS."RECTEST" OF PLUGGABLE DATABASE T12CPDB1  
          UNTIL SEQUENCE 64 thread 1  
          AUXILIARY DESTINATION '/testcases/SR3-6629539201/rectbl'  
          REMAP TABLE 'SMEDS'.'RECTEST':'TEST4\_RECTEST';

Starting recover at 21-JAN-13  
allocated channel: ORA\_DISK\_1  
channel ORA\_DISK\_1: SID=16 device type=DISK  
RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time  
  
List of tablespaces expected to have UNDO segments  
Tablespace SYSTEM  
Tablespace UNDOTBS1  
  
Creating automatic instance, with SID='naxj'  
  
initialization parameters used for automatic instance:  
db\_name=T12CCDB  
db\_unique\_name=naxj\_pitr\_T12CCDB  
compatible=12.0.0.0.0  
db\_block\_size=8192  
db\_files=200  
sga\_target=1G  
processes=80  
db\_create\_file\_dest=/testcases/SR3-6629539201/rectbl  
log\_archive\_dest\_1='location=/testcases/SR3-6629539201/rectbl'  
\_enable\_pluggable\_database=true  
\_clone\_one\_pdb\_recovery=true  
\#No auxiliary parameter file used  
  
  
starting up automatic instance T12CCDB  
  
Oracle instance started  
  
Total System Global Area    1068937216 bytes  
  
Fixed Size                     2268624 bytes  
Variable Size                281018928 bytes  
Database Buffers             780140544 bytes  
Redo Buffers                   5509120 bytes  
Automatic instance created  
  
contents of Memory Script:  
\{  
\# set requested point in time  
set until  logseq 64 thread 1;  
\# restore the controlfile  
restore clone controlfile;  
\# mount the controlfile  
sql clone 'alter database mount clone database';  
\# archive current online log  
sql 'alter system archive log current';  
\}  
executing Memory Script  
  
executing command: SET until clause  
  
Starting restore at 21-JAN-13  
allocated channel: ORA\_AUX\_DISK\_1  
channel ORA\_AUX\_DISK\_1: SID=109 device type=DISK  
  
channel ORA\_AUX\_DISK\_1: starting datafile backup set restore  
channel ORA\_AUX\_DISK\_1: restoring control file  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/autobackup/2013\_01\_21/o1\_mf\_s\_805312613\_8hv0c5yz\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/autobackup/2013\_01\_21/o1\_mf\_s\_805312613\_8hv0c5yz\_.bkp tag=TAG20130121T175653  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
output file name=/testcases/SR3-6629539201/rectbl/T12CCDB/controlfile/o1\_mf\_8hv7z47y\_.ctl  
Finished restore at 21-JAN-13  
  
sql statement: alter database mount clone database  
  
sql statement: alter system archive log current  
  
contents of Memory Script:  
\{  
\# set requested point in time  
set until  logseq 64 thread 1;  
\# set destinations for recovery set and auxiliary set datafiles  
set newname for clone datafile  1 to new;  
set newname for clone datafile  4 to new;  
set newname for clone datafile  3 to new;  
set newname for clone datafile  8 to new;  
set newname for clone datafile  9 to new;  
set newname for clone tempfile  1 to new;  
set newname for clone tempfile  3 to new;  
\# switch all tempfiles  
switch clone tempfile all;  
\# restore the tablespaces in the recovery set and the auxiliary set  
restore clone datafile  1, 4, 3, 8, 9;  
switch clone datafile all;  
\}  
executing Memory Script  
  
executing command: SET until clause  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
executing command: SET NEWNAME  
  
renamed tempfile 1 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_temp\_%u\_.tmp in control file  
renamed tempfile 3 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_temp\_%u\_.tmp in control file  
  
Starting restore at 21-JAN-13  
using channel ORA\_AUX\_DISK\_1  
  
channel ORA\_AUX\_DISK\_1: starting datafile backup set restore  
channel ORA\_AUX\_DISK\_1: specifying datafile(s) to restore from backup set  
channel ORA\_AUX\_DISK\_1: restoring datafile 00001 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: restoring datafile 00004 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_undotbs1\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: restoring datafile 00003 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: restoring datafile 00008 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: restoring datafile 00009 to /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_nnndf\_TAG20130121T175546\_8hv092yj\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_nnndf\_TAG20130121T175546\_8hv092yj\_.bkp tag=TAG20130121T175546  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:01:25  
Finished restore at 21-JAN-13  
  
datafile 1 switched to datafile copy  
input datafile copy RECID=55 STAMP=805320511 file name=/testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_8hv7zblx\_.dbf  
datafile 4 switched to datafile copy  
input datafile copy RECID=56 STAMP=805320511 file name=/testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_undotbs1\_8hv7zbob\_.dbf  
datafile 3 switched to datafile copy  
input datafile copy RECID=57 STAMP=805320512 file name=/testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_8hv7zbn2\_.dbf  
datafile 8 switched to datafile copy  
input datafile copy RECID=58 STAMP=805320512 file name=/testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_8hv7zbnt\_.dbf  
datafile 9 switched to datafile copy  
input datafile copy RECID=59 STAMP=805320512 file name=/testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_8hv7zbn7\_.dbf  
  
contents of Memory Script:  
\{  
\# set requested point in time  
set until  logseq 64 thread 1;  
\# online the datafiles restored or switched  
sql clone "alter database datafile  1 online";  
sql clone "alter database datafile  4 online";  
sql clone "alter database datafile  3 online";  
sql clone 'T12CPDB1' "alter database datafile  8 online";  
sql clone 'T12CPDB1' "alter database datafile  9 online";  
\# recover and open database read only  
recover clone database tablespace  "SYSTEM", "UNDOTBS1", "SYSAUX", "T12CPDB1":"SYSTEM", "T12CPDB1":"SYSAUX";  
sql clone 'alter database open read only';  
\}  
executing Memory Script  
  
executing command: SET until clause  
  
sql statement: alter database datafile  1 online  
sql statement: alter database datafile  4 online  
sql statement: alter database datafile  3 online  
sql statement: alter database datafile  8 online  
sql statement: alter database datafile  9 online  
  
Starting recover at 21-JAN-13  
using channel ORA\_AUX\_DISK\_1  
  
starting media recovery  
  
channel ORA\_AUX\_DISK\_1: starting archived log restore to default destination  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=58  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T175652\_8hv0c4bf\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T175652\_8hv0c4bf\_.bkp tag=TAG20130121T175652  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_58\_804254048.dbf thread=1 sequence=58  
channel ORA\_AUX\_DISK\_1: starting archived log restore to default destination  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=59  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=60  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=61  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=62  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=63  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T200313\_8hv7r1hz\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T200313\_8hv7r1hz\_.bkp tag=TAG20130121T200313  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_59\_804254048.dbf thread=1 sequence=59  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_60\_804254048.dbf thread=1 sequence=60  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_61\_804254048.dbf thread=1 sequence=61  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_62\_804254048.dbf thread=1 sequence=62  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_63\_804254048.dbf thread=1 sequence=63  
media recovery complete, elapsed time: 00:00:05  
Finished recover at 21-JAN-13  
  
sql statement: alter database open read only  
  
contents of Memory Script:  
\{  
sql clone 'alter pluggable database  T12CPDB1 open read only';  
\}  
executing Memory Script  
  
sql statement: alter pluggable database  T12CPDB1 open read only  
  
contents of Memory Script:  
\{  
   sql clone "create spfile from memory";  
   shutdown clone immediate;  
   startup clone nomount;  
   sql clone "alter system set  control\_files = ''/testcases/SR3-6629539201/rectbl/T12CCDB/controlfile/o1\_mf\_8hv7z47y\_.ctl'' comment=''RMAN set'' scope=spfile";  
   shutdown clone immediate;  
   startup clone nomount;  
\# mount database  
sql clone 'alter database mount clone database';  
\}  
executing Memory Script  
  
sql statement: create spfile from memory  
  
database closed  
database dismounted  
Oracle instance shut down  
  
connected to auxiliary database (not started)  
Oracle instance started  
  
Total System Global Area    1068937216 bytes  
  
Fixed Size                     2268624 bytes  
Variable Size                285213232 bytes  
Database Buffers             775946240 bytes  
Redo Buffers                   5509120 bytes  
  
sql statement: alter system set  control\_files =''/testcases/SR3-6629539201/rectbl/T12CCDB/controlfile/o1\_mf\_8hv7z47y\_.ctl'' comment= ''RMAN set'' scope=spfile  
  
Oracle instance shut down  
  
connected to auxiliary database (not started)  
Oracle instance started  
  
Total System Global Area    1068937216 bytes  
  
Fixed Size                     2268624 bytes  
Variable Size                285213232 bytes  
Database Buffers             775946240 bytes  
Redo Buffers                   5509120 bytes  
  
sql statement: alter database mount clone database  
  
contents of Memory Script:  
\{  
\# set requested point in time  
set until  logseq 64 thread 1;  
\# set destinations for recovery set and auxiliary set datafiles  
set newname for datafile  20 to new;  
\# restore the tablespaces in the recovery set and the auxiliary set  
restore clone datafile  20;  
switch clone datafile all;  
\}  
executing Memory Script  
  
executing command: SET until clause  
  
executing command: SET NEWNAME  
  
Starting restore at 21-JAN-13  
allocated channel: ORA\_AUX\_DISK\_1  
channel ORA\_AUX\_DISK\_1: SID=115 device type=DISK  
  
channel ORA\_AUX\_DISK\_1: starting datafile backup set restore  
channel ORA\_AUX\_DISK\_1: specifying datafile(s) to restore from backup set  
channel ORA\_AUX\_DISK\_1: restoring datafile 00020 to /testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/datafile/o1\_mf\_rectbl\_%u\_.dbf  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_nnndf\_TAG20130121T175546\_8hv092yj\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_nnndf\_TAG20130121T175546\_8hv092yj\_.bkp tag=TAG20130121T175546  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:03  
Finished restore at 21-JAN-13  
  
datafile 20 switched to datafile copy  
input datafile copy RECID=61 STAMP=805320570 file name=/testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/datafile/o1\_mf\_rectbl\_8hv83qpg\_.dbf  
  
contents of Memory Script:  
\{  
\# set requested point in time  
set until  logseq 64 thread 1;  
\# online the datafiles restored or switched  
sql clone 'T12CPDB1' "alter database datafile  20 online";  
\# recover and open resetlogs  
recover clone database tablespace  "T12CPDB1":"RECTBL", "SYSTEM", "UNDOTBS1", "SYSAUX", "T12CPDB1":"SYSTEM", "T12CPDB1":"SYSAUX" delete archivelog;  
alter clone database open resetlogs;  
\}  
executing Memory Script  
  
executing command: SET until clause  
  
sql statement: alter database datafile  20 online  
  
Starting recover at 21-JAN-13  
using channel ORA\_AUX\_DISK\_1  
  
starting media recovery  
  
channel ORA\_AUX\_DISK\_1: starting archived log restore to default destination  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=58  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T175652\_8hv0c4bf\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T175652\_8hv0c4bf\_.bkp tag=TAG20130121T175652  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_58\_804254048.dbf thread=1 sequence=58  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_58\_804254048.dbf RECID=131 STAMP=805320572  
channel ORA\_AUX\_DISK\_1: starting archived log restore to default destination  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=59  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=60  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=61  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=62  
channel ORA\_AUX\_DISK\_1: restoring archived log  
archived log thread=1 sequence=63  
channel ORA\_AUX\_DISK\_1: reading from backup piece /bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T200313\_8hv7r1hz\_.bkp  
channel ORA\_AUX\_DISK\_1: piece handle=/bugmnt17/em/celclnx14/SR3.5377673271/app/oracle/fast\_recovery\_area/T12CCDB/backupset/2013\_01\_21/o1\_mf\_annnn\_TAG20130121T200313\_8hv7r1hz\_.bkp tag=TAG20130121T200313  
channel ORA\_AUX\_DISK\_1: restored backup piece 1  
channel ORA\_AUX\_DISK\_1: restore complete, elapsed time: 00:00:01  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_59\_804254048.dbf thread=1 sequence=59  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_59\_804254048.dbf RECID=133 STAMP=805320573  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_60\_804254048.dbf thread=1 sequence=60  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_60\_804254048.dbf RECID=134 STAMP=805320573  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_61\_804254048.dbf thread=1 sequence=61  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_61\_804254048.dbf RECID=132 STAMP=805320573  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_62\_804254048.dbf thread=1 sequence=62  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_62\_804254048.dbf RECID=136 STAMP=805320573  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_63\_804254048.dbf thread=1 sequence=63  
channel clone\_default: deleting archived log(s)  
archived log file name=/testcases/SR3-6629539201/rectbl/1\_63\_804254048.dbf RECID=135 STAMP=805320573  
media recovery complete, elapsed time: 00:00:00  
Finished recover at 21-JAN-13  
  
database opened  
  
contents of Memory Script:  
\{  
sql clone 'alter pluggable database  T12CPDB1 open';  
\}  
executing Memory Script  
  
sql statement: alter pluggable database  T12CPDB1 open  
  
contents of Memory Script:  
\{  
\# create directory for datapump import  
sql 'T12CPDB1' "create or replace directory TSPITR\_DIROBJ\_DPDIR as ''/testcases/SR3-6629539201/rectbl''";  
\# create directory for datapump export  
sql clone 'T12CPDB1' "create or replace directory TSPITR\_DIROBJ\_DPDIR as ''/testcases/SR3-6629539201/rectbl''";  
\}  
executing Memory Script  
  
sql statement: create or replace directory TSPITR\_DIROBJ\_DPDIR as ''/testcases/SR3-6629539201/rectbl''  
  
sql statement: create or replace directory TSPITR\_DIROBJ\_DPDIR as ''/testcases/SR3-6629539201/rectbl''  
  
Performing export of tables...  
   EXPDP> Starting "SYS"."TSPITR\_EXP\_naxj\_kswu":    
   EXPDP> Estimate in progress using BLOCKS method...  
   EXPDP> Processing object type TABLE\_EXPORT/TABLE/TABLE\_DATA  
   EXPDP> Total estimation using BLOCKS method: 128 KB  
   EXPDP> Processing object type TABLE\_EXPORT/TABLE/TABLE  
   EXPDP> Processing object type TABLE\_EXPORT/TABLE/STATISTICS/TABLE\_STATISTICS  
   EXPDP> Processing object type TABLE\_EXPORT/TABLE/STATISTICS/MARKER  
   EXPDP> . . exported "SMEDS"."RECTEST"                           6.109 KB      32 rows  
   EXPDP> Master table "SYS"."TSPITR\_EXP\_naxj\_kswu" successfully loaded/unloaded  
   EXPDP> \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
   EXPDP> Dump file set for SYS.TSPITR\_EXP\_naxj\_kswu is:  
   EXPDP>   /testcases/SR3-6629539201/rectbl/tspitr\_naxj\_85941.dmp  
   EXPDP> Job "SYS"."TSPITR\_EXP\_naxj\_kswu" successfully completed at Mon Jan 21 20:10:28 2013 elapsed 0 00:00:31  
Export completed  
  
  
contents of Memory Script:  
\{  
\# shutdown clone before import  
shutdown clone abort  
\}  
executing Memory Script  
  
Oracle instance shut down  
  
Performing import of tables...  
   IMPDP> Master table "SYS"."TSPITR\_IMP\_naxj\_uklm" successfully loaded/unloaded  
   IMPDP> Starting "SYS"."TSPITR\_IMP\_naxj\_uklm":    
   IMPDP> Processing object type TABLE\_EXPORT/TABLE/TABLE  
   IMPDP> Processing object type TABLE\_EXPORT/TABLE/TABLE\_DATA  
   IMPDP> . . imported "SMEDS"."TEST4\_RECTEST"                     6.109 KB      32 rows  
   IMPDP> Processing object type TABLE\_EXPORT/TABLE/STATISTICS/TABLE\_STATISTICS  
   IMPDP> Processing object type TABLE\_EXPORT/TABLE/STATISTICS/MARKER  
   IMPDP> Job "SYS"."TSPITR\_IMP\_naxj\_uklm" successfully completed at Mon Jan 21 20:10:40 2013 elapsed 0 00:00:06  
Import completed  
  
  
Removing automatic instance  
Automatic instance removed  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_temp\_8hv82j8f\_.tmp deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_temp\_8hv82bj8\_.tmp deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/onlinelog/o1\_mf\_3\_8hv840bs\_.log deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/onlinelog/o1\_mf\_2\_8hv83zp1\_.log deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/onlinelog/o1\_mf\_1\_8hv83z15\_.log deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/NAXJ\_PITR\_T12CCDB/datafile/o1\_mf\_rectbl\_8hv83qpg\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_8hv7zbn7\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_8hv7zbnt\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_sysaux\_8hv7zbn2\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_undotbs1\_8hv7zbob\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/datafile/o1\_mf\_system\_8hv7zblx\_.dbf deleted  
auxiliary instance file /testcases/SR3-6629539201/rectbl/T12CCDB/controlfile/o1\_mf\_8hv7z47y\_.ctl deleted  
auxiliary instance file tspitr\_naxj\_85941.dmp deleted  
Finished recover at 21-JAN-13