Re: Help required on Data Guard

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 03 Dec 2004 11:06:18 +1100
Message-ID: <41afadf4$0$26294$afc38c87@news.optusnet.com.au>

Joel Garry wrote:
[snip]
> But of course, you could have brought up the logical v physical
> options, thank you for being nice.

I didn't even think to do so, but I don't think it makes any difference to what gets transported. In either sort of standby, it's always "bare" redo that gets shipped. It's what happens to it at the receiving end that makes the difference: it's either dropped straight into "log files" of some sort, and applied directly to the database (the physical standby model), or it's dropped straight into "log files" of some sort and a process mines it for SQL statements, passes those off to another process, and that second process executes those SQL statements (the logical standby).

In either case, it's just redo change vectors that make the journey over the wire...

But I'm over-simplifying myself now, and we've probably clarified what is going on enough for even the most avid Data Guard fan!!

Regards
HJR Received on Thu Dec 02 2004 - 18:06:18 CST