What is the difference between Data Guard and Standy Database.
A reader, December 27, 2005 - 2:06 pm UTC
Hi Tom,
What is the difference between Data-Guard and Standy-Database. If there is one!
Thanks
December 27, 2005 - 2:27 pm UTC
consider them synonymous for all intents and purposes - data guard is an extra layer that automates the failover database stuff (shipping of logs, log application, GUI, etc ...)
you could do a standby in 8i and before - but it wasn't data guard, data guard add bits on top of having a simple standby that automate it for us.
Does Standby-database still exists?
A reader, December 27, 2005 - 3:04 pm UTC
Tom,
Thanks for the quick feedback. Does the Standby-database still exists, as a product, in 9i and 10g -- or it has been phased out already.
Thanks
December 27, 2005 - 3:09 pm UTC
It isn't really a "product" in as much "a feature"
</code>
http://www.niall.litchfield.dial.pipex.com/ <code>
ctl-f for You Probably Don't Need DataGuard - running a standby database on Standard Edition
Licensing Issue
A reader, December 30, 2005 - 11:40 pm UTC
Thank you for quick responce.
Is There Any Licensing Issue Using DATA GUARD AND RAC
thanks
DATAGUARD LGWR SYNC AFFIRM
Parag J Patankar, August 29, 2006 - 7:30 am UTC
Hi,
I am in process of setting up physical standby database on 9.2. I want to log shipping from LGWR, and I want database protection mode should be maximum availability.
So in log_archive_dest_2 of primary database I have set following parameters
SQL>show parameters log_archive_dest_2
log_archive_dest_2 string SERVICE=stndby LGWR SYNC AFFIRM
So I belive whatever I do changes should "shipped" to standby site by redo data. ( I have created standb redo logs on standby database )
But on primary database if I do changes in tables and commit, These changes are not getting applied to standby database after I open it as read only. In alerts ( production + standby ) it does not show me anything wrong.
On standby site it shows me
log_archive_dest_1 it shows me ora-00354 corrupt redo block header
My questions regarding this
Q1/ How do I correct this error ?
Q2/ If I setup log shipping thru LGWR SYNC AFFIRM how logs will get applied to standby ? If I do changes in table on primary ( very small change ) and if I open standby database can I see changes immediately ? ( assume that there is no network issue ) am I correct ?
thanks & regards
PJP
Great differentiation between products
A reader, September 27, 2006 - 1:13 pm UTC
Great differentiation between products - was a blur to me the difference, then again I only heard about them as intangibles that our business does not seem to work with. But getting the clear distinction and detailed explanation helps it getting my company to want to start using these tools.
Thanks!
What is RAC cluster guard
A reader, October 16, 2006 - 1:33 pm UTC
Tom,
In 9i there was a RAC cluster guard which is not present in 10g. Is this merged into Data Guard?
Thanks
October 16, 2006 - 5:41 pm UTC
That was a holdover utility from 8i parallel server days as an optimization for fast failover from node 1 to node 2 (in effect - we used one node, the other was "warm" for a fast failover.
with RAC - became obsolete, with 10g, obscured from view ;)
simple
A reader, September 30, 2012 - 5:16 pm UTC
awesome simple explanation. i notice the people that really know what they are talking about explain things in a simple way.