Newsletters Archive - All

If you would like to know more about the 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