impdp执行后,由于dmp文件大。数据文件大,320G导入时间无法查看具体impdp进度
登录数据库客户端。查询impdp任务相关信息。
select * from dba_datapump_sessions;
登录服务器oracle用户 执行
impdp OWNER_NAME attach=JOB_NAME
[oracle@NCTEST ~]$ impdp NCDATA attach=SYS_IMPORT_FULL_01
Import: Release 11.2.0.1.0 - Production on Wed May 31 15:16:49 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: SYS_IMPORT_FULL_01
Owner: NCDATA
Operation: IMPORT
Creator Privs: TRUE
GUID: FCF4BB95668A309DE050A8C0C308DECD
Start Time: Wednesday, 31 May, 2023 10:03:59
Mode: FULL
Instance: oracle
Max Parallelism: 1
EXPORT Job Parameters:
CLIENT_COMMAND ncdata/******** job_name=backup_parallel_20230529 directory=DMPDIR logfile=BACK20230529010001.log dumpfile=BACK_%U.dmp.20230529010001 compression=all parallel=5
COMPRESSION ALL
IMPORT Job Parameters:
Parameter Name Parameter Value:
CLIENT_COMMAND NCDATA/******** dumpfile=BACK_%U.dmp.20230529010001 logfile=log2.log directory=NCTEST table_exists_action=replace
TABLE_EXISTS_ACTION REPLACE
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_%u.dmp.20230529010001
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_01.dmp.20230529010001
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_02.dmp.20230529010001
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_03.dmp.20230529010001
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_04.dmp.20230529010001
Dump File: /mnt/mdisk/NCDATA_DB_BACKUP/BACK_05.dmp.20230529010001
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: NCDATA
Object Name: TEMQ_F28JF_1949
Object Type: SCHEMA_EXPORT/TABLE/TABLE
Completed Objects: 422,211
Worker Parallelism: 1