Sunday, May 25, 2014

Physical Standby vs Logical Standby


Physical Standby
Logical Standby
Complete (Block-based) copy of the primary database.
Can be a complete or partial copy of primary DB.
Use Redo Apply method to apply changes.
Redo data is first converted into SQL statements and then applied to the standby database.
Redo Apply uses Managed Recovery Process (MRP) in order to manage application of the change in information on redo.
The Logical Standby Process (LSP) process manages the application of changes to a logical standby database.
In 11g, a physical standby database can be accessible in read-only mode while Redo Apply is working (Active Data Guard).
This method makes it possible to access the standby database permanently and allows read/write while the replication of data is active.
Unable to change anything on DB structure.
Read-Write mode enables you to create as many object as you need.
Supports all the data types.
One discouraging aspect of the logical standby database is the unsupported data types, objects, and DDLs.
Active Data Guard comes with extra cost.
Free of cost
Easy to configure, manage and less or no performance issues.
More steps to configure, complex to manage and more performance issues.


No comments:

Post a Comment