Feb 25, 2012
Difference between Physical Standby and Logical Standby
3.8K

Difference between Physical Standby and Logical Standby

Physical standby: ============ 1. Physical standby schema matches exactly the source database. 2. Archived redo logs and FTP’ed directly to the standby database which is always running in “recover” mode. Upon arrival, the archived redo logs are applied directly to the standby database. Logical standby: =========== 1. Logical standby database...