Show TOC

Procedure documentationActivating or Deactivating Overwrite Mode for the Log Area Locate this document in the navigation structure

 

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 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.

    End of the caution.

  • 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.

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).

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose   Administration Tasks   Change Log Settings...  

  3. Choose Advanced... .

  4. Select Overwrite Mode for the Log Area.

  5. To apply the change, choose Start.

More Information

Concepts of the Database System, How Databases Log Data Changes