replication: exporting just "deferred transactions" at client

From: James Manning <jmm_at_sublogic.com>
Date: Thu, 24 Apr 2003 11:32:31 -0800
Message-ID: <F001.00588B62.20030424113231@fatcity.com>

NOTE: Please cc me in any response, not currently subscribed :)

The situation are remotely-deployed laptops that never get very far out of sync with the (one, central) master. In case the laptops crash or get stolen or whatever, we're hoping to make backups of the "changed data" onto the CD-RW (UDF/DirectCD filesystem). At the moment, I do a full instance hot backup and that's way too much data and the copy.exe operations end up killing laptop performance.

I'm hoping there's some way of exporting / saving / whatever *just* the changes that's been done to the replicated tables of this instance (changes queued up to go out at next attempted refresh of the snapshots).

I see a lot of DEF$_* tables in system, but it's not clear to me whether these are viable backups if exported on their own, and if so how I'd go about restoring them.

exporting or backing up the instance or even the replicated tablespaces is highly inefficient since 99.99% of the data I already have a copy of at the master. How can I just store "local mods not synced" in a restorable way?

Thanks, guys!!

James
--

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). Received on Thu Apr 24 2003 - 14:32:31 CDT