Oracle 12c: Recover tables using RMAN

• 在網路上看到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\';
     
  2. 
     
  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
     
  9. 
     
  10. List of tablespaces expected to have UNDO segments
      
  11. Tablespace SYSTEM
      
  12. Tablespace UNDOTBS1
      
  13. 
      
  14. Creating automatic instance, with SID=\'ewFk\'
      
  15. 
      
  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
      
  31. 
      
  32. 
      
  33. starting up automatic instance CDB1
      
  34. 
      
  35. Oracle instance started
      
  36. 
      
  37. Total System Global Area 2684354560 bytes
      
  38. 
      
  39. Fixed Size 2928008 bytes
      
  40. Variable Size 587203192 bytes
      
  41. Database Buffers 2080374784 bytes
      
  42. Redo Buffers 13848576 bytes
      
  43. Automatic instance created
      
  44. 
      
  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;
      
  51.  
      
  52. # mount the controlfile
      
  53. sql clone \'alter database mount clone database\';
      
  54.  
      
  55. # archive current online log
      
  56. sql \'alter system archive log current\';
      
  57. }
      
  58. executing Memory Script
      
  59. 
      
  60. executing command: SET until clause
      
  61. 
      
  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
      
  65. 
      
  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
      
  74. 
      
  75. sql statement: alter database mount clone database
      
  76. 
      
  77. sql statement: alter system archive log current
      
  78. 
      
  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;
      
  95.  
      
  96. switch clone datafile all;
      
  97. }
      
  98. executing Memory Script
      
  99. 
      
  100. executing command: SET until clause
       
  101. 
       
  102. executing command: SET NEWNAME
       
  103. 
       
  104. executing command: SET NEWNAME
       
  105. 
       
  106. executing command: SET NEWNAME
       
  107. 
       
  108. executing command: SET NEWNAME
       
  109. 
       
  110. executing command: SET NEWNAME
       
  111. 
       
  112. executing command: SET NEWNAME
       
  113. 
       
  114. executing command: SET NEWNAME
       
  115. 
       
  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
       
  118. 
       
  119. Starting restore at 19-NOV-14
       
  120. using channel ORA_AUX_DISK_1
       
  121. 
       
  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
       
  140. 
       
  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
       
  151. 
       
  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
       
  169. 
       
  170. executing command: SET until clause
       
  171. 
       
  172. sql statement: alter database datafile 1 online
       
  173. 
       
  174. sql statement: alter database datafile 4 online
       
  175. 
       
  176. sql statement: alter database datafile 3 online
       
  177. 
       
  178. sql statement: alter database datafile 8 online
       
  179. 
       
  180. sql statement: alter database datafile 9 online
       
  181. 
       
  182. Starting recover at 19-NOV-14
       
  183. using channel ORA_AUX_DISK_1
       
  184. 
       
  185. starting media recovery
       
  186. 
       
  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
       
  191. 
       
  192. sql statement: alter database open read only
       
  193. 
       
  194. contents of Memory Script:
       
  195. {
       
  196. sql clone \'alter pluggable database PDBCDB1 open read only\';
       
  197. }
       
  198. executing Memory Script
       
  199. 
       
  200. sql statement: alter pluggable database PDBCDB1 open read only
       
  201. 
       
  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
       
  216. 
       
  217. sql statement: create spfile from memory
       
  218. 
       
  219. database closed
       
  220. database dismounted
       
  221. Oracle instance shut down
       
  222. 
       
  223. connected to auxiliary database (not started)
       
  224. Oracle instance started
       
  225. 
       
  226. Total System Global Area 2684354560 bytes
       
  227. 
       
  228. Fixed Size 2928008 bytes
       
  229. Variable Size 603980408 bytes
       
  230. Database Buffers 2063597568 bytes
       
  231. Redo Buffers 13848576 bytes
       
  232. 
       
  233. sql statement: alter system set control_files = \'\'/tmp/CDB1/controlfile/o1_mf_b6rjprrq_.ctl\'\' comment= \'\'RMAN set\'\' scope=spfile
       
  234. 
       
  235. Oracle instance shut down
       
  236. 
       
  237. connected to auxiliary database (not started)
       
  238. Oracle instance started
       
  239. 
       
  240. Total System Global Area 2684354560 bytes
       
  241. 
       
  242. Fixed Size 2928008 bytes
       
  243. Variable Size 603980408 bytes
       
  244. Database Buffers 2063597568 bytes
       
  245. Redo Buffers 13848576 bytes
       
  246. 
       
  247. sql statement: alter database mount clone database
       
  248. 
       
  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;
       
  257.  
       
  258. switch clone datafile all;
       
  259. }
       
  260. executing Memory Script
       
  261. 
       
  262. executing command: SET until clause
       
  263. 
       
  264. executing command: SET NEWNAME
       
  265. 
       
  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
       
  269. 
       
  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
       
  278. 
       
  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
       
  281. 
       
  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
       
  294. 
       
  295. executing command: SET until clause
       
  296. 
       
  297. sql statement: alter database datafile 10 online
       
  298. 
       
  299. Starting recover at 19-NOV-14
       
  300. using channel ORA_AUX_DISK_1
       
  301. 
       
  302. starting media recovery
       
  303. 
       
  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
       
  308. 
       
  309. database opened
       
  310. 
       
  311. contents of Memory Script:
       
  312. {
       
  313. sql clone \'alter pluggable database PDBCDB1 open\';
       
  314. }
       
  315. executing Memory Script
       
  316. 
       
  317. sql statement: alter pluggable database PDBCDB1 open
       
  318. 
       
  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
       
  331. 
       
  332. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \'\'/tmp\'\'
       
  333. 
       
  334. sql statement: create or replace directory TSPITR_DIROBJ_DPDIR as \'\'/tmp\'\'
       
  335. 
       
  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
       
  351. 
       
  352. 
       
  353. contents of Memory Script:
       
  354. {
       
  355. # shutdown clone before import
       
  356. shutdown clone abort
       
  357. }
       
  358. executing Memory Script
       
  359. 
       
  360. Oracle instance shut down
       
  361. 
       
  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
       
  372. 
       
  373. 
       
  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部落格 ” ，連結：http://blog.itpub.net/29439655/viewspace-1339043/，如需轉載，請註明出處，否則將追究法律責任。