I have two Win2k servers, each with Oracle 8.1.7 Enterprise installed. One will be used as a backup server. I need to be able to toggle between both.
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."
Standby databases have a lot of requirements for creating and configuring. I'd suggest that you read the Oracle Standby Database Concepts and Administration guide to get all the details and to determine if this solution meets your needs.
For More Information
- What do you think about this answer? E-mail the editors at editor@searchDatabase.com with your feedback.
- The Best Oracle Web Links: tips, tutorials, scripts, and more.
- Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical Oracle and SQL questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in February 2002