Show TOC

Replication and High AvailabilityLocate this document in the navigation structure

Use

A database can fail due to hardware or logical errors. To restore the database, data and log backups must be imported. If you need to import a lot of data, restoring can take quite a long time. During this time, the database is not available for users.

To make the database available for users more quickly (high availability), you can choose between several replication methods.

Procedure

Name

Description

Snapshot of the Data Area

A snapshot stores the state of the data area at the time of the snapshot. A snapshot is not a replication mechanism and not a data backup, but you can return to the state of the data area at the time of the snapshot.

Database Copy

You copy the active database.

A database copy is not a replication mechanism, but is required for setting up other replication mechanisms, such as standby databases.

Standby Database

You update a duplicate of the active database asynchronously.

You copy the log backups of the original database to the standby database computer and import them into the standby database.

When the original database fails, you can quickly resume operations with the standby database after importing the most recent redo log entries.

Hot Standby System

Depending on the chosen solution, one or multiple duplicates (standby databases) of the active database (master database) ensure that the downtime after a system failure is reduced to a minimum. As soon as the master database fails, a standby database can take over operation.

More Information