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 |
Oracle DBA FAQ >