Disaster Recovery SAP ECC on Oracle Exadata to the Cloud using Oracle Data Guard

[former_member144033]

Dear Expert,

We would create a DR soluiton between a SAP Netweaver on Oracle Exadata (on-premise) and an Oracle on Public Cloud.

Do you know if is possible to configure Oracle Data Guard, in async mode, to replicate the data ?

if it's possible, are there any documentation about it ?

Best Regards

[former_member144033]

Thank you James,

I can't find anything specific in the document but I found in this Oracle document Oracle Data Guard: Disaster Recovery for Oracle Exadata Database Machine (Data Guard and the Oracle Sun Database Machine) in the paragraph "Heterogeneous Data Guard Configurations and HCC; Oracle recommends that Data Guard primary and standby database both be deployed on Oracle storage whenever HCC is used (e.g. any combination of Exadata, Sun ZFS, and Pillar Axiom 600 storage)." so I understand that, if I use HCC compression, I can use the replication with DG only on VM with Oracle storage.

[JamesZ]

Welcome.

use SAP specific data guard guide + oracle.comd data guard guide, if there is anything unclear and undocumented in SAP, a better way is to raise ticket to SAP support (if you are SAP customre), then SAP development needs to verify whether any oracle.com's comment is suitable to SAP.

However regarding Heterogeneous database, SAP very very strongly not recommened.

[kuensang_lam]

Hi,

SAP with Oracle DB HCC is ONLY supported on Exadata technology or Oracle storage that supports HCC with Row Level Locking. If the primary site is on Exadata with HCC enabled, the DR site can be on premise or cloud but must also be on Exadata or supported HCC storage devices. On premise would be standard Exadata machine or Exadata Cloud@Customer or other servers with supported HCC storage devices. On the cloud would be Exadata Cloud Service or Exadata Cloud@Customer.

If HCC is not used on the Exadata in Primary site then the DRC can be non-Exadata based and non-HCC storage based. Of course there would be expected performance hit if there is no Exadata acceleration on the DRC.

[JamesZ]

Is this link helpful?

https://www.sap.com/documents/2016/12/a67bac51-9a7c-0010-82c7-eda71af511fa.html

If log writer is used, it is already ASYNC.

And I don't see limit on data guard limit for HCC, but for HCC SAP has limitation, for details, check SAP note 105047.

[former_member144033]

Thank you Janos for your answer, the connection will be not a problem, I had the doubt on Exadata as source and the possible HCC compression of some table.

[janos_mucsi-besze]

Hi,

I think this is just the same configuration as ever. The problem might be to access the Cloud from outside, which I don't thing would be so easy.

But based on my experience, this is nothing else just a regular DG configuration with some flavour because of the Exadata and Cloud. But at the end we are still talking about connecting Oracle DBs.