Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: replication: exporting just "deferred transactions" at client

Re: replication: exporting just "deferred transactions" at client

From: James Manning <>
Date: Thu, 24 Apr 2003 12:52:32 -0800
Message-ID: <>

> [Koivu, Lisa]
> Look at rman... incremental backups come to mind.

Unfortunately, I don't see how to tell exp or rman to make them "incremental since last sync", both are incremental on their own. Because of that, I can only use their incremental backups (to write the changed blocks out to the CD-RW) if I precede each sync operation (they are attempted in the background with a dbms_job) with an exp or rman backup so that the relevant tables are written.

Ideally, I'd be able to look up the last sync time and say "exp incremental all the changes since point X in time" (or do the same with rman) but neither of those look possible as both base incremental on their own internal tracking data (recovery catalog / control file for rman, or the tables that catexp sets up for exp).

And, to be honest I'm kinda doubting that a time/date would actually be relevant, since I have a feeling that said internal tracking data is likely to be more SCN-based kind of info or something along those lines.

Philosophically, yes, incremental is exactly what I want. In practice, though, I need some way of saying "incremental changes since the data was synced with the master, since anything before then is already at the master" but I don't see any tools that allow that.

Thanks, Lisa!

James Manning <>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
Please see the official ORACLE-L FAQ:
Author: James Manning

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Thu Apr 24 2003 - 15:52:32 CDT

Original text of this message