Background documentationautolog_on Locate this document in the navigation structure

 

You activate the function for automatic backup of the log area.

According to the default value, the system saves the log area as soon as a log segment is full. You can use an option to specify the interval at which the system saves the log area. The log area is saved as soon as a log segment is full, regardless of the specified interval.

The first time you activate automatic log backup, 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 that was created for the LOG backup type, the system changes this property to AUTO.

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

Recommendation Recommendation

For security reasons, copy the backup files that the automatic log backup creates to another data carrier external to the database computer.

End of the recommendation.

Prerequisites

  • You have the server authorization Backup.

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

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

  • Automatic log backup 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 automatic log backup of the database instance

INTERVAL <value>

Time interval in seconds between an entry in the log area and the entry being saved by the automatic log backup

The system triggers the respective 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 do not specify this option at all, the log area is saved as soon as a log segment is full (default value).

Result

OK

In the event of errors, see Reply Format.

Example

Call the Database Manager CLI and log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, activate 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 Manager CLI Tutorial, Activating Automatic Log Backup

Database Administration, Backing Up Log Entries, Archiving Backup Files