How to make things Highly Available in Oracle SE Environment

rc_2014_7 DBVisit Standby – No, can it..?

In late July this year I wrote a small article about a software that can bring high availability also to an Oracle Standard Edition Database environment. This piece of art is “DBVisit Standby”, and I might like to call it the little brother of Oracle Data Guard, even though their not relatives 🙂 Heh Heh….

As we all know or have heard, big brothers does things in a better, smarter or what ever “superlative  of an adjective or adverb you can think of”- kind of way.

So you must be aware of the facts about what the Data Guard can provide but DBVisit Standby cannot. And your company must check the requirements of the software that will be using the database, check possible laws and regulations, or whether your data is really sensitive and therefor just need the Oracle Enterprise Edition and some of its amazing options.

But as I said in the article I wrote in July about Data Guard vs DBVisit Standby. Only you as the DBA and your companies Business Management can tell which version of the database you need, and after that you know which one of these two High Availability software’s you will need.

DBVisit Standby – Can it offer Active Data Guard(=ADG)?

I have now had the pleasure of working with DBVisit Standby on a sandbox, and I enjoy the software and the opportunities that it can bring to an Oracle Standard Edition Database environment.

The ADG is a concept within Data Guard and remember it can only be used in an Oracle Enterprise Edition Database environment. It is an feature with an extra cost. What can ADG provide?

  • ADG enables a physical standby database to be open read-only while Redo Apply is active; queries run against the standby database receives results that are up-to-date with the primary database.
  • Read-only queries and reports can be offloaded from primary
  • RMAN backup offload
  • Easy to test the readiness of your Disaster Recover(=DR) solution

Dbvisit Standby can’t offer this ADG mode, but maybe the Dbvisit Replicate software can be an option in an Oracle Standard Edition environment?  I have not yet had the time to get acquainted with DBVisit Replication, but it is on my ToDo-list, so I might return to this subject. My first glance at the documentations made me believe, that some kind of ADG can be built even in a SE environment.

Now you as a DBA for a Standard Edition Database  are able to tell the management:

“We can get HA in the Oracle SE Database. Our software vendor claims their software does not use EE features and our data does not requires any Oracle Enterprise Edition special features. RAC feature comes for free with Oracle Standard Edition, and DBVisit software’s will give us not only the ability to build a standby database for disaster purpose, but  also an environment for our Analytic Reports, to ease the workload of the production system “.

Did You became curious? Check the other pages under this “left-side-menu”.

Have a lovely day!

ann . sjokvist (a) miracleoy . fi 

2 thoughts on “How to make things Highly Available in Oracle SE Environment”

  1. Hi Ann

    I see your post very usefull, but I was wondering if this point of view still covers DBVisit Standby 7 version, which already able to open de DB in Read-Only mode and still accepts the redo log to be apply from the source. This as I see it is like the Active Data Guard feature. I am correct?

    Thanks, in advance.

    JB

    1. Hi Juan,

      Welcome, and lovely that you have found it useful!
      Yes, I have had the pleasure to implement and use Dbvisit 7, so this article is from that perspective. Thanks for pointing this out. I need to add that information.

      According the Dbvisit Standby 7 and Active Data Guard feature comparison, I would suggest you read my post http://wp.me/P5Q1h0-3j about the primary difference between these two products, or even better the great book Data Guard Handbook. That book will deepen the understanding about the big difference between these two softwares, and it would be wrong to simplify and say that these two softwares are a like.

      For people not acquainted with Dbvisit Standby 7, the “Reporting DB option” is a great way to offload the workload from the Primary DB, BUT by doing so, one need to remember that the archive logs will only be shipped to the “Reporting” Standby DB, and this “Reporting” Standby DB will not be synchronized with the Primary DB until the “Reporting” Standby DB is changed to “Recovey mode”. All these steps can easily be automated, and Dbvisit have provided great information about how to accomplish this (http://blog.dbvisit.com/the-power-of-oracle-services-with-standby-databases/). And yes, as a Standard Edition Advocate I think Dbvisit Standby is a very good opportunity for SE/SE2 environments.

      Have a lovely day!
      Ann

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

oracle standard edition license pitfalls

Follow me

Click to Follow

%d bloggers like this: