Show TOC

Activating or Deactivating Overwrite Mode for the Log AreaLocate this document in the navigation structure

Prerequisites

You are logged on to the database as the database system administrator or as a DBM operator with server authorization for accessing database parameters (read and write) (see Glossary, Server Permission).

Context

Specifies whether the database system can overwrite redo log entries in the log area even if they have not been backed up.

  • ON

    The database system cyclically overwrites the log area without first backing up the redo log entries.

    Caution

    Switching on the overwrite mode interrupts the backup history.

    If you have to restore the database after an error, no redo log entries are available for this period of time. This means that you will lose all data since the last data backup.

  • OFF

    The database system can only overwrite the log area after the corresponding redo log entries have been backed up. We therefore recommend that you activate the automatic log backup function or regularly carry out interactive log backups.

    If you switch off the overwrite mode, you have to carry out a complete data backup.

Procedure

  1. Select the database in the explorer tree.
  2. In the context menu of the database, choose Start of the navigation path Administration Tasks Next navigation step Change Log Settings... End of the navigation path
  3. Choose Advanced....
  4. Select Overwrite Mode for the Log Area.
  5. To apply the change, choose Start.

Next Steps

Concepts of the Database System, How Databases Log Data Changes