Re: Database synchronization - München

Thomas wrote:

> I have one production database and one identical database (structure)
> on a different network.
>
> Each night, I need track the changes (insertions) that have taken
> place on the production database and then affect them on the offline
> system. Note that content of the online system that is old gets
> deleted whereas on the offline system, it sticks around forever: I am
> just tracking the inserts.
>
> exporting the database to a file would be a possibility if it checked
> changes at the row level as opposed to the table level. But since it
> doesn't and besides the output won't contain all the old deleted
> stuff, export is not an option.
>
> Is there a clever way to use archive logs or *whatever* to simply get
> a file containing insert statements that can be ftp'd over to the
> offline system?

Go to http://tahiti.oracle.com and look into log replication.

Apply the redo logs from your production database to the stand-by.

And please do not cross-post. I have removed the cross-post to c.d.o.misc.

Daniel Morgan Received on Thu Feb 13 2003 - 01:32:38 CST