Show TOC

Procedure documentationActivating or Deactivating Redo Log Management Locate this document in the navigation structure

 

Specifies whether the database system writes redo log entries.

Caution Caution

Do not switch redo log management off in normal database operation.

When redo management is switched off, the system does not write regular savepoints. This means that if you restart your database after a database crash, you lose all data since the last savepoint. If you have to restore your database, you can only restore it to the state of the last data backup.

Only consider switching redo log management off in special situations, for example in a test system or during a large load job.

End of the caution.

If redo log management was off and you switch it back on, you then must 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).

  • The database is in operational state ADMIN.

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. Choose Activate or Deactivate Redo Log Management.

  5. Choose Start.

More Information

Concepts of the Database System, How Databases Log Data Changes