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.