Types Of Standby Database

Oracle Standby Database Types

Description : 
       In this blog, we are going to different types of standby databases with clear definitions.

Types of Standby Database:

Physical Standby
Logical Standby
Snapshot Standby

Physical Standby:

  • Physical Standby is the exact block-for-block copy of the primary database.
  • Physical standby database synchronized with the primary database through the application of redo data received from the primary database.
  • It can be used concurrently for data protection and reporting.     
  • Physical standby database will be mounted stage while recovery is processed.
  • It can be opened as read-only mode
  • Active standby database is available for reading mode, enabling recovery at the backend.  

Physical standby database benefits:

  • An identical physical copy of the primary database.
  • Disaster recovery and high availability.
  • High Data protection.
  • Reduction in primary database workload.
  • Performance can be Faster.

Logical Standby Database:

  • A logical standby database does not have to match the schema structure of the source database.
  • Logical standby tables can be open for SQL queries (read-only), and all other standby tables can be open for updates.
  • The primary database logs can be converted as SQL then the SQL statements can be applied into the logical standby database.
  • The logical standby database can have different unique Database IDs.
  • A logical standby database can have additional materialized views and indexes added for faster performance.

Logical Standby Database Benefits:

  • Simultaneous use for reporting, summations, and queries.
  • Efficient use of standby hardware resources.
  • Reduction in primary database workload.
  • Some limitations on the use of certain data types.

Snapshot Standby Database:

  • The snapshot standby database is and fully update standby database.
  • A snapshot standby database receives and archives redo data from a primary database but are not applied.
  • Redo data received from the primary database is applied when a snapshot standby database is converted back into a physical standby database,
  • This database can be used for updates but these updates are discarded before the snapshot database is converted back into a physical standby database.

Snapshot Standby Database benefits:

  • Temporary snapshot of the primary database.
  • fully updatable stand-alone database.
  • As this is in READ and WRITE mode, any kind of testing or changes can be done,

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8