Alejandro Vargas' Blog

  • September 19, 2007

Data Guard or Storage Snapshots?

Alejandro Vargas
Technical Leader, ACS Global Delivery, Infrastructure & BigData

Customer sites often choose storage related technologies to ensure recoverability for large databases. I've been involved several times in recovering production databases from a BCV or SRDF backup. Mounting the storage copy back on the production server was done usually in about 30 minutes, after a period of deciding what to do that could take another 30 minutes to 1 hour. Then we needed to apply the relevant redo logs, that required a time that sometimes was of several hours.

In my opinion, for sites requiring maximum availability storage snapshots do not provide the best high availability option.They are excellent for building up report databases that are refreshed every day, or for cloning test, QA, development or training databases from production.

10g Data Guard provides the most efficient environment for  disaster recovery, it can be configured in several ways to match different sets of requirements, and, together with RAC conforms the Maximum Availability Architecture, that ensure the maximum levels of service.

Configuration and management of Data Guard was made simple through the interface that Oracle Enterprise Manager Grid Control provides.

Still it can also be manually implemented and managed with some training.

Join the discussion

Comments ( 1 )
  • Chai Tuesday, January 8, 2008
    Interesting. How big was the database? The site I am dealing with uses multiple 100'TB databases. What is your take on it? DG or mirror?
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.