Background documentationautolog_on Locate this document in the navigation structure

 

Use this command to switch on the automatic backup function for the log area.

You can use an option to specify the interval at which the system backs up the log area.

According to the default value, the system backs up the log area as soon as a log segment is full, regardless of the specified interval.

When you switch on the automatic log backup function for the first time, you need to specify the name of a backup template which will be used to automatically back up the log area.

The backup template can have been specified for the LOG or AUTO backup types. If you specify a backup template, which was created for the LOG backup type, the system changes this property to AUTO.

If the automatic log backup function has been activated before and you do not specify a backup template, the system takes the last backup template used for the automatic log backup.

Recommendation Recommendation

For security reasons, copy the backup files created by the automatic log backup function to another data carrier external to the database computer.

End of the recommendation.

Prerequisites

  • You have the server permission Backup.

  • You have performed at least one complete data backup of the database (see: backup_start).

  • You have specified a backup template for the log backup (see: medium_put).

  • The automatic log backup function is off.

Structure

autolog_on [<medium_name>] [INTERVAL <value>]

Options

Option

Description

<medium_name>

Name of the backup template

The default backup template is the last one used for the automatic log backup of the database

INTERVAL <value>

Time interval in seconds between an entry in the log area and the entry being backed up by the automatic log backup function

The system triggers the next automatic log backup after the specified time period, unless the log segment is filled beforehand and the next automatic log backup is triggered for this reason.

If you specify the value 0 for this option, or if do not specify this option at all, the log area is backed up as soon as a log segment is full (system default).

Result

OK

In the event of errors, see Reply Format.

Example

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, and switch on the automatic log backup function using the backup template DemoAutoLog for automatically backing up every 300 s:

>dbmcli -u OLEG,MONDAY -d DEMODB autolog_on DemoAutoLog INTERVAL 300

OK

More Information

Database Administration, Backing Up Log Entries, Archiving Backup Files