Expdp:ORA-3971:作业正在经历可恢复的等待



Microsoft Windows[版本10.0.14393](c( 2016年微软公司。保留所有权利。

C:UsersAdministrator>expdp USERNAME/*****@db FULL=Y VERSION=12.1 DIRECTORY=Load_Dump DUMPFILE=fNAMe.DMP LOGFILE=NAme.log parallel=4
Export: Release 12.1.0.2.0 - Production on Mon Jul 20 11:11:57 2020
Copyright (c) 1982, 2014, Oracle and/or its affiliates.  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
WARNING: Oracle Data Pump operations are not typically needed when connected to the root or seed of a container database.
...... 
------------------------------------------------------------------------------
Resumable stmt status: SUSPENDED
Resumable stmt start: 07/20/20 11:14:02 stmt suspend: 07/20/20 11:14:03
ORA-39171: Job is experiencing a resumable wait.
Resumable error: ORA-01691: unable to extend lob segment DBUSER.SYS_LOB0000109481C00100$$ by 128 in tablespace DBTBS
Resumable stmt: INSERT INTO "DBUSER"."SYS_EXPORT_FULL_01" (object_type_path, object_path_seqno, dump_fileid, dump_position,dump_length, dump_orig_length, dump_allocation, process_order, duplicate, object_row, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, partition_name, subpartition_name, object_tablespace, grantor, flags, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, xml_clob, ancestor_process_order, property, trigflag, size_estimate, creation_level, parent_process_order, value_n, object_int_oid, metadata_io, tde_rewrapped_key, option_tag, orig_base_object_schema, parallelization, unload_method) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :13, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43)

Datapump没有问题,而是存储问题。数据泵作业将暂停,直到问题得到解决。

你的线索:

ORA-01691: unable to extend lob segment DBUSER.SYS_LOB0000109481C00100$$ by 128 in tablespace DBTBS

数据泵中的可恢复错误是可恢复的错误,这意味着作业被暂停,直到导致暂停的问题得到解决。

增加表空间DBTBS,您的工作将恢复。

@Roberto提到这是由于表空间大小问题,您可以扩展表空间大小。在我的情况下,我打开了自动扩展,但最大尺寸被突破了。您可以扩展最大表空间大小并继续导入过程。

ALTER TABLESPACE DBTBS
ADD DATAFILE 'DBTBS.dbf'
SIZE 200m
autoextend ON NEXT 1000M maxsize 4000M;

假设4000M将是数据库导入的最大限制。

最新更新