|
What is a standby database? Difference between Physical and logical standby databases. A standby database is a backup database that can be promoted should the primary fail.
A physical standby database is created from an existing other database. This other database will then be the primary database.
Logical Standby database makes the dml statements using archivelogs generated and applies to the secondary database. Logical standby database permits you to add additional objects like tables, indexes, etc to the database.What are standby databases? Difference between Physical and logical standby databases.A standby database is a replica of the original database. In order to keep both the database synchronized, archived redo logs can be used. It is mainly used in disaster protection. It can also be opened in read only mode which allows it to be used independently for reporting.
A logical standby database allows new database objects like tables, indexes to be added to the database. On the other hand, the physical standby database is a physical or structural copy of primary database. They can be opened in read only for disaster recovery.
|
