- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Difference between logical and physical standby database in the oracle
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. | Key | Logical standby database | Primary 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 |
- Related Articles
- Explain the difference between physical and logical databases
- Difference Between Logical and Physical Address in Operating System
- What is the difference between Physical Security and Logical Security in information security?
- What are the differences between Physical and Logical Topology?
- Difference between oracle golden gate and oracle active guard in the oracle
- Difference between Oracle 11g and Oracle 12c
- Difference between Oracle and SQL Server
- Difference between Chiropractor and Physical Therapist
- Difference between Hierarchical Database and Relational Database
- Oracle Database Connection in Python
- Difference between Occupational Therapy and Physical Therapy
- Difference between Schema and Database in MySQL?
- Extracting data from SAP HANA database and load to ORACLE database
- Difference between Database and a Blockchain
- Difference between a Virtual Office and Physical Office
