No question at this time
DBA Top 10
1 M. Cadot 21900
2 A. Kavsek 13800
3 M. Hidayathullah ... 10900
4 B. Vroman 8800
5 T. Boles 6500
6 P. Wisse 6000
7 J. Schnackenberg 4600
8 A. Hudspith 3100
9 P. Knibbs 2200
9 K. Pagadala 2200
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47949
Total active users1868
Act. users last 24h10
Act. users last hour1
Registered user hits last week4558
Registered user hits last month5489
Go up

full data pump import
Next thread: Data base slowness issue
Prev thread: execution plan

Message Score Author Date
Hi Guys I was doing a full database import usin...... Tso P Mar 09, 2017, 14:00
Hi Tso, I guess you have to replace EXPORT with...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse Mar 09, 2017, 14:21
Thanks Philip Now, how do I know that all my in...... Tso P Mar 09, 2017, 15:41
Hi Tso, After running impdp read the logfile?<p...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Philip Wisse Mar 09, 2017, 15:57
Dear Tso, Also check resumable_timeout paramete...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Mirza Hidayathullah Baig Mar 10, 2017, 06:01
Thanks So I can just rerun the import and revie...... Tso P Mar 10, 2017, 07:37
Hi Tso, you might run an "impdp" session with ...... Bruno Vroman Mar 12, 2017, 11:24

Follow up by mail Click here


Subject: full data pump import
Author: Tso P, South Africa
Date: Mar 09, 2017, 14:00, 75 days ago
Os info: rhel5
Oracle info: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
Message: Hi Guys

I was doing a full database import using datapump. I ran out of space on the mount point then my datapump import crashed...I was using parallelism.

Now, how do I continue from here...I ficed the space issue. I do have enough space now to continue...It looks like the import was busy with indexes...

What are the steps that I should follow to continue...

Below is the last lines of the log.

Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/CROSS_SCHEMA/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 5 with process name "DW01" prematurely terminated
ORA-31672: Worker process DW01 died unexpectedly.
Job "SYS"."SYS_IMPORT_FULL_01" stopped due to fatal error at 13:29:19

Please Help!!!

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Philip Wisse, Netherlands
Date: Mar 09, 2017, 14:21, 75 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

I guess you have to replace EXPORT with IMPORT:

select * from dba_datapump_jobs;
select * from dba_recyclebin where type = 'TABLE' and original_name like '%EXPORT%';

drop table VCD.SYS_EXPORT_FULL_01;
purge table VCD.SYS_EXPORT_FULL_01;

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Tso P, South Africa
Date: Mar 09, 2017, 15:41, 75 days ago
Message: Thanks Philip

Now, how do I know that all my indexes and constraints were created as the job terminated prematurely.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Philip Wisse, Netherlands
Date: Mar 09, 2017, 15:57, 75 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

After running impdp read the logfile?

impdp foo/bar@orcl directory=expdir "schemas='TSO1','TSO2'" dumpfile=export.dmp logfile=import.log


HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Mar 10, 2017, 06:01, 74 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Dear Tso,

Also check resumable_timeout parameter values, wait time before job abort.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Tso P, South Africa
Date: Mar 10, 2017, 07:37, 74 days ago
Message: Thanks

So I can just rerun the import and review the log without worry about the sequences?

Thanks in advance...
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: full data pump import
Author: Bruno Vroman, Belgium
Date: Mar 12, 2017, 11:24, 72 days ago
Message: Hi Tso,

you might run an "impdp" session with
 INCLUDE=constraint
 INCLUDE=index
 SQLFILE=myfile.sql

Review the sqlfile produced and run it (add "spool myfile.log"). Errors "object ... already exists" can be ignored.

You can compare the number of objects in source and in target database to locate "discrepancies"
SELECT owner, object_type, COUNT(*) nb FROM dba_objects GROUP BY owner, object_type ORDER BY 1, 2;
(you can do this before running the sqlfile and after)

(if there are "too many differences" to fix by hand, or if the run of the sqlfile generates too many errors and leaves you insecure, you might if DB is not too large restart the complete import from scratch)

BTW, "full exp/imp": be aware that SYS objects are not exported so pay a special attention if your database is using things like triggers owned by SYS -I do this often, triggers fired "on logon" or "on startup"-, or maybe also PUBLIC SYNONYMS (I'm not sure if they are exported, some application do things like "create public synonym EMP for SCOTT.EMP;")

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here