| Replication serving [message #75200] |
Fri, 28 June 2002 15:24  |
M. Millar
Messages: 1
Registered: June 2002
|
Junior Member |
|
|
I have two short questions that I am sure have long answers.
1. When using Oracle replicator is there a way to configure the servers such that if one fails the other
will immediatly take over without interruption of service.
2. Approximatly how long does the average failover take. I realize that boot times etc will influance this number.
|
|
|
|
| Re: Replication serving [message #75217 is a reply to message #75200] |
Sun, 21 July 2002 17:39  |
David Simpson
Messages: 29
Registered: May 2002
|
Junior Member |
|
|
M. Miller,
With Oracle Advanced Replication there is no failover timeframe on the actual database servers - both servers are running all of the time. In fact you can load balance and read/write data into both of them at the same time.
You can configure TAF on the client side, and this failover will occur the next time an attempt is made to connect to the 1st database, if it can't be accessed, the connection will be made to the 2nd database. The use just needs to disconnect, then re-connect whenever they have any type of issue with the 1st database.
You may find the following sample replication setup scripts to be helpful:
http://www.dotcomsolutionsinc.net/products/repgen/repgen_files.html
I have also linked a technote on replication design/setup which could be helpful.
David Simpson
www.dotcomsolutionsinc.net
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
