Oracle Active Data Guard Overview & Architecture

We have seen 3 types of Standby Databases Physical Standby Database Logical Standby Database Snapshot Standby Database To know more about it Oracle Dataguard Oracle 11g comes with a new option : Oracle Active Data Guard. Oracle Active Data Guard is an optional license for Oracle Database Enterprise Edition. Active Data Guard enables advanced capabilities that that […]

Read More

Snapshot Standby Databases: Overview & Architecture

Snapshot Standby Database : We have already seen types of standby database in Data Guard. Oracle Dataguard In this article we are going to see Snapshot Standby Database in deep. In snapshot standby type database stays in a read,write mode that is fully update-able database. Snapshot standby database is created by converting physical standby database […]

Read More

Logical Standby Database : SQL Apply Architecture

Oracle DataGuard supports logical and physical standby databases. Logical Standby: When primary database generates any redo entries it is transferred to standby database and then redo data are converted into SQL statements and then those SQL statements are applied to standby database. To read more about Physical Standby Database Physical Standby Database: Redo Apply Architecture […]

Read More

Oracle Database 18c Technical Architecture

This interactive diagram shows the Oracle Database 18c technical architecture. An Oracle Database consists of at least one database instance and one database. The database instance handles memory and processes. The database consists of physical files called data files, and can be a non-container database or a multitenant container database. An Oracle Database also uses […]

Read More