Help withpoor-man's database replication
534899Nov 29 2006 — edited Dec 1 2006Hi All,
We have a very small data model of six (6) tables and about 1500 records a day. Oracle 8i on SunOS.
As part of a failsafe system we would like to develop a "poor man" database replication system.
What we would like is, a hot swappable back up database server with fairly up-to-date information. To do this we are considering making incremental backup dump files of production data, copying them over, and loading them into the backup database at a given interval, say, every 1/2 hour.
Does anyone have any experience with such a system or have any recommendations? My guess is this will be easier to implement than true database replication.
As always, thanks for your help on this.
Regards, David
Valhalla, NY