Skip to Content
Former Member
Feb 24, 2009 at 05:09 PM

Dataguard: switchover-switchback



I'm going to setup a dataguard scenario (1 primary and 1 stanby database) with ora 10204.

I would like to setup up also the switchover-switchback feature, but I have a question on it.

The rebuild of the stanby after an activation require to restore the whole stanby database from the primary environment.

I would like to use the switchover to solve this problem.

Suppose the customer want to test the quality of data of the stanby periodically (ie every week)

Instead to activate every time the stanby , I suppose to do the switchover of the stanby to primary, and at the same time to do the switchover of the primary to standby.

At that point the customer can verify the quality of data, and at the end I should be able to do the switchback of the databases to their original status.

The questions are :

1) what happen if a leave the primary as primay when I do the switchover of the stanby to a primary ?

Pratically I will have two primary database. Right ?

2) suppose the primary goes down and is not reachable at all (so the disaster happen).

It will be possible to do the switchover to a primary for the stanby and then , when the primary is rebuilt (in this case as stanby) to exchange their role using the switchback statements ?