RE: EXTERNAL: Re: Datapump export, incremential only?

Gus,

I believe the DBA was trying to take advantage of that WHERE clause but was not 
able to make it work that way.

As I mentioned in the other email, we do the standard RMAN backups.  Since we 
are using ASM, we will always do RMAN backups.

Having a daily DP export has some nice benefits.  We are simply trying to make 
it more efficient.

Thanks,
Chris


From: Gus Spier [mailto:gus.spier@xxxxxxxxx]
Sent: Wednesday, August 10, 2011 7:07 PM
To: Grabowy, Chris
Cc: oracle-l@xxxxxxxxxxxxx
Subject: EXTERNAL: Re: Datapump export, incremential only?

Chris, is there some way to use the datapump WHERE clause to set your defined 
criteria for an incremental datapump export?  Of course, if the tables don't 
have a TIMESTAMP compatible column, that might be problematic.

I suspect that big Oracle advocates RMAN solutions over datapump incremental 
backups.  That might account for the absence of your datapump solution.

Regards,
Gus
On Wed, Aug 10, 2011 at 5:44 PM, Grabowy, Chris 
<chris.grabowy@xxxxxxxx<mailto:chris.grabowy@xxxxxxxx>> wrote:
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?

Other related posts: