The logical standby database

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

 

 

A logical standby database can be used for other business purposes in addition to
disaster recovery requirements. This allows users to access a logical standby
database for queries and reporting purposes at any time. Also, using a logical
standby database, you can upgrade Oracle Database software and patch sets with
almost no downtime. Thus, a logical standby database can be used concurrently
for data protection, reporting, and database upgrades.