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.
Continue reading “Oracle 19c Logical Standby 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.
Continue reading “Oracle 19c Data Guard Configuration Step by Step”