Advice on Oracle Replication

[TWBSupport]

We're looking at maybe setting up a replication environment for our Oracle 9i database. We run this on an rp2470, aprox 3G in size. Can I get any opinions on Oracles replication or are people using something else to replicate Oracle? Thanks in advance.

[Steven E. Protter · Accepted solution]

To use Oracle replication, you'll need plenty of band width. Then you can set up hot replication of the data and transactions as they happen.

This can be used to provide fault tolerance, database failover and the like.

You could do the same thing with an Oracle Service Guard cluster, if reliability and uptime is the goal.

If you just need a copy of the data you can down the database and copy the database files to the second server. We call that cloning and do that periodically in our shop.

SEP

[TWBSupport]

Thanks Steven. We are a 24 X 7 shop, & to get actual maintenance time for patches & what not is like pulling teeth. I want to be able to bring one server down, point the clients to the other server that has the synchronized data (within a few transactions), then once maintenance is done, bring them back over if need be, or use them as a rotation of some sort. I need the switch over to be less than 15 minutes. I have done this with Sybase servers using Sybase replication server, but I haven't done this with Oracle.

[Steven E. Protter]

This thread has a cookbook and links on how to do the Replication server.

http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0xf15f50011d20d6118ff40090279cd0f9%2C00.html&admit=716493758+1068232610700+28353475

I think it will provide anything you need. We're planning on this for the middle of next year so I'll say thanks for pointing this issue out.

SEP