Forwarding redo-logs

Hello !

I'm thinking of building a database master-slave failure-safe configuration. The slave server should get every transaction made on the master. (e.g. every 15 min.) So that after master crash all clients could work with the slave database.  

I discussed 3 ways of doing this:

1. Using table replication (not good because of readonly snapshots)
2. Table-based triggers (not efficient enough)
3. Redo-logs forwarding (seames to be good, but how to do it ?)

Has some body tried to roll forward redo-logs taken from another database ? Is it possible to do it ?
These two databases will be identical. Redologs genarated on the master database should be good for appling them on the slave database. But how to do it ? Is it possible to roll forward redo logs without doing recovery ?

Please e-mail me.

Rafael Styczen,
Telecomunication Department
University Cracow
Poland
e-mail: styczen_at_alfa.kt.agh.edu.pl Received on Sat Oct 29 1994 - 18:10:48 CET