Oracle 12C 新特性之 恢复表

yuxing

　　RMAN的表级和表分区级恢复应用场景：
　　1、You need to recover a very small number of tables to a particular point in time. In this situation, TSPITR is not the most effective solution because it moves all the objects in the tablespace to a specified point in time.
　　2、You need to recover tables that have been logically corrupted or have been dropped and purged.
　　3、Flashback Table is not possible because the desired point-in-time is older than available undo.
　　4、You want to recover data that is lost after a DDL operation modified the structure of tables. Using Flashback Table is not possible because a DDL was run on the tables between the desired point in time and the current time. Flashback Table cannot rewind tables through structural changes such as a truncate table operation.
　　译文：
　　1、您需要将非常少量的表恢复到特定的时间点。在这种情况下，TSPITR 不是最有效的解决方案，因为它将表空间中的所有对象都移动到指定的时间点。
　　2、您需要恢复已被逻辑损坏或已被删除和清除的表。
　　3、Flashback Table 不可用，如undo 数据已经被覆盖。
　　4、恢复在DDL操作修改表结构之后丢失的数据。使用Flashback表是不可能的，因为在需要的时间点和当前时间之间的表上运行一个DDL。闪回表不能通过诸如截断表操作之类的结构更改来倒表。
　　RMAN的表级和表分区级恢复限制：
　　1、Tables and table partitions belonging to SYS schema cannot be recovered.
　　2、Tables and table partitions from SYSTEM and SYSAUX tablespaces cannot be recovered.
　　3、Tables and table partitions on standby databases cannot be recovered.
　　4、Tables with named NOT NULL constraints cannot be recovered with the REMAP option.
　　RMAN的表级和表分区级恢复前提：
　　1、The target database must be in read-write mode.
　　2、The target database must be in ARCHIVELOG mode.
　　3、You must have RMAN backups of the tables or table partitions as they existed at the point in time to which you want recover these objects.
　　4、To recover single table partitions, the COMPATIBLE initialization parameter for target database must be set to 11.1.0 or higher.
　　恢复方法：
　　1、SCN
　　2、Time
　　3、Sequence number
　　RMAN从备份中自动处理恢复表或者表分区时的步骤：
　　1、Determines which backup contains the tables or table partitions that need to be recovered, based on the point in time specified for the recovery.
　　2、Determines if there is sufficient space on the target host to create the auxiliary instance that will be used during the table or partition recovery process.
　　If the required space is not available, then RMAN displays an error and exits the recovery operation.
　　3、Creates an auxiliary database and recovers the specified tables or table partitions, until the specified point in time, into this auxiliary database.
　　You can specify the location to which the recovered data files are stored in the auxiliary database.
　　4、Creates a Data Pump export dump file that contains the recovered tables or table partitions.
　　You can specify the name and the location of the export dump file used to store the metadata of the recovered tables or table partitions.
　　5、(Optional) Imports the Data Pump export dump file into the target instance.
　　You can choose not to import the export dump file that contains the recovered tables or table partitions into the target database. If you do not import the export dump file as part of the recovery process, you must manually import it later using the Data Pump Import utility.
　　6、(Optional) Renames the recovered tables or table partitions in the target database.
　　You can also import recovered objects into a tablespace or schema that is different from the one in which they originally existed.
　　译：
　　1.确定哪些备份包含需要恢复的表或表分区，根据指定的时间来进行恢复。
　　2.确定目标主机上是否有足够的空间来创建将在表或分区恢复过程中使用的辅助实例。 如果需要的空间不足，那么RMAN会报错并退出恢复操作。
　　3.创建一个辅助数据库并恢复指定的表或表分区，并根据指定的时间来恢复指定的表或表分区到辅助数据库中。 可以指定用于存储已恢复表或表分区的元数据的导出转储文件的名称和位置。
　　4.创建一个数据泵导出转储文件，其中包含已恢复的表或表分区。可以指定用于存储已恢复表或表分区的元数据的导出转储文件的名称和位置。
　　5. （可选操作）将上一步生产的数据泵文件导入到目标实例中。您可以选择不导入包含已恢复的表或表分区到目标数据库的导出转储文件。如果您不导入导出转储文件作为恢复过程的一部分，那么您必须在稍后使用 impdp 手工导入。
　　6. （可选操作）在目标数据库中rename 恢复表或表分区。
　　PDB操作流程：
　　--  准备测试环境
　　SQL> show con_name
　　CON_NAME
　　------------------------------
　　CDB$ROOT
　　SQL> select log_mode from v$database;
　　LOG_MODE
　　------------
　　ARCHIVELOG
　　SQL> show pdbs
　　CON_ID CON_NAME  OPEN MODE  RESTRICTED
　　---------- ------------------------------ ---------- ----------
　　2 PDB$SEED  READ ONLY  NO
　　3 PDB01  READ WRITE NO
　　4 PDB02  READ WRITE NO

