在网络上看到12c的rman可以进行table 级别的恢复，由于自己就做一下试验。本试验测试了rman基于时间点恢复一个被删除表的操作过程。

[oracle@ol6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 19 15:05:09 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> select con_id,dbid,name,open_mode from v$pdbs;
CON_ID DBID NAME OPEN_MODE
---------- ---------- ------------------------------ ----------
2 500891672 PDB$SEED READ ONLY
3 1722454057 PDBCDB1 READ WRITE

SQL> alter session set container=pdbcdb1;
Session altered.

SQL> create table abraham.test(id number,insert_date date);
Table created.

SQL> insert into abraham.test values(1,sysdate);
1 row created.

SQL> commit;
Commit complete.

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2014-11-19 15:06:35

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@ol6 ~]$ rman target sys/Sino2034
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Nov 19 15:07:55 2014
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=837685586)

RMAN> backup as compressed backupset database;
Starting backup at 19-NOV-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 device type=DISK
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/cdb1/system01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/cdb1/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/cdb1/undotbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/cdb1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 19-NOV-14
channel ORA_DISK_1: finished piece 1 at 19-NOV-14
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjgxjb_.bkp tag=TAG20141119T150812 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/cdb1/pdbcdb1/sysaux01.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/cdb1/pdbcdb1/pdbcdb1_users01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/cdb1/pdbcdb1/system01.dbf
channel ORA_DISK_1: starting piece 1 at 19-NOV-14
channel ORA_DISK_1: finished piece 1 at 19-NOV-14
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/081DDD8AE0D23A74E053DE00A8C0E259/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjjngn_.bkp tag=TAG20141119T150812 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting compressed full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/cdb1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/cdb1/pdbseed/system01.dbf
channel ORA_DISK_1: starting piece 1 at 19-NOV-14
channel ORA_DISK_1: finished piece 1 at 19-NOV-14
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/081DC73CC41A37CDE053DE00A8C050F3/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjkqmg_.bkp tag=TAG20141119T150812 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 19-NOV-14
Starting Control File and SPFILE Autobackup at 19-NOV-14
piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_19/o1_mf_s_864054618_b6rjltvx_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 19-NOV-14
RMAN> exit
Recovery Manager complete.

