What is difference between physical and Logical Standby
Physical Standby:
============
1. Physical standby schema matches exactly the source database.
2-Provides a physically identical copy of the primary database, with on disk database structures that are identical to the primary database
on a block-for-block basis.
3- The database schema, including indexes, are the same.
4-A physical standby database is kept synchronized with the primary database by recovering
the redo data received from the primary database.
5-High availability solutions Or disaster recovery Solution.
6-It is open Mount Stage.
Logical Standby:
===========
1 Logical standby database does not have to match the schema structure of the source database.
2 Logical standby database can be used concurrently for data protection, reporting, and database upgrades.
3 This Kind Of Configuration can be Opened in Read Only Mode .
4 Can have additional materialized views and indexes added for faster performance
5 Logical standby tables can be open for SQL queries (read only), and all other standby tables can be open for updates.
6 This allows users to access a logical standby database for queries and reporting purposes at any time.
Physical Standby:
============
1. Physical standby schema matches exactly the source database.
2-Provides a physically identical copy of the primary database, with on disk database structures that are identical to the primary database
on a block-for-block basis.
3- The database schema, including indexes, are the same.
4-A physical standby database is kept synchronized with the primary database by recovering
the redo data received from the primary database.
5-High availability solutions Or disaster recovery Solution.
6-It is open Mount Stage.
Logical Standby:
===========
1 Logical standby database does not have to match the schema structure of the source database.
2 Logical standby database can be used concurrently for data protection, reporting, and database upgrades.
3 This Kind Of Configuration can be Opened in Read Only Mode .
4 Can have additional materialized views and indexes added for faster performance
5 Logical standby tables can be open for SQL queries (read only), and all other standby tables can be open for updates.
6 This allows users to access a logical standby database for queries and reporting purposes at any time.
No comments:
Post a Comment