　　SQL>>
　　Session>　　SQL> select tablespace_name from dba_tablespaces;
　　TABLESPACE_NAME
　　------------------------------
　　SYSTEM
　　SYSAUX
　　UNDOTBS1
　　TEMP
　　USERS
　　BBB
　　6 rows selected.
　　-- 建立测试用户
　　SQL> show con_name
　　CON_NAME
　　------------------------------
　　PDB01

　　SQL> create user andy>　　User created.
　　SQL> grant dba to andy;
　　Grant succeeded.
　　-- 创建测试表：
　　SQL> conn andy/andy@10.219.24.16:1521/pdb01
　　Connected.
　　SQL> create table andy(id int);
　　Table created.
　　SQL> insert into andy values(1);
　　1 row created.
　　SQL> commit;
　　Commit complete.
　　SQL> conn / as sysdba
　　Connected.
　　SQL>  alter system switch logfile;

　　System>　　SQL> /

　　System>　　-- RMAN 备份CDB
　　--使用如下命令备份CDB的组建：ROOT,SEED,PDBS：

[oracle@12c ~]$ rman target /

　　RMAN> backup database plus archivelog;
　　Finished Control File and SPFILE Autobackup at 21-MAY-17
　　说明： 关于 Oracle 12c 多租户 CDB 与 PDB 备份 请参考 ->http://blog.csdn.net/zhang123456456/article/details/71540927
　　-- 恢复数据
　　drop andy purge 表，然后执行恢复操作：
　　SQL> conn andy/andy@10.219.24.16:1521/pdb01
　　SQL> select current_scn from v$database;
　　CURRENT_SCN
　　-----------
　　2088202
　　SQL> drop table andy purge;
　　Table dropped.
　　SQL> select * from andy;
　　ERROR at line 1:
　　ORA-00942: table or view does not exist
　　-- 创建辅助目录

[oracle@12c ~]$ mkdir -p /tmp/oracle/recover

[oracle@12c ~]$ mkdir -p /tmp/recover/dumpfiles

　　-- 恢复时，cdb 与 pdb 都是Open read writer 状态。
　　SQL> show pdbs
　　CON_ID CON_NAME  OPEN MODE  RESTRICTED
　　---------- ------------------------------ ---------- ----------
　　2 PDB$SEED  READ ONLY  NO
　　3 PDB01  READ WRITE NO
　　4 PDB02  READ WRITE NO
　　-- 恢复命令

[oracle@12c ~]$  rman target /

