DR Setup Common Quaries

[Former Member]

Hi,

We are in process of Implementing DR setup uisng oracle datagurad. We are going for swithover configuration. I have few question regarding DR setup.

After the configuraiton of the DR setup, Is it necessary to up both the primary and stnadby SAP Instances?

Is there any configuraitons at SAP End before doing switchover over (makeing primary as standby and standby as primary)?

After the configuraiton of DR setup, can we execute any transaction at SAP Lelvel on the standby database? Suppose a transaction got updated then Is it a Sync DR setup?

I am uisng BRTools to build the standby server doing Backup of Primary and Retoring the database to standby. Is is a good procedure to follow or go with sapinst. If its good, what are the post restore activites to be done onthe standby server?

Regards,

Mohammed Nisar

[Former Member · Accepted solution]

Hi,

Without knowing proper use / config, its really very difficult.

i will give you some oral ideas of the DR setup.

Look into the below steps very carefully..

1. Both servers filesystem need to be same.(as per the size also).

2. Never open the DR database. PR should be on the open mode.

3.make the needed changes on init<SID>.ora on both the sides acordingly (transfering arch files to DR <-> PR)

4.Restore the recent backup on DR and apply all the logs.

5.open the database on nomount stage and perform the DR sync activities.

PR should be on ->primay and DB open mode

DR should be on -> Physical and DB Mount mode.

use tcode st04->additional fun / detail analysis menu ->Display v$ views ->V$ARCHIVE_DEST_STATUS

here u can see the applied logs and db mode on ur PR and DR.

use the below sql for check whether log applied or not.

SQL> select sequence#, applied from V$archived_log;

ans is YES should be on logs.

Please do more analysis before implementing DR.

With Regards,

CSK