A database can fail due to hardware or logical errors. To restore the database, you have to import data and log backups. 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.
Name |
Description |
Required Database Tools and Additional Software |
---|---|---|
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. |
SAP MaxDB Database Studio |
|
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. |
SAP MaxDB Database Studio |
|
Multiple duplicates of the active database are automatically updated synchronously. All databases access the same log area. When the active database fails, a standby database is automatically activated. |
|