RE: Best practices using Dell Equalogic San Block-based Replication

        We use a similar technology but from NetApp instead. The fun is how often the replication fires. Ours does so every 24 hours so any database in the dr region can be as much as 24+ hours behind its primary. When you start the db it will go through crash recovery because that's what the db thinks happen. The FUN is how the software replicates your data. NetApp does it by taking a snapshot of the entire db at a specific moment in time so the control files and redo logs line up as if the db just crashed. Other packages do similar things with mirrors (and you thought smoke and mirrors was only for Hollywood!) which again gives you a consistent picture of the db. I have heard of a couple of products that are not that smart & you can then have issues. Don't know if your product is one of them. A lot of the success or failure of doing this is what can the business tolerate for stale data and downtime? While this can be a cheaper solution your data at the remote site is not   going to be available until you mount the file systems and start up the databases. Also don't forget you can't have an HP-UX server over here and a Linux one over there. Doesn't work, BTDT because some management types believe they know better.

Richard Goulet
Senior Oracle DBA/NA TEAM Lead

This communication, including any attachments, is intended only for the person or entity to which it is addressed and may contain confidential material. Any review, retransmission, distribution or other use of this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  Thank you.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of April Sims Sent: Friday, January 04, 2013 11:41 AM
To: ORACLE-L
Subject: Best practices using Dell Equalogic San Block-based Replication

We are implementing a Dell Equalogic San Replication to a remote site which I understand is block-based. What are the best practices for Oracle Database replication for high availability and disaster recovery using this hardware? Pro's and Con's
We already use DataGuard for a different Oracle database for remote HA/DR...is there any reason to change now?

thanks

--

April C. Sims
IOUG SELECT Journal Executive Editor
http://aprilcsims.wordpress.com
Twitter, LinkedIn
Oracle Database 11g - Underground Advice for Database Administrators <http://www.amazon.com/Oracle-Database-Underground-Advice-Administrators/dp/1849680000/ref=sr_1_1?ie=UTF8&s=books&qid72289339&sr=8-1#noop> https://www.packtpub.com/oracle-11g-database-implementations-guide/book OCP 8i, 9i, 10g, 11g DBA
Southern Utah University
aprilcsims_at_gmail.com

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 04 2013 - 20:44:42 CET