Entering content frame

Background documentation Changing Log Settings (Configuration Wizard) Locate the document in its SAP Library structure

You can use the Database Manager GUI to change log settings. To do this, use the Configuration Wizard, which guides you through the entire process.

Prerequisites

Check the log area and log writer information in the Database Manager GUI.

Procedure

Start the Configuration Wizard. To do this, choose Start ® Programs ® MySQL MaxDB ® Database Manager Wizards ® Configuration Wizard, or, in the Database Manager GUI, choose Instance ® Configuration ® Configuration Wizard.

Choose Next to start each of the required steps.

Decide which log settings you want to change. You can change multiple log settings, one after the other. To do this, choose Back each time you complete your changes.

·        Log Mode: Log Mode
The database instance can be in any operational state. You should ensure, however, that you transfer the database instance into the operational state OFFLINE after setting the log mode, and then into the operational state ONLINE. If you want to mirror the log area by setting the log mode, then you must use the Configuration Wizard to create only the required mirrors of the log volumes.
- Choose Properties.
-
Specify the location of the mirror under Location.
- Start the process.
After this operation has been completed, the database instance is transferred to the operational state OFFLINE and then to ONLINE.

·        Overwrite mode for the log area
After a standard installation, normal log backup operations are activated, which means that the overwrite mode is deactivated. The database instance must be in the operational state ADMIN or ONLINE before you can change the overwrite mode.
You can use the Configuration Wizard to activate the overwrite mode. This setting remains active even after you restart the database instance.
You must activate normal log backup operations (and deactivate the overwrite mode) explicitly with the Configuration Wizard. Afterwards, you are prompted to make a complete data backup to guarantee the integrity of your data.

·        Activating or deactivating redo log management
Redo log management is activated after a standard installation. The database instance must be in the operational state ADMIN before you can change this setting.
You can use the Configuration Wizard to deactivate redo log management. This setting remains active even after you restart the database instance.
You must activate redo log management explicitly with the Configuration Wizard. Afterwards, you are prompted to make a complete data backup to guarantee the integrity of your data.

 

Leaving content frame