RE: Datapump export, incremential only?
Date: Mon, 15 Aug 2011 20:40:41 -0400
Message-id: <CA1C0E24676BC4448D79E5D5B7E4484616AB14858C_at_HVXMSP8.us.lmco.com>
Thanks Dave.
I will ask him to check into that.
Thanks,
Chris
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Herring Dave - dherri
Sent: Thursday, August 11, 2011 9:46 AM
To: Grabowy, Chris; oracle-l_at_freelists.org
Subject: EXTERNAL: RE: Datapump export, incremential only?
Chris,
If you're going to rely on the view DBA_TAB_MODIFICATIONS, make sure to execute DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO beforehand, so that this view is up-to-date.
DAVID HERRING
DBA
Acxiom Corporation
EML dave.herring_at_acxiom.com TEL 630.944.4762 MBL 630.430.5988
1501 Opus Pl, Downers Grove, IL 60515, USA WWW.ACXIOM.COM
The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Grabowy, Chris
Sent: Wednesday, August 10, 2011 4:44 PM
To: oracle-l_at_freelists.org
Subject: Datapump export, incremential only?
We have been struggling with having Datapump exports complete every night. Sometimes with execution times. Other cases with dump file sizes.
We added the compress option and that helped with generating smaller dump files with no obvious impact to the execution time, but that hasn't really helped with the overall execution time.
We have played with the parallel option with some success.
Anyway one of the DBAs updated the script to generate a datapump parm file that contains a list of the tables that changed in the last two days. Even though we execute datapump every night he felt it would be safer to generate a list of changed tables for the last two days. He generates the list of changed tables by querying dba_tab_modifications. With this change, the datapump exports are obviously faster and the dump files much smaller.
We still do a weekly full datapump export on Sundays.
Anyway, were kind of scratching our heads and trying to figure out if this could come back and bite us somehow. Paranoia is a required DBA trait.
We do understand that when importing we might have to go back to the Sunday save to import a table since it might have not been saved in any of the incrementals. We are saving/organizing the log files to easily grep for the desired table.
I know that incremental was not a stable/valid option in the old export tool, but you would think that Oracle would have figured out how to do incremental datapump exports by now.using some sort of defined criteria. At least, looking thru the doc I did not find such an option. Am I just being naïve here and missing the bigger picture on the viability of a datapump/export incremental feature?
Thoughts? Suggestions? Insults?
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 15 2011 - 19:40:41 CDT