Hi all, I have two Win2k servers, each with UDB V7.2 Enterprise installed. One will be used as a backup server. I like to set up a standby database to be a replica of a primary database and is maintained by applying archived redo logs from the primary database to the standby in order to keep them synchronized. When the system crashes, I need to failover to the standby database.
Since I haven't done this before, I would appreciate if someone could give me some guidance on how I could approach this situation. Can I use the standard UDB replication tools to set up this standby database or do I need any other products to achieve this failover feature? Because if the system crashes on the primary server, it is impossible to apply the archived redo log to the target server. What is the different between standby database and database replication ? If I want to replicate the whole database from a source to target server, Is there a way to replicate the whole database rather than table by table. It is quite troublesome to setup the replication by table name if I would like to replicate the whole database Creating a Standby Database sounds like what you're wanting to do. A standby database is basically a replica of a primary database and is maintained by applying archived redo logs from the primary database to the standby database in order to keep them synchronized. If the primary database is lost (system crash, data corruption, etc), you can failover to the standby database. In this case, the standby database now becomes the primary database. The only issue I see is that you said you want to be able to switch back to Server 1 after it has been recovered. The way a standby database works is that once it becomes the primary database, it stays the primary database. Basically, once you get your crashed server back up, you'd then make it the standby database and typically wouldn't attempt to "switch back."
------------------------------------------------------------------------This email is intended for the named recipient only. The informationcontained in this message may be confidential, or commerciallysensitive. If you are not the intended recipient you must not reproduceor distribute any part of the email, disclose its contents to any otherparty, or take any action in reliance on it. If you have received thisemail in error, please contact the sender immediately. Please deletethis message from your computer.------------------------------------------------------------------------
