Oracle Dataguard for SAP

[Former Member]

Hi All,

If anyone has a document or link to a online documentary on how to implement oracle data guard in SAP ERP environment please let me know.

Thanks in advance,

Shanaka.

[Former Member · Accepted solution]

Hi,

http://www.oracle.com/us/solutions/sap/wp-ora4sap-dataguard11g-303811.pdf

Regards,

Nikunj Thaker

[Former Member · Accepted solution]

Hi Nikunj,

Thanks for the link. I found this but I just wanna have something issued from SAP, such as SAP note.

Thanks,

Shanaka.

[Former Member · Accepted solution]

Hi,

Please check for sap note --> "Oracle features supported in SAP environment"

What is  your Oracle release ?

What is your DR design ?

Are you planing to configure physical standby or logical standby ?

To my experience i did not find any sap notes or document from SAP support. I may also be wrong...If you can find please share the same...

I would ideally suggest please google for "Oracle 10g dataguard setup" or Oracle 11g dataguard configuration.

If you are doing it for first time..take a backup of oracle home directotires and I would also suggest test all the scenarios between QLY and Standy location before start with PRD...

thanks,

rahul

[Former Member · Accepted solution]

Are you planing to configure physical standby or logical standby ?

You cannot use logical standby.

Regards

Roman

[Former Member · Accepted solution]

Hi Roman,

You are correct, --  > 105047 - Support for Oracle functions in the SAP environment

Refer to point  15. Data Guard

• You can use "Physical Standby".
• You cannot use "Logical Standby".

Some where i remember to read Oracle 11 supports logical standby configuration in SAP environment.(therefore i mentioned) Infact did not try practically also.

Thanks,

rahul

[Former Member]

Dear All,

Just by following above document "Setting up Oracle 11g Data Guard for SAP customers

" I was able to implement oracle data guard but there are some little errors which I hope i can resolve by some google searches ..

Regards,

Shanaka.

[Former Member]

Hi All,

Thanks Rahul  and thanks all for all of these valuable points . I'm planing for physical standby DB and  my DB version is oracle 11.2.0.3. I have implemented a environment same as our production in order to demonstrate this before implement in PRD env.

Also please state if someone has implemented this configuration referring to the oracle white paper mentioned above? 

I'll share if i found anything more ....

Thanks,

Shanaka.

[stefan_koehler]

Hi Shanaka,

cherish your attitude, but please get some training for that (or a consultant).

Data Guard is a solution for a disaster situation and you should not just copy and paste some instruction from a white paper (seriously). Get the basics first.

Regards

Stefan

[Former Member]

Dear Stefan,

Really appreciate your advice but If we have undergone oracle certification (OCA) will that knowledge sufficient to implement this or is there separate training for oracle data guard or any DR related activity in oracle?

Thanks,

Shanaka.

[stefan_koehler]

Hi Shanaka,

well OCA is a good starting point, but meaningless without any experience (the same way like with any other "certification"). Just attending some courses and answering questions by memorizing is not enough.

Implementing Data Guard for a SAP environment is not different from any other Data Guard implementation (for physical standby databases only). There is no specific training for Oracle Data Guard for SAP.

Have you ever heard of the following terms, know the impact and how to implement them: Data Guard Broker, Protection mode, LNS, RFS, RSM0, NSS, NSV, ARCH, LGWR SYNC / ASYNC / AFFIRM / NOAFFIRM, Switchover / Fail Over (manual or with broker), Reinstate, etc.

If yes you need no training or implementation partner for sure, but if not you really should get one first.

Regards

Stefan