[oracle@ol6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 19 15:10:28 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter session set container=pdbcdb1;
Session altered.

SQL> insert into abraham.test values(2,sysdate);
1 row created.

SQL> commit;
Commit complete.

SQL> insert into abraham.test values(3,sysdate);
1 row created.

SQL> commit;
Commit complete.

SQL> select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
TO_CHAR(SYSDATE,'YY
-------------------
2014-11-19 15:11:27

SQL> drop table abraham.test purge;
Table dropped.

SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[oracle@ol6 ~]$ rman target sys/Sino2034
Recovery Manager: Release 12.1.0.2.0 - Production on Wed Nov 19 15:11:39 2014
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=837685586)

RMAN> RECOVER TABLE ABRAHAM."TEST" OF PLUGGABLE DATABASE PDBCDB1 UNTIL TIME "to_date('2014-11-19 15:11:27','YYYY-MM-DD:HH24:MI:SS')" AUXILIARY DESTINATION '/tmp' DATAPUMP DESTINATION '/tmp' DUMP FILE 'tst_dump.dmp';

还原代码如下：

点击(此处)折叠或打开
1. RMAN> RECOVER TABLE ABRAHAM.\"TEST\" OF PLUGGABLE DATABASE PDBCDB1 UNTIL TIME \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\" AUXILIARY DESTINATION \'/tmp\' DATAPUMP DESTINATION \'/tmp\' DUMP FILE \'tst_dump.dmp\';
3. Starting recover at 19-NOV-14
4. using target database control file instead of recovery catalog
5. current log archived
6. allocated channel: ORA_DISK_1
7. channel ORA_DISK_1: SID=258 device type=DISK
8. RMAN-05026: WARNING: presuming following set of tablespaces applies to specified Point-in-Time
10. List of tablespaces expected to have UNDO segments
11. Tablespace SYSTEM
12. Tablespace UNDOTBS1
14. Creating automatic instance, with SID=\'ewFk\'
16. initialization parameters used for automatic instance:
17. db_name=CDB1
18. db_unique_name=ewFk_pitr_PDBCDB1_CDB1
19. compatible=12.1.0.2.0
20. db_block_size=8192
21. db_files=200
22. diagnostic_dest=/u01/app/oracle
23. _system_trig_enabled=FALSE
24. sga_target=2560M
25. processes=200
26. db_create_file_dest=/tmp
27. log_archive_dest_1=\'location=/tmp\'
28. enable_pluggable_database=true
29. _clone_one_pdb_recovery=true
30. #No auxiliary parameter file used
33. starting up automatic instance CDB1
35. Oracle instance started
37. Total System Global Area 2684354560 bytes
39. Fixed Size 2928008 bytes
40. Variable Size 587203192 bytes
41. Database Buffers 2080374784 bytes
42. Redo Buffers 13848576 bytes
43. Automatic instance created
45. contents of Memory Script:
46. {
47. # set requested point in time
48. set until time \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\";
49. # restore the controlfile
50. restore clone controlfile;
52. # mount the controlfile
53. sql clone \'alter database mount clone database\';
55. # archive current online log
56. sql \'alter system archive log current\';
57. }
58. executing Memory Script
60. executing command: SET until clause
62. Starting restore at 19-NOV-14
63. allocated channel: ORA_AUX_DISK_1
64. channel ORA_AUX_DISK_1: SID=165 device type=DISK
66. channel ORA_AUX_DISK_1: starting datafile backup set restore
67. channel ORA_AUX_DISK_1: restoring control file
68. channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_19/o1_mf_s_864054618_b6rjltvx_.bkp
69. channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/autobackup/2014_11_19/o1_mf_s_864054618_b6rjltvx_.bkp tag=TAG20141119T151018
70. channel ORA_AUX_DISK_1: restored backup piece 1
71. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
72. output file name=/tmp/CDB1/controlfile/o1_mf_b6rjprrq_.ctl
73. Finished restore at 19-NOV-14
75. sql statement: alter database mount clone database
77. sql statement: alter system archive log current
79. contents of Memory Script:
80. {
81. # set requested point in time
82. set until time \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\";
83. # set destinations for recovery set and auxiliary set datafiles
84. set newname for clone datafile 1 to new;
85. set newname for clone datafile 4 to new;
86. set newname for clone datafile 3 to new;
87. set newname for clone datafile 8 to new;
88. set newname for clone datafile 9 to new;
89. set newname for clone tempfile 1 to new;
90. set newname for clone tempfile 3 to new;
91. # switch all tempfiles
92. switch clone tempfile all;
93. # restore the tablespaces in the recovery set and the auxiliary set
94. restore clone datafile 1, 4, 3, 8, 9;
96. switch clone datafile all;
97. }
98. executing Memory Script
100. executing command: SET until clause
102. executing command: SET NEWNAME
104. executing command: SET NEWNAME
106. executing command: SET NEWNAME
108. executing command: SET NEWNAME
110. executing command: SET NEWNAME
112. executing command: SET NEWNAME
114. executing command: SET NEWNAME
116. renamed tempfile 1 to /tmp/CDB1/datafile/o1_mf_temp_%u_.tmp in control file
117. renamed tempfile 3 to /tmp/CDB1/datafile/o1_mf_temp_%u_.tmp in control file
119. Starting restore at 19-NOV-14
120. using channel ORA_AUX_DISK_1
122. channel ORA_AUX_DISK_1: starting datafile backup set restore
123. channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
124. channel ORA_AUX_DISK_1: restoring datafile 00001 to /tmp/CDB1/datafile/o1_mf_system_%u_.dbf
125. channel ORA_AUX_DISK_1: restoring datafile 00004 to /tmp/CDB1/datafile/o1_mf_undotbs1_%u_.dbf
126. channel ORA_AUX_DISK_1: restoring datafile 00003 to /tmp/CDB1/datafile/o1_mf_sysaux_%u_.dbf
127. channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjgxjb_.bkp
128. channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjgxjb_.bkp tag=TAG20141119T150812
129. channel ORA_AUX_DISK_1: restored backup piece 1
130. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:15
131. channel ORA_AUX_DISK_1: starting datafile backup set restore
132. channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
133. channel ORA_AUX_DISK_1: restoring datafile 00008 to /tmp/CDB1/datafile/o1_mf_system_%u_.dbf
134. channel ORA_AUX_DISK_1: restoring datafile 00009 to /tmp/CDB1/datafile/o1_mf_sysaux_%u_.dbf
135. channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/081DDD8AE0D23A74E053DE00A8C0E259/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjjngn_.bkp
136. channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/081DDD8AE0D23A74E053DE00A8C0E259/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjjngn_.bkp tag=TAG20141119T150812
137. channel ORA_AUX_DISK_1: restored backup piece 1
138. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
139. Finished restore at 19-NOV-14
141. datafile 1 switched to datafile copy
142. input datafile copy RECID=8 STAMP=864054861 file name=/tmp/CDB1/datafile/o1_mf_system_b6rjpytd_.dbf
143. datafile 4 switched to datafile copy
144. input datafile copy RECID=9 STAMP=864054861 file name=/tmp/CDB1/datafile/o1_mf_undotbs1_b6rjpywg_.dbf
145. datafile 3 switched to datafile copy
146. input datafile copy RECID=10 STAMP=864054861 file name=/tmp/CDB1/datafile/o1_mf_sysaux_b6rjpywc_.dbf
147. datafile 8 switched to datafile copy
148. input datafile copy RECID=11 STAMP=864054861 file name=/tmp/CDB1/datafile/o1_mf_system_b6rjsb86_.dbf
149. datafile 9 switched to datafile copy
150. input datafile copy RECID=12 STAMP=864054861 file name=/tmp/CDB1/datafile/o1_mf_sysaux_b6rjsb6t_.dbf
152. contents of Memory Script:
153. {
154. # set requested point in time
155. set until time \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\";
156. # online the datafiles restored or switched
157. sql clone \"alter database datafile 1 online\";
158. sql clone \"alter database datafile 4 online\";
159. sql clone \"alter database datafile 3 online\";
160. sql clone \'PDBCDB1\' \"alter database datafile
161. 8 online\";
162. sql clone \'PDBCDB1\' \"alter database datafile
163. 9 online\";
164. # recover and open database read only
165. recover clone database tablespace \"SYSTEM\", \"UNDOTBS1\", \"SYSAUX\", \"PDBCDB1\":\"SYSTEM\", \"PDBCDB1\":\"SYSAUX\";
166. sql clone \'alter database open read only\';
167. }
168. executing Memory Script
170. executing command: SET until clause
172. sql statement: alter database datafile 1 online
174. sql statement: alter database datafile 4 online
176. sql statement: alter database datafile 3 online
178. sql statement: alter database datafile 8 online
180. sql statement: alter database datafile 9 online
182. Starting recover at 19-NOV-14
183. using channel ORA_AUX_DISK_1
185. starting media recovery
187. archived log for thread 1 with sequence 51 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_19/o1_mf_1_51_b6rjpdjs_.arc
188. archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_19/o1_mf_1_51_b6rjpdjs_.arc thread=1 sequence=51
189. media recovery complete, elapsed time: 00:00:01
190. Finished recover at 19-NOV-14
192. sql statement: alter database open read only
194. contents of Memory Script:
195. {
196. sql clone \'alter pluggable database PDBCDB1 open read only\';
197. }
198. executing Memory Script
200. sql statement: alter pluggable database PDBCDB1 open read only
202. contents of Memory Script:
203. {
204. sql clone \"create spfile from memory\";
205. shutdown clone immediate;
206. startup clone nomount;
207. sql clone \"alter system set control_files =
208. \'\'/tmp/CDB1/controlfile/o1_mf_b6rjprrq_.ctl\'\' comment=
209. \'\'RMAN set\'\' scope=spfile\";
210. shutdown clone immediate;
211. startup clone nomount;
212. # mount database
213. sql clone \'alter database mount clone database\';
214. }
215. executing Memory Script
217. sql statement: create spfile from memory
219. database closed
220. database dismounted
221. Oracle instance shut down
223. connected to auxiliary database (not started)
224. Oracle instance started
226. Total System Global Area 2684354560 bytes
228. Fixed Size 2928008 bytes
229. Variable Size 603980408 bytes
230. Database Buffers 2063597568 bytes
231. Redo Buffers 13848576 bytes
233. sql statement: alter system set control_files = \'\'/tmp/CDB1/controlfile/o1_mf_b6rjprrq_.ctl\'\' comment= \'\'RMAN set\'\' scope=spfile
235. Oracle instance shut down
237. connected to auxiliary database (not started)
238. Oracle instance started
240. Total System Global Area 2684354560 bytes
242. Fixed Size 2928008 bytes
243. Variable Size 603980408 bytes
244. Database Buffers 2063597568 bytes
245. Redo Buffers 13848576 bytes
247. sql statement: alter database mount clone database
249. contents of Memory Script:
250. {
251. # set requested point in time
252. set until time \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\";
253. # set destinations for recovery set and auxiliary set datafiles
254. set newname for datafile 10 to new;
255. # restore the tablespaces in the recovery set and the auxiliary set
256. restore clone datafile 10;
258. switch clone datafile all;
259. }
260. executing Memory Script
262. executing command: SET until clause
264. executing command: SET NEWNAME
266. Starting restore at 19-NOV-14
267. allocated channel: ORA_AUX_DISK_1
268. channel ORA_AUX_DISK_1: SID=12 device type=DISK
270. channel ORA_AUX_DISK_1: starting datafile backup set restore
271. channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
272. channel ORA_AUX_DISK_1: restoring datafile 00010 to /tmp/EWFK_PITR_PDBCDB1_CDB1/datafile/o1_mf_users_%u_.dbf
273. channel ORA_AUX_DISK_1: reading from backup piece /u01/app/oracle/fast_recovery_area/CDB1/081DDD8AE0D23A74E053DE00A8C0E259/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjjngn_.bkp
274. channel ORA_AUX_DISK_1: piece handle=/u01/app/oracle/fast_recovery_area/CDB1/081DDD8AE0D23A74E053DE00A8C0E259/backupset/2014_11_19/o1_mf_nnndf_TAG20141119T150812_b6rjjngn_.bkp tag=TAG20141119T150812
275. channel ORA_AUX_DISK_1: restored backup piece 1
276. channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
277. Finished restore at 19-NOV-14
279. datafile 10 switched to datafile copy
280. input datafile copy RECID=14 STAMP=864054925 file name=/tmp/EWFK_PITR_PDBCDB1_CDB1/datafile/o1_mf_users_b6rjw60o_.dbf
282. contents of Memory Script:
283. {
284. # set requested point in time
285. set until time \"to_date(\'2014-11-19 15:11:27\',\'YYYY-MM-DD:HH24:MI:SS\')\";
286. # online the datafiles restored or switched
287. sql clone \'PDBCDB1\' \"alter database datafile
288. 10 online\";
289. # recover and open resetlogs
290. recover clone database tablespace \"PDBCDB1\":\"USERS\", \"SYSTEM\", \"UNDOTBS1\", \"SYSAUX\", \"PDBCDB1\":\"SYSTEM\", \"PDBCDB1\":\"SYSAUX\" delete archivelog;
291. alter clone database open resetlogs;
292. }
293. executing Memory Script
295. executing command: SET until clause
297. sql statement: alter database datafile 10 online
299. Starting recover at 19-NOV-14
300. using channel ORA_AUX_DISK_1
302. starting media recovery
304. archived log for thread 1 with sequence 51 is already on disk as file /u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_19/o1_mf_1_51_b6rjpdjs_.arc
305. archived log file name=/u01/app/oracle/fast_recovery_area/CDB1/archivelog/2014_11_19/o1_mf_1_51_b6rjpdjs_.arc thread=1 sequence=51
306. media recovery complete, elapsed time: 00:00:00
307. Finished recover at 19-NOV-14
309. database opened
311. contents of Memory Script:
312. {
313. sql clone \'alter pluggable database PDBCDB1 open\';
314. }
315. executing Memory Script
317. sql statement: alter pluggable database PDBCDB1 open
319. contents of Memory Script:
320. {
321. # create directory for datapump import
322. sql \'PDBCDB1\' \"create or replace directory
323. TSPITR_DIROBJ_DPDIR as \'\'
324. /tmp\'\'\";
325. # create directory for datapump export
326. sql clone \'PDBCDB1\' \"create or replace directory
327. TSPITR_DIROBJ_DPDIR as \'\'
328. /tmp\'\'\";
329. }
330. executing Memory Script
332. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \'\'/tmp\'\'
334. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \'\'/tmp\'\'
336. Performing export of tables...
337. EXPDP> Starting \"SYS\".\"TSPITR_EXP_ewFk_rjaD\":
338. EXPDP> Estimate in progress using BLOCKS method...
339. EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
340. EXPDP> Total estimation using BLOCKS method: 64 KB
341. EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
342. EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
343. EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
344. EXPDP> . . exported \"ABRAHAM\".\"TEST\" 5.515 KB 3 rows
345. EXPDP> Master table \"SYS\".\"TSPITR_EXP_ewFk_rjaD\" successfully loaded/unloaded
346. EXPDP> ******************************************************************************
347. EXPDP> Dump file set for SYS.TSPITR_EXP_ewFk_rjaD is:
348. EXPDP> /tmp/tst_dump.dmp
349. EXPDP> Job \"SYS\".\"TSPITR_EXP_ewFk_rjaD\" successfully completed at Wed Nov 19 15:16:19 2014 elapsed 0 00:00:25
350. Export completed
353. contents of Memory Script:
354. {
355. # shutdown clone before import
356. shutdown clone abort
357. }
358. executing Memory Script
360. Oracle instance shut down
362. Performing import of tables...
363. IMPDP> Master table \"SYS\".\"TSPITR_IMP_ewFk_Bbvu\" successfully loaded/unloaded
364. IMPDP> Starting \"SYS\".\"TSPITR_IMP_ewFk_Bbvu\":
365. IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
366. IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
367. IMPDP> . . imported \"ABRAHAM\".\"TEST\" 5.515 KB 3 rows
368. IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
369. IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/MARKER
370. IMPDP> Job \"SYS\".\"TSPITR_IMP_ewFk_Bbvu\" successfully completed at Wed Nov 19 15:16:36 2014 elapsed 0 00:00:07
371. Import completed
374. Removing automatic instance
375. Automatic instance removed
376. auxiliary instance file /tmp/CDB1/datafile/o1_mf_temp_b6rjtp9g_.tmp deleted
377. auxiliary instance file /tmp/CDB1/datafile/o1_mf_temp_b6rjtjv2_.tmp deleted
378. auxiliary instance file /tmp/EWFK_PITR_PDBCDB1_CDB1/onlinelog/o1_mf_3_b6rjwhs2_.log deleted
379. auxiliary instance file /tmp/EWFK_PITR_PDBCDB1_CDB1/onlinelog/o1_mf_2_b6rjwhb9_.log deleted
380. auxiliary instance file /tmp/EWFK_PITR_PDBCDB1_CDB1/onlinelog/o1_mf_1_b6rjwgvf_.log deleted
381. auxiliary instance file /tmp/EWFK_PITR_PDBCDB1_CDB1/datafile/o1_mf_users_b6rjw60o_.dbf deleted
382. auxiliary instance file /tmp/CDB1/datafile/o1_mf_sysaux_b6rjsb6t_.dbf deleted
383. auxiliary instance file /tmp/CDB1/datafile/o1_mf_system_b6rjsb86_.dbf deleted
384. auxiliary instance file /tmp/CDB1/datafile/o1_mf_sysaux_b6rjpywc_.dbf deleted
385. auxiliary instance file /tmp/CDB1/datafile/o1_mf_undotbs1_b6rjpywg_.dbf deleted
386. auxiliary instance file /tmp/CDB1/datafile/o1_mf_system_b6rjpytd_.dbf deleted
387. auxiliary instance file /tmp/CDB1/controlfile/o1_mf_b6rjprrq_.ctl deleted
388. auxiliary instance file tst_dump.dmp deleted
389. Finished recover at 19-NOV-14
RMAN> exit
Recovery Manager complete.
[oracle@ol6 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Wed Nov 19 15:16:51 2014
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> alter session set container=pdbcdb1;
Session altered.

SQL> select * from abraham.test;
ID INSERT_DA
---------- ---------
2 19-NOV-14
3 19-NOV-14
1 19-NOV-14

整体恢复过程是：还原system、undo、sysaux表空间，然后read only数据库，然后重启数据库还原表所在表空间，然后expdp导出表，根据需要决定是否导入表到数据库。

ITPub博客

Oracle 12c: Recover tables using RMAN

最新文章