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.
|
Sunday, May 25, 2014
Physical Standby vs Logical Standby
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment