Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Import is hung at DATABASE_EXPORT/STATISTICS/MARKER from last 2 days

user8894296Oct 14 2018 — edited Oct 14 2018

Import is hung at DATABASE_EXPORT/STATISTICS/MARKER from last 2 days
Please advice what need to be done to complete the Import , if we kill the import in this stage then what will be impact on data

Please find the log
;;;
Import: Release 12.1.0.2.0 - Production on Fri Oct 12 07:30:40 2018

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, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
12-OCT-18 07:30:47.200: Startup took 4 seconds
.
.
.
.
.
12-OCT-18 09:23:56.261:      Completed 1 INDEX_STATISTICS objects in 0 seconds
12-OCT-18 09:23:56.295: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/STATISTICS/TABLE_STATISTICS
12-OCT-18 09:23:57.184:      Completed 498 TABLE_STATISTICS objects in 1 seconds
12-OCT-18 09:23:57.210: Processing object type DATABASE_EXPORT/STATISTICS/MARKER

Please find the parfile
DIRECTORY=CH******08
DUMPFILE=LNC********************.dmp
LOGFILE=LNCRA1******************.log
CONTENT = ALL
PARALLEL = 16
CLUSTER = NO
LOGTIME = ALL
METRICS = YES
SCHEMAS=SFAOWNER,LDP,ULOG

Database Version
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

Comments
Post Details
Added on Oct 14 2018
3 comments
744 views