cancel
Showing results for 
Search instead for 
Did you mean: 

Standby database for "real" disaster recovery

gecanessa
Explorer
0 Kudos

Customer wants to setup a DR scenario using Oracle Dataguard. By "real" DR I mean all possible disaster, including primary site destruction, etc.

Customer can tolerate an RPO (Recovery Point Objective) or data loss of 1 hour. This will be the case when some redo logs are lost in the disaster.

The problem is: the customer wants a DR scenario for SEPARATE ERP and WMS SAP systems. So, with two separate Oracle DBs, and two independent Dataguard setups, Is there any procedure to re-synchronize ERP and WMS databases, to reestablish SAP consistency at any point in time (considering that data loss will be different for each database)?

Is a standby database a recommended setup for this case?

Accepted Solutions (1)

Accepted Solutions (1)

lbreddemann
Active Contributor
0 Kudos

Hi Glen,

one option to implement such a multi-system-standby is to use a storage system that handles the data shadowing to a second location.

It's usually far more expensive than the software solution (dataguard), but if e.g. also the redo disks are synched than you won't even loose any committed transaction.

Without something like that - no there is no efficient way to synchronize several systems in a reasonable amount of time. And especially not for a failover scenario.

KR Lars

Answers (0)