How to synchronize data?

Author:Snowhite2000 Time:02-09-03 0:49

This depends on your environment requirements.

If the synchronization you requested can be delayed by one day or a few days, the export/import method is good. The synchronization between our prod and the database in the test/train environment is in this State. The regular export prod, import to test/train database. We use a cron job. It is easy to write scripts.

If your synchronization needs to be implemented immediately and only a few tables need to do so, set advance replication.

Think of an easy and easy-to-operate method based on the environment. If it is a production system, it is best not to bother yourself.

************************

You can use ORACLE standby database for this function.

In Oracle 9i, standby database has been renamed to "Data guard ".

Quote:

Initially released by fjcakiller
The synchronization machine is another slave. If a problem occurs in the other database, the slave database will be immediately topped up and the two databases will be swapped.