Oracle real time database mirroring

mirroringoraclereplication

Does Oracle have any built-in features to support a master-slave mirroring mechanism ?

I am looking to mirror/replicate the production server on to a read-only database. The read-only database would be used for reporting and such purposes.

We are using Oracle 10gR2

Best Answer

Oracle Dataguard is what you want. It provides a master-slave configuration for up to 9 slaves (which is pretty impressive!)

Its expensive though, you need Oracle enterprise edition.