If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Im trying to backup my oracle database at a Disaster recovery site and I was wondering if the databases were out of sync for whatever reason. If it was possible to synchronize them using the log files or some other method which does not require a transfer of the entire database (100GB)? \

I am told that even if they are 99.99% in sync you have to send another copy of the entire database. We are using oracle 8i, perhaps this is not the case with Oracle 10?

Do you know of a program or even a 3rd party application that can be used to synchronize the without having to redo the entire database?

>if they are 99.99% in sync
What magic do you expect to be done to grok EXACTLY which 00.01% of the source data needs to be sent?

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

To keep two databases "in synch", at some point in time in the past they had to have been "in synch".
Keep in mind that for 8i in the source DB, any DDL "breaks" synchronization.

You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.

Assuming they are almost always in sync but then at some point they become out of sync. Is there a way to bring them back in sync without a total reloading of the entire database? I mean just looking at the small piece that is not in sync instead of the entire database?

I mean, it would take a very long time to transfer 100GB database across the internet! The Daffodil replicator saids:

The Replicator file system technology maintains a record of incremental database changes and transfer only those file system blocks that have changed. This significantly reduces the amount of data that needs to be transferred.