oracle查看impdp进度

当数据量比较大的时候，当你导入，导出的时候，在数据库中查看运行的情况，可以利用下面的视图查看:

//这里由于导表空间时出现问题，所以再次执行导入任务。但是已有任务在执行，查看执行中的任务方法。

oracle@prd:/home/oracle/impdir$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 16:02:31 2022
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from dba_datapump_sessions;

SQL> set pagesize 0 
SQL> set line 9999
SQL> select * from dba_datapump_sessions;
OWNER_NAME                                            JOB_NAME                                               INST_ID  SADDR            SESSION_TYPE
SH                                           SYS_IMPORT_FULL_02                                        1     000000009F733380 MASTER
SH                                           SYS_IMPORT_FULL_02                                        1     000000009F764180 WORKER
 
4、impdp(导入或expdp)
[oracle@prd:/home/oracle/impdir$ impdp SH attach=SYS_IMPORT_FULL_02
//语法: impdp OWNER_NAME attach=JOB_NAME
Import: Release 11.2.0.4.0 - Production on Mon Mar 21 16:09:20 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Password: *******

//密码就是 impdp sh/sh12 remap_schema=shfp:sh2  table_exists_action=replace  remap_tablespace=SHFP:SHFP  directory=IMPDIR dumpfile=SHFP.dmp  logfile=implog.log

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Job: SYS_IMPORT_FULL_02
  Owner: SH                     
  Operation: IMPORT                         
  Creator Privs: TRUE                           
  GUID: DAB625C0FCAC23C7E0534638810A0166
  Start Time: Monday, 21 March, 2022 15:07:21
  Mode: FULL                           
  Instance: fpmai
  Max Parallelism: 1
  EXPORT Job Parameters:
     CLIENT_COMMAND        sh/******** dumpfile=SH.dmp directory=EXPDIR logfile=shexport.log 
  IMPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        sh/******** remap_schema=sh:sh2 table_exists_action=replace remap_tablespace=SH:SH directory=IMPDIR dumpfile=SH.dmp logfile=implog.log 
     TABLE_EXISTS_ACTION   REPLACE                                 
  State: STOP PENDING                   
  Bytes Processed: 19,044,467,760
  Percent Done: 99
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/impdir/SHFP.dmp
  
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: SH
  Object Name: ADD_ADMINISTRATOR
  Object Type: SCHEMA_EXPORT/PROCEDURE/PROCEDURE
  Worker Parallelism: 1
Import>kill_job   //这里杀死当前的任务.

再次查看任务执行情况

oracle@prod:/home/oracle/impdir$impdp SH attach=SYS_IMPORT_FULL_02

Import: Release 11.2.0.4.0 - Production on Mon Mar 21 16:46:04 2022

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Password: ******  
//密码就是sh的用户密码
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_IMPORT_FULL_02
  Owner: SH                     
  Operation: IMPORT                         
  Creator Privs: TRUE                           
  GUID: DAB625C0FCAC23C7E0534638810A0166
  Start Time: Monday, 21 March, 2022 15:07:21
  Mode: FULL                           
  Instance: fpmai
  Max Parallelism: 1
  EXPORT Job Parameters:
     CLIENT_COMMAND        sh/******** dumpfile=SH.dmp directory=EXPDIR logfile=shexport.log 
  IMPORT Job Parameters:
  Parameter Name      Parameter Value:
     CLIENT_COMMAND        sh/******** remap_schema=shfp:shfpfpmai table_exists_action=replace remap_tablespace=SH:SH directory=IMPDIR dumpfile=SHFP.dmp logfile=implog.log 
     TABLE_EXISTS_ACTION   REPLACE                                 
  State: STOP PENDING                   
  Bytes Processed: 19,044,467,760
  Percent Done: 99
  Current Parallelism: 1
  Job Error Count: 0
  Dump File: /home/oracle/impdir/SH.dmp
Worker 1 Status:
  Process Name: DW00
  State: EXECUTING                      
  Object Schema: SHFPFPMAI
  Object Name: ADD_ADMINISTRATOR
  Object Type: SCHEMA_EXPORT/PROCEDURE/PROCEDURE
  Worker Parallelism: 1
Import> kill_job
Are you sure you wish to stop this job ([yes]/no): yes

oracle@prod:/home/oracle/impdir$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 16:59:10 2022
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>  select * from dba_datapump_sessions;

no rows selected  //发现没有进程了

如果想重新执行，看到结果，则可以重新执行之前的导入语句（table_exists_action=replace 是替换）

[root@rac-12c-2 ~]# su - oracle
Last login: Mon Mar 21 20:24:18 CST 2022 on pts/1

[oracle@prd:/home/oracle$ impdp sh/password123 remap_schema=shfp:sh2 table_exists_action=replace remap_tablespace=SH:SH directory=IMPDIR dumpfile=SHFP.dmp logfile=implog.log