on 07-22-2016 3:29 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
Hi Suresh
Have you followed the steps as mention SAP Note 965908 topic " Configuring SAP Applications for Database Mirroring" ?
BR
SS
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.