Difference between logical and physical standby database in the oracle

OracleDatabaseMS SQL Server

Logical standby and physical standby database in two different types of standby database. In case of any failure of primary database Oracle transfer data from primary database to the standby database. This approach helps us to recover data from standby database in case of any failure.

Logical standby database is not the exact copy of the primary database. Logical standby uses LogMiner techniques to transform the archived redo logs into native DML statements (insert, update, delete).  This DML is transported and applied to the standby database.

Primary standby database is the exact copy of primary database so it helps to minimize the workload of the primary database and it also provide higher data protection  because any point of time we can recover data from the standby database.

Sr. No.KeyLogical standby databasePrimary standby database

1

Basic 

Logical standby database is not the exact copy of the primary database

Primary standby database is the exact copy of primary database 

2

Data protection 

Less data protection in comparison of primary standby database 

Higher data protection 

3

Additional materialized view

It can have additional materialized views and indexes 

Not required 


raja
Published on 21-Jan-2020 14:19:10
Advertisements