Root Fan - Page 2 of 18 - Linux & Oracle DBA Blog

October 11, 2021April 9, 2022

Oracle 19c Logical Standby Configuration Step by Step

body of water under blue and white skies

To create an Oracle logical standby, you need to first have a physical data guard.

Make sure to read this post first and then come back.

A logical standby contains the same logical information as the production database, although the physical organization and structure of the data can be different.

The logical standby database is kept synchronized with the primary database through SQL Apply, which transforms the data in the redo received from the primary database into SQL statements and then executes the SQL statements on the standby database.

September 26, 2021April 12, 2022

Oracle 19c Data Guard Configuration Step by Step

If you want to setup an Oracle 19c Data Guard then you need to have 2 servers.

A physical Data Guard is the default Oracle Data Guard configuration.

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. The database schema, including indexes, are the same.

A physical standby database is kept synchronized with the primary database, through Redo Apply, which recovers the redo data received from the primary database and applies the redo to the physical standby database.