Disaster Recovery Post Configuration

[anvardheen_jabarullah]

Dear Experts,

I have got requirement to build DR set-up for our ECC Production. I have got some material and found server build same like as ECC Standalone installation method. Just let me want to know about post steps

1) Whether same post steps to be performed in DR server?

2)Else what are the extra steps to performed once DR system is ready?

3)Kindly provide any document or SAP reference note for checking further?

[Former Member]

Hi Dheen,

What kind of "disaster" you plan to handle ? It could be as small as a server box down , or as big as your whole data center destroyed. I assume you're not talking about the small one which can be solved by "clustering".

Do you have any measurable goal for this "DR" ? such as max service downtime allowed, and max data loss (in terms of time).

If you don't have any requirement, you just need to install SAP on DR site and restore the DB from backup of primary site. Make sure the backup media can be available after the disaster.

If you have strict downtime requirement, you probably need to pre-install your SAP on DR site, keep the configuration sync periodically.

If you have strict data loss requirement, you probably need to setup DB replication (or log-shipping-like machanism) between different sites. Not sure Always-On is doable on SQL2008, but you better check this.

[Former Member]

Hi Dheen,,

The DR setup and configuration will vary depending on the OS and DB in your Environment. Once you provide those details, The people in the forum can help you out with different tools and methods used pertaining to that Database.

Thanks,

Jagadish

[anvardheen_jabarullah]

Hi All,

Find my system details

OS:Windows 2008

DB: MSSQL 2008 ( 10.00.5500.00 )

[Former Member]

Hi Dheen,

For SQL Server 2008 R2, You can use MS SQL Log shipping method to configure the DR .

https://msdn.microsoft.com/en-us/library/ms190640.aspx

Also check the SAP Note

2021980 - How to setup logshipping on SQL Server 2008 or higher

Thanks,

Jagadish

[Sriram2009]

Hi Dheen

You can use the MS Sql DB mirroring shipping using the SAP note

965908 - SQL Server Database Mirroring and SAP Applications

Regards

SS

[divyanshu_srivastava3]

Hi AJ,

For post steps, you should replicate a scenario for checking fail-over.

Other question is what is your requirement in terms of HA/DR ?

You can also refer certain thread on SAP and MS for HA and DR.

High Availability and Disaster Recovery (OLTP)---a Technical Reference Guide for Designing Mission-C...

https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=2&cad=rja&uact=8&ved=0CCMQFjAB&url=h...

Microsoft SQL Server Database Mirroring - SAP Business Continuity - SAP Library

Regards,

[Sriram2009]

Hi Dheen

1) Whether same post steps to be performed in DR server?

2)Else what are the extra steps to performed once DR system is ready?

1. Yes, You can perform the normal post installation tasks on the DR standalone system. and during off time you switch the process to DR site and check the all the production environment activity's.

2. After completion of your DR drill, you can do the Database replication (Either mirroring or log shipping based on your OS /DB) from primary to DR site.

3. You can play with DNS to switch primary SAP instance & DB to DR. for this you can get in touch your network administrator. They may guide you.

3)Kindly provide any document or SAP reference note for checking further? 

All depends on your OS / DB vendor best practices

Regards

SS

[divyanshu_srivastava3]

Hi AJ,

Please share your OS and DB details.

Also, read some SCN thread on DR suiting your requirements

DR (Disaster Recovery) server installation. | SCN.

Regards,

[Former Member]

Hi Dheen,

Can you please update what setup you have for DR as based on the DB and OS version it may vary.

For a Oracle, In general below are the steps carried out for a system

1. Install SAP on DR site (including CI & DB)
2. Add all relevant entries in /etc/hosts & /etc/services for connected systems
3. Stop SAP in primary site
4. enable force logging in primary site, copy datafile from Primary site/or Old backup
5. Create a backup control file at primary ship it to DR
6. Add TNS entries on primary and DR site for communication
7. Start the DR server in nomount state
8. mount the standby database
9. Ensure that logs are being shipped and applied.
10. Map the Ip address for the DR site to your cluster name/ DNS entries changes so that same can be used.
11. Start the SAP in DR
12. Perform validations

You can refer below links for Oracle & Sybase confirgurations:-

Let us know if this helps.

Regards,

Ram