If you would like to know more about the iDevelopment.info Newsletter, please email me.
Activating the Standby Database - (Oracle 10g, Physical Standby) (16-December-2010)
The tasks involved in creating and managing a Data Guard configuration are fairly straightforward. Once the standby database is put into operation, you are happy, your customer is happy, management is happy - everyone is happy with the piece of mind that their data is being replicated to their disaster recovery site. But the time will eventually come where the inevitable will occur and the primary database becomes unavailable. You are now faced with failing over production activities to an available standby database. Other circumstances can also arise where scheduled maintenance needs to occur on the primary database and database operations need to be switched over to the standby database. In either case, the role of the primary database and the standby database will need to be changed. This is known as Role Transition and is the subject of the following article: Activating the Standby Database - (Oracle 10g, Physical Standby) It is assumed that a primary and one physical standby database is already configured in order to perform the role transition steps described in this guide. The examples used in this guide will make use of the Oracle Data Guard configuration described in the article: Data Guard Configuration Example - (Oracle 10g, Physical Standby) ---------------------------- Jeffrey M. Hunter, OCP Sr. Database Administrator email@example.com http://www.idevelopment.info ----------------------------