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
For security reasons, copy the backup files that the automatic log backup creates to another data carrier external to the database computer.
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.
autolog_on [<medium_name>] [INTERVAL <value>]
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). |
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
Database Manager CLI Tutorial, Activating Automatic Log Backup
Database Administration, Backing Up Log Entries, Archiving Backup Files