RE: Datapump export, incremential only?
- From: Herring Dave - dherri <Dave.Herring@xxxxxxxxxx>
- To: "chris.grabowy@xxxxxxxx" <chris.grabowy@xxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Aug 2011 13:45:50 +0000
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@xxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Grabowy, Chris
Sent: Wednesday, August 10, 2011 4:44 PM
To: oracle-l@xxxxxxxxxxxxx
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?
--
//www.freelists.org/webpage/oracle-l
Other related posts:
