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

> [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 <http://www.sublogic.com/james/>
GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7  9C8E A0BF B026 EEBB F6E4
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: James Manning
  INET: jmm_at_sublogic.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (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).