I actually checked few Oracle Doc and even had worked lots with Dataguard but
never worked with Storage replication. All Oracle Docs as usual gave all
preference and best practices to use dataguard and so thought to check with
actual User experience.
Sanjay
On Saturday, May 2, 2015 2:23 AM, Hans Forbrich
<fuzzy.graybeard@xxxxxxxxx> wrote:
Have you looked at Oracle's documentation?
http://www.oracle.com/technetwork/database/availability/dataguardvsstoragemirroring-2082185.pdf
http://www.oracle.com/au/products/database/dataguardremotemirroring-086151.html
http://tkyte.blogspot.ca/2006/02/so-what-was-answer-part-iv.html
https://bartsjerps.wordpress.com/2011/09/28/dataguard-storage-replication/
That last reads like a sales pitch for mirroring, but it contains some useful
facts.
/Hans
On 01/05/2015 9:19 PM, Sanjay Mishra (Redacted sender smishra_97@xxxxxxxxx for
DMARC) wrote:
Can anyone share their views on the following on Real practical experience
with the setup in their environment. I had worked with dataguard but never with
Storage Replication for Disaster recover.
Some points for the required environment which can affect or help in
providing or sharing the experience
- Oracle 11g 2-Node RAC setup using ASM on both Primary and DR site
- Database size range from 1-5Tb
- Database has lots of DML activites on daily basis
Questions:
- What is the best option to be used for Disaster Recovery when has to
choose Storage Replication vs DataGuard for RAC setup and if can provide why
you think one preferred over other as per your experience ?
- Does there can be issue if Primary storage or server crashed and Recovery
either failed to start the Datbase on DR or lost some data ? Keeping in mind
that we are working in SYnc Mode.
- Is Storage mirroring can be setup so that both Primary and Remote storage
is almost SYNC like Synchronous Data Giuard Setting ?
- Is it possible that we may loose the DR location and Storage Replicated
environment failed to start ?
- Which one is faster to bring Database live, Storage mirrored DR env or
Dataguard based environment?
- How to go back or switch back to original Primary when you have done
switchover initially to DR location ? In Oracle Dataguard we can go back using
Flashback DB feature and reinstantiate the database
- Any other Pros and Cons for both option as well as any good Link to be
checked.
TIA Sanjay
