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”