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