　　RMAN>
　　run{
　　RECOVER TABLE andy.andy of pluggable database pdb01
　　UNTIL SCN 2088202
　　AUXILIARY DESTINATION '/home/oracle/tmp/oracle/recover'
　　datapump destination '/home/oracle/tmp/recover/dumpfiles';
　　}
　　补充：恢复表不支持公共用户，开始作者使用的是公共用户做实验，报错如下，也没有很明显的提示，后换本地用户没有这类报错。
　　RMAN>recover table c##andy.andy_recover_t of pluggable database pdb01
　　until scn 2060046
　　auxiliary destination '/home/oracle/tmp/oracle/recover'
　　datapump destination  '/home/oracle/tmp/recover/dumpfiles';
　　RMAN-00571: ===========================================================
　　RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
　　RMAN-00571: ===========================================================
　　RMAN-00558: error encountered while parsing input commands

　　RMAN-01009: syntax error: found "datapump": expecting one of: "advise, allocate,>　　RMAN-01007: at line 1 column 1 file: standard input
　　-- 恢复查看
　　SQL> select * from andy;
　　ID
　　----------
　　1   >恢复成功
　　恢复过程:还原system,undo,sysaux表空间,然后read only数据库,然后重启数据库还原表所在表空间,然后expdp导出表,根据需要决定是否导入表到原PDB数据库中，最后删除辅助数据库。 整个过程对原PDB没有影响。
　　补充：恢复过程监控

[oracle@12c dumpfiles]$ cd /home/oracle/tmp/oracle/recover

[oracle@12c recover]$ ll

　　total 8
　　drwxr-x---. 6 oracle oinstall 4096 May 21 18:26 ANDYCDB
　　drwxr-x---. 4 oracle oinstall 4096 May 21 18:35 PCAS_PITR_PDB01_ANDYCDB

[oracle@12c recover]$ cd /home/oracle/tmp/recover/dumpfiles

[oracle@12c dumpfiles]$ ll

　　total 164
　　-rw-r-----. 1 oracle oinstall 167936 May 21 19:12 tspitr_fgxA_79856.dmp

[iyunv@12c ~]# ps -ef|grep smon

　　oracle     3838      1  0 17:45 ?        00:00:00 ora_smon_andycdb
　　oracle     5769      1  0 18:58 ?        00:00:00 ora_smon_fgxA
　　root       5941   3772  0 19:03 pts/3    00:00:00 grep smon
　　说明：辅助实例有启动实例进程fgxA
　　恢复过程日志如下：
　　RMAN> run{
　　RECOVER TABLE andy.andy of pluggable database pdb01
　　UNTIL SCN 2088202
　　AUXILIARY DESTINATION '/home/oracle/tmp/oracle/recover'
　　datapump destination '/home/oracle/tmp/recover/dumpfiles';
　　}2> 3> 4> 5> 6>
　　Starting recover at 21-MAY-17
　　using channel ORA_DISK_1
　　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 PDB01:SYSTEM
　　Tablespace UNDOTBS1
　　Tablespace PDB01:UNDOTBS1
　　Creating automatic instance, with SID='fgxA'
　　initialization parameters used for automatic instance:
　　db_name=ANDYCDB
　　db_unique_name=fgxA_pitr_pdb01_ANDYCDB
　　compatible=12.2.0
　　db_block_size=8192
　　db_files=200
　　diagnostic_dest=/home/oracle/app/oracle
　　_system_trig_enabled=FALSE
　　sga_target=692M
　　processes=200
　　db_create_file_dest=/home/oracle/tmp/oracle/recover
　　log_archive_dest_1='location=/home/oracle/tmp/oracle/recover'
　　enable_pluggable_database=true
　　_clone_one_pdb_recovery=true
　　max_string_size=EXTENDED
　　#No auxiliary parameter file used
　　starting up automatic instance ANDYCDB
　　Oracle instance started
　　Total System Global Area     725614592 bytes

　　Fixed>
　　Variable>　　Database Buffers             507510784 bytes
　　Redo Buffers                   3784704 bytes
　　Automatic instance created
　　contents of Memory Script:
　　{
　　# set requested point in time
　　set until  scn 2088202;
　　# 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
　　Staring restore at 21-MAY-17
　　allocated channel: ORA_AUX_DISK_1
　　channel ORA_AUX_DISK_1: SID=35 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 /home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/c-4182839949-20170521-00
　　channel ORA_AUX_DISK_1: piece handle=/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/c-4182839949-20170521-00 tag=TAG20170521T041813
　　channel ORA_AUX_DISK_1: restored backup piece 1
　　channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
　　output file name=/home/oracle/tmp/oracle/recover/ANDYCDB/controlfile/o1_mf_dl2wpytg_.ctl
　　Finished restore at 21-MAY-17

　　sql statement:>
　　sql statement:>　　contents of Memory Script:
　　{
　　# set requested point in time
　　set until  scn 2088202;
　　# set destinations for recovery set and auxiliary set datafiles
　　set newname for clone datafile  1 to new;
　　set newname for clone datafile  9 to new;
　　set newname for clone datafile  4 to new;
　　set newname for clone datafile  11 to new;
　　set newname for clone datafile  3 to new;
　　set newname for clone datafile  10 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, 9, 4, 11, 3, 10;
　　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
　　executing command: SET NEWNAME
　　renamed tempfile 1 to /home/oracle/tmp/oracle/recover/ANDYCDB/datafile/o1_mf_temp_%u_.tmp in control file
　　renamed tempfile 3 to /home/oracle/tmp/oracle/recover/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_temp_%u_.tmp in control file
　　Starting restore at 21-MAY-17
　　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 /home/oracle/tmp/oracle/recover/ANDYCDB/datafile/o1_mf_system_%u_.dbf
　　channel ORA_AUX_DISK_1: restoring datafile 00004 to /home/oracle/tmp/oracle/recover/ANDYCDB/datafile/o1_mf_undotbs1_%u_.dbf
　　channel ORA_AUX_DISK_1: restoring datafile 00003 to /home/oracle/tmp/oracle/recover/ANDYCDB/datafile/o1_mf_sysaux_%u_.dbf
　　channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/0ss4p2c8_1_1
　　channel ORA_AUX_DISK_1: piece handle=/home/oracle/app/oracle/product/12.2.0/dbhome_1/dbs/0ss4p2c8_1_1 tag=TAG20170521T041359
　　channel ORA_AUX_DISK_1: restored backup piece 1
　　channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:38
　　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 00009 to /home/oracle/tmp/oracle/recover/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_system_%u_.dbf
　　channel ORA_AUX_DISK_1: restoring datafile 00011 to /home/oracle/tmp/oracle/recover/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_undotbs1_%u_.dbf
　　/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_sysaux_%u_.dbf
　　2.2.0/dbhome_1/dbs/0ts4p2eu_1_1
　　1/dbs/0ts4p2eu_1_1 tag=TAG20170521T041359
　　channel ORA_AUX_DISK_1: restored backup piece 1
　　channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:58
　　Finished restore at 21-MAY-17
　　datafile 1 switched to datafile copy
　　ver/ANDYCDB/datafile/o1_mf_system_dl2wqg9o_.dbf
　　datafile 9 switched to datafile copy
　　ver/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_system_dl2wtl6g_.dbf
　　datafile 4 switched to datafile copy
　　ver/ANDYCDB/datafile/o1_mf_undotbs1_dl2wqgcc_.dbf
　　datafile 11 switched to datafile copy
　　ver/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_undotbs1_dl2wtlf0_.dbf
　　datafile 3 switched to datafile copy
　　ver/ANDYCDB/datafile/o1_mf_sysaux_dl2wqgc0_.dbf
　　datafile 10 switched to datafile copy
　　ver/ANDYCDB/4F44590EB7B74390E0531018DB0A1976/datafile/o1_mf_sysaux_dl2wtl06_.db
　　contents of Memory Script:
　　{
　　# set requested point in time
　　set until  scn 2088202;
　　# online the datafiles restored or switched
　　sql clone "alter database datafile  1 online";
　　sql clone 'PDB01' "alter database datafile
　　9 online";
　　sql clone "alter database datafile  4 online";
　　sql clone 'PDB01' "alter database datafile
　　11 online";
　　sql clone "alter database datafile  3 online";
　　sql clone 'PDB01' "alter database datafile
　　10 online";
　　# recover and open database read only
　　"UNDOTBS1", "SYSAUX", "PDB01":"SYSAUX";
　　sql clone 'alter database open read only';
　　}
　　executing Memory Script
　　executing command: SET until clause

　　sql statement:>
　　sql statement:>
　　sql statement:>
　　sql statement:>
　　sql statement:>
　　sql statement:>　　Starting recover at 21-MAY-17
　　using channel ORA_AUX_DISK_1
　　starting media recovery
　　app/oracle/product/12.2.0/dbhome_1/dbs/arch1_20_943753232.dbf
　　app/oracle/product/12.2.0/dbhome_1/dbs/arch1_21_943753232.dbf
　　_943753232.dbf thread=1 sequence=20
　　_943753232.dbf thread=1 sequence=21
　　media recovery complete, elapsed time: 00:01:32
　　Finished recover at 21-MAY-17

　　sql statement:>　　contents of Memory Script:
　　{
　　sql clone 'alter pluggable database  PDB01 open read only';
　　}
　　executing Memory Script

　　sql statement:>　　contents of Memory Script:
　　{
　　sql clone "create spfile from memory";
　　shutdown clone immediate;
　　startup clone nomount;
　　sql clone "alter system set  control_files =
　　nt=
　　''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     725614592 bytes

　　Fixed>
　　Variable>　　Database Buffers             507510784 bytes
　　Redo Buffers                   3784704 bytes
　　r/ANDYCDB/controlfile/o1_mf_dl2wpytg_.ctl'' comment= ''RMAN set'' scope=spfile
　　Oracle instance shut down
　　connected to auxiliary database (not started)
　　Oracle instance started
　　Total System Global Area     725614592 bytes

　　Fixed>
　　Variable>　　Database Buffers             507510784 bytes
　　Redo Buffers                   3784704 bytes

　　sql statement:>　　contents of Memory Script:
　　{
　　# set requested point in time
　　set until  scn 2088202;
　　# set destinations for recovery set and auxiliary set datafiles
　　set newname for datafile  13 to new;
　　set newname for datafile  14 to new;
　　set newname for datafile  15 to new;
　　# restore the tablespaces in the recovery set and the auxiliary set
　　restore clone datafile  13, 14, 15;
　　switch clone datafile all;
　　}
　　executing Memory Script
　　executing command: SET until clause
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　executing command: SET NEWNAME
　　Starting restore at 21-MAY-17
　　allocated channel: ORA_AUX_DISK_1
　　channel ORA_AUX_DISK_1: SID=35 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
　　f
　　f
　　f
　　2.2.0/dbhome_1/dbs/0ts4p2eu_1_1
　　1/dbs/0ts4p2eu_1_1 tag=TAG20170521T041359
　　channel ORA_AUX_DISK_1: restored backup piece 1
　　channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:16
　　Finished restore at 21-MAY-17
　　datafile 13 switched to datafile copy
　　x50h8_.dbf
　　datafile 14 switched to datafile copy
　　x50l4_.dbf
　　datafile 15 switched to datafile copy
　　x500q_.dbf
　　contents of Memory Script:
　　{
　　# set requested point in time
　　set until  scn 2088202;
　　# online the datafiles restored or switched
　　sql clone 'PDB01' "alter database datafile
　　13 online";
　　sql clone 'PDB01' "alter database datafile
　　14 online";
　　sql clone 'PDB01' "alter database datafile
　　15 online";
　　# recover and open resetlogs
　　TBS1", "PDB01":"UNDOTBS1", "SYSAUX", "PDB01":"SYSAUX" delete archivelog;
　　alter clone database open resetlogs;
　　}
　　executing Memory Script
　　executing command: SET until clause

　　sql statement:>
　　sql statement:>
　　sql statement:>　　Starting recover at 21-MAY-17
　　using channel ORA_AUX_DISK_1
　　starting media recovery
　　app/oracle/product/12.2.0/dbhome_1/dbs/arch1_20_943753232.dbf
　　app/oracle/product/12.2.0/dbhome_1/dbs/arch1_21_943753232.dbf
　　_943753232.dbf thread=1 sequence=20
　　_943753232.dbf thread=1 sequence=21
　　media recovery complete, elapsed time: 00:00:18
　　Finished recover at 21-MAY-17
　　database opened
　　contents of Memory Script:
　　{
　　sql clone 'alter pluggable database  PDB01 open';
　　}
　　executing Memory Script

　　sql statement:>　　contents of Memory Script:
　　{
　　# create directory for datapump import
　　sql 'PDB01' "create or replace directory
　　TSPITR_DIROBJ_DPDIR as ''
　　/home/oracle/tmp/recover/dumpfiles''";
　　# create directory for datapump export
　　sql clone 'PDB01' "create or replace directory
　　TSPITR_DIROBJ_DPDIR as ''
　　/home/oracle/tmp/recover/dumpfiles''";
　　}
　　executing Memory Script
　　p/recover/dumpfiles''
　　p/recover/dumpfiles''
　　Performing export of tables...
　　EXPDP> Starting "SYS"."TSPITR_EXP_fgxA_Fvnl":  
　　EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
　　EXPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
　　EXPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
　　rows
　　EXPDP> Master table "SYS"."TSPITR_EXP_fgxA_Fvnl" successfully loaded/unloaded
　　*****
　　EXPDP> Dump file set for SYS.TSPITR_EXP_fgxA_Fvnl is:
　　EXPDP>   /home/oracle/tmp/recover/dumpfiles/tspitr_fgxA_79856.dmp
　　12:59 2017 elapsed 0 00:02:24
　　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_fgxA_txhb" successfully loaded/unloaded
　　IMPDP> Starting "SYS"."TSPITR_IMP_fgxA_txhb":  
　　IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE
　　IMPDP> Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
　　rows
　　IMPDP> Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
　　16:32 2017 elapsed 0 00:01:06
　　Import completed
　　Removing automatic instance
　　Automatic instance removed
　　31018DB0A1976/datafile/o1_mf_temp_dl2x08jv_.tmp deleted
　　_dl2wzlwf_.tmp deleted
　　inelog/o1_mf_3_dl2x6vbp_.log deleted
　　inelog/o1_mf_2_dl2x6gt1_.log deleted
　　inelog/o1_mf_1_dl2x6gt1_.log deleted
　　4590EB7B74390E0531018DB0A1976/datafile/o1_mf_bbb_dl2x500q_.dbf deleted
　　4590EB7B74390E0531018DB0A1976/datafile/o1_mf_bbb_dl2x50l4_.dbf deleted
　　4590EB7B74390E0531018DB0A1976/datafile/o1_mf_bbb_dl2x50h8_.dbf deleted
　　31018DB0A1976/datafile/o1_mf_sysaux_dl2wtl06_.dbf deleted
　　ux_dl2wqgc0_.dbf deleted
　　31018DB0A1976/datafile/o1_mf_undotbs1_dl2wtlf0_.dbf deleted
　　tbs1_dl2wqgcc_.dbf deleted
　　31018DB0A1976/datafile/o1_mf_system_dl2wtl6g_.dbf deleted
　　em_dl2wqg9o_.dbf deleted
　　l2wpytg_.ctl deleted
　　auxiliary instance file tspitr_fgxA_79856.dmp deleted
　　Finished recover at 21-MAY-17