Procedure documentationArchiving Backup Files Locate this document in the navigation structure

 

If automatic log backup is switched on, the database system continuously writes redo log entries to backup files (in chronological order). Thus the number of backup files on the hard disk keeps growing until there is no more storage space available.

If no more storage space for log backups is available on the hard disk, then after some time, no more storage space for redo log entries is available in the log area of the database either. This is because old redo log entries can only be overwritten by the system with new entries after they have been backed up. Exception: Overwrite mode for the log area is activated; but this is not recommended for production systems. If the database system cannot write any further redo log entries to the log area, it stops all running transactions. This means that the database is unavailable for users.

Therefore you need to ensure that there is always enough space available for log backups by moving your backup files to other data carriers (archiving).

Procedure

Archiving Backup Files Manually

  1. Locate the backup files.

    More information: Backup Templates and Data Carriers

    Example Example

    You have defined the following backup template and activated automatic log backup:

    Example of a Backup Template for a Log Backup

    Property

    Value

    Name of the backup template

    DEMODB_LOG

    Backup type

    LOG

    Data carrier type

    FILE

    Data carrier (Device/File)

    DEMODB_MYLOG

    Note that i you do not enter an absolute path, then the database system uses the run directory of the database, see Run directory.

    Example: C:\ProgramData\sdb\globaldata\wrk\DEMODB\DEMODB_LOG

    Size of data carrier

    No restriction (blank or 0)

    Block size

    8 pages

    Overwritable

    No

    Your backup files are located in the run directory of the database:

    DEMODB_MYLOG.001

    DEMODB_MYLOG.002

    DEMODB_MYLOG.003

    DEMODB_MYLOG.004

    DEMODB_MYLOG.005

    End of the example.

  2. Caution Caution

    If automatic log backup is activated, the system backs up new log entries to the newest backup file even during archiving. To ensure that you only archive complete backup files, exclude the newest backup file from archiving.

    End of the caution.

    To archive the backup files, use operating system commands to move the oldest backup files to another data carrier.

Archiving Backup Files Automatically

If you use third-party backup tools, you can automate the archiving of backup files using Database Manager CLI or CCMS (only in SAP systems).

More information: