Skip to Content
0
Former Member
Apr 18, 2011 at 12:17 PM

ORA-DR-RoleSwitchOver-Test

57 Views

Guys,

We have SAP BW 7.01 setup on AIX6.1 TL5 / Oracle 11g in cluster environment.

We also have Disaster Recovery configured for DB Node using DataGuard Broker(DGB).

In DGB confguration-BWDR we have 2 DBs namely BP1(Primary) & BP2(Standby) .

***************************************************

DGMGRL> show configuration

Configuration - BWDR

Protection Mode: MaxPerformance

Databases:

BP1 - Primary database

BP2 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

***************************************************

We are planning to perform DR Role SwitchOver Test using command

> switchover to 'BP2'

--> what are the precautions we have to take beforehand ?

--> Can we move back to Our old configuration on successful switchover ? ....If not then does it mean we have to perform DB-Restore on actual production system (currently acting as Standby Server) & redo the entire conffiguration