Home » Server Options » Data Guard » data guard...!!!!
data guard...!!!! [message #353959] Wed, 15 October 2008 21:42 Go to next message
Messages: 7
Registered: August 2008
Junior Member
Hi all,

During DATA GUARD implementation,

For PHYSICAL standby databases, Data Guard uses REDO APPLY technology,
For LOGICAL standby databases, Data Guard uses SQL APPLY technology, i.e., it first transforms REDO data into SQL statements.

Why does DATA GUARD transforms REDO data into SQL statements, rather than applying REDO data directly , like in the PHYSICAL standby database.

I guess , I am clear about the question. Please help me out, I am bit confused.

Thanks in advance.
Re: data guard...!!!! [message #353973 is a reply to message #353959] Wed, 15 October 2008 23:33 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Simply because redo application is bloxk modification that is physical modification and this is not possible with logical data guard as physical implementation is not the same, so Oracle has to transform the physical modification to a logical one, that is a SQL statement.

Previous Topic: Is there a max number of mins for DELAY parameter?
Goto Forum:

Current Time: Sat Oct 22 23:14:37 CDT 2016

Total time taken to generate the page: 0.07881 seconds