Oracle DBA FAQ‎ > ‎

What is the main difference between physical and logical standby databases

posted Sep 10, 2010, 2:03 PM by Sachchida Ojha
The main difference between physical and logical standby databases is the manner in which log apply services apply the archived redo data.

For physical standby databases, Data Guard uses Redo Apply technology, which applies redo data on the standby database using standard recovery techniques of an Oracle database.

For logical standby databases, Data Guard uses SQL Apply technology, which first transforms the received redo data into SQL statements and then executes the generated SQL statements on the logical standby database
Comments