ORA-DR-RoleSwitchOver-Test

[Former Member]

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

[Former Member]

Yes,

As told by Stephan you can perform the switch over test while SAP is up.

But before recovering the DB and apps, make sure that you have only intance specific tnsnames and listener files.

This is required to break the connectivity between primary and secondary.

I suggest to disable the secondary archive destination which disconnects the archivelog shipement from primary to secondary before starting the DB recovery on secondary.

Regards,

Nick Loy

[Former Member]

It was great support from all you guys, really appreciate !!!!

Our Switcover test was successful.

NOTE: We had shutdown the SAP, before performing test

[stefan_koehler]

Hello Deepak,

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

Have you enabled FORCE LOGGING on the database or changed the customizing in SAP to LOGGING?

If not .. forget your DR setup and bulit it up again.

--> Can we move back to Our old configuration on successful switchover ?

Yes in case of a SWITCHOVER you can go back easily (just switch back) .. if you do a FAILOVER you need FRA (flashback enabled).

Regards

Stefan

[Former Member]

Thanks Stefan!!

Force logging is enabled.

So during this operation will there be any data loss???....and do i need to put down SAP application for this activity??

[stefan_koehler]

Hello Deepak,

So during this operation will there be any data loss???

Not in case of a switch-over .. how long the switch-over takes depends on your configuration.

Also just reading the documentation would answer your question:

-> http://download.oracle.com/docs/cd/E11882_01/server.112/e17023/sofo.htm#DGBKR3401

A switchover guarantees no data loss and is typically done for planned maintenance of the primary system. During a switchover, the primary database transitions to a standby role, and the standby database transitions to the primary role.

and do i need to put down SAP application for this activity??

Not mandatory .. i have performed several switch overs while SAP was running .. you just need to modify the tnsnames.ora file that is used by SAP to redirect the connection retries to the new primary database.

Regards

Stefan