Re: Datapump export, incremential only?

From: Gus Spier <gus.spier_at_gmail.com>
Date: Wed, 10 Aug 2011 19:06:31 -0400
Message-ID: <CAG8xnifjiqvZOf=2454N==HsthbTXhx=Fn3NSC8RdETmuchiUg_at_mail.gmail.com>

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_at_lmco.com>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?****
>
> ** **
>

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 10 2011 - 18:06:31 CDT