cancel
Showing results for 
Search instead for 
Did you mean: 

DB Mirroring Steps

erugu_suresh
Participant
0 Kudos

Hi All,

I am configuring DB mirroring for High Availability of ECC EHP6

here I am following below steps

->install SAP at Mirroring Site

->set the profile parameters according to KBA 965908

->stop AS at mirroring site

->Restore Full Backup of Primary site (With No Recovery Option)

->Restore Log Backup of Primary site(With No Recovery Option)

->Configure DB mirroring from Primary Site using Management Studio

->Enter Witness Site details

->Enter Mirroring Site details

->Start DB Mirroring

Can you please check and let us know if anything I am missing.

Also I have another doubt  regarding automatic failover.

- By doing above steps am I able to connect to Mirroring site when Primary site when down.?

If I want automatic failover what configuration needs to apply from DB and SAP side.

Thank you in advance.

Environment:

OS: Windows 2008 R2

DB: SQL Server 2008 R2

SAP: ECC6 EHP6

Regards

Suresh

Accepted Solutions (1)

Accepted Solutions (1)

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

1. From the step you have to restore the Ms Sql master db from primary to mirrored site. refer the SAP Note 965908 - SQL Server Database Mirroring and SAP Applications


2.


Also I have another doubt  regarding automatic failover.

- By doing above steps am I able to connect to Mirroring site when Primary site when down.?

If I want automatic failover what configuration needs to apply from DB and SAP side.

  Refer the SAP Note 965908.

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

Thank you!

I have configured the systems as per the above note, but witness server not connected. How to check mirror logs from db side?

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

From the Sql MMC DB level you can launch the Database Mirroring monitor. refer the Microsoft link Start Database Mirroring Monitor (SQL Server Management Studio)

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

Thank you for the link.

I have configured DB mirroring and both servers are synchronized.

When I try to do manual fail over, SAP application is not connecting to mirroring DB.

What could be the reason? Here i have maintained parameters in both systems (Principal&Mirror).

Thank you in advance.

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

Any Error message?

Kindly follow the steps

1. Stop the SAP instance

2. Switch the DB to Mirrored site and run the command "R3trans -d "

Attach the r3trans log file

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

please find the below trans log and screen shot of R3trans -d

trans.log

4 ETW000 R3trans version 6.24 (release 721 - 26.09.13 - 20:13:07 ).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time   : 26.07.2016 - 10:52:12

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000  trace at level 2 opened for a given file pointer

4 ETW000  [     dev trc,00000]  Tue Jul 26 10:52:12 2016                                                  70  0.000070

4 ETW000  [     dev trc,00000]  db_con_init called                                                        26  0.000096

4 ETW000  [     dev trc,00000]  set_use_ext_con_info(): rsdb/ssfs_connect not set => ssfs not used        34  0.000130

4 ETW000  [     dev trc,00000]  determine_block_commit: no con_hdl found as blocked for con_name = R/3

4 ETW000                                                                                                  20  0.000150

4 ETW000  [     dev trc,00000]  create_con (con_name=R/3)                                                 13  0.000163

4 ETW000  [dbcon.c     ,00000]  *** ERROR => Invalid profile parameter dbms/type (or environment variable dbms_type) = <undef>, cannot load DB library

4 ETW000                                                                                                  44  0.000207

2EETW169 no connect possible: "connect failed with DBLI_RC_LOAD_LIB_FAILED."

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh

Thanks for your information.

You have to check the profile parameter and Windows Os level environment variable in SIDADM user kindly refer the SAP Note for profile parameter

2020535 - Profile parameter conn_opts


BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

I have configured above parameters as per the above note but issue remains same.

Do I need to do any configuration from SQL Native Client side. If yes please guide.

please find the below error logs

Principal Server logs

Mirrored Server logs

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

Have you restore the Master db from principle to Mirrored site? I think all the DB level authorisations are stored in Master DB. may be it connect from SAP application to DB

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

No I have not restored Master DB, I have restored only QUA db. I will restore other databases as well and let you know the result.

Thanks once again.

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh

Have you followed the steps as mention SAP Note 965908 topic " Configuring SAP Applications for Database Mirroring" ?

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

Yes I have followed the above and it is also mentioned in the first post.

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

You have to restore the master DB in single user mode and then check the connectivity from SAP application to mirrored site.

BR

SS

erugu_suresh
Participant
0 Kudos

Hi Sriram,

I am unable to restore master db in single user mode.

Can you please guide me.

I tried to start db in single user mode using -m in startup parameters but db is not starting.

Regards

Suresh

Sriram2009
Active Contributor
0 Kudos

Hi Suresh.

I think you have to stop the mirroring,

1. Restore the SAP DB in Mirroring site.

2. After restored start the MS Sql in single user mode and then restore the master db

3. Once again do the configure the Mirroring.

BR

SS

Answers (1)

Answers (1)

luisdarui
Active Contributor
0 Kudos

Hi Suresh,

Were you able to finish the completion of the configuration?

I followed this discussion and so far wanted to know if you could complete the task.

Best regards,

Luis

erugu_suresh
Participant
0 Kudos

Hi Luis,

I have not configured this, instead we have implemented log shipping.

Regards

Suresh