Show TOC

Hot Standby SystemLocate this document in the navigation structure

Use

A hot standby system consists of a master database and one or more standby databases that are updated at regular intervals. Master and standby databases together form a cluster that, outwardly, behaves like a single database. If the master database fails, one of the standby databases automatically becomes the new master database.

The main advantage of a hot standby system is the short downtime when errors occur (much shorter than the time it would take to restart the master database, for example).

Caution

A hot standby system does not protect you against database errors and inconsistencies caused by users or applications. To prevent these types of errors, you have to perform regular data and log backups (see Backing Up Databases).

Procedure

Hot Standby Solution

Description

Advantages

Disadvantages

Hot Standby System (With Shared Log Area)

Master database and standby databases share a single log area.

  • You can set up several standby databases.

  • This solution is suitable for large databases with lots of data changes.

You need a storage system.
More Information