oracle impdp恢复操作

越王看剑o=|===>

于 2023-05-31 15:27:11 发布

阅读量485

点赞数

分类专栏： oracle 文章标签： oracle 数据库

本文链接：https://blog.csdn.net/qq_43095139/article/details/130969921

版权

oracle 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

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