on 02-29-2008 3:35 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.