The database system stores information about data changes in redo log entries in the log area. Regularly back up your redo log entries from the log area to data carriers, because if the log area was damaged during a system failure, you need redo log entries from log backups to restore the database to the desired state.
If due to a system failure the database system could not write the latest data changes to the data area, but the log area was not damaged, you do not need backed-up redo log entries to restore the database to the state before the system failure. When you restart your database, the database systems uses redo log entries from the log area to repeat those data changes. More information: Example: Restart
Caution
If the log area is full and the database system cannot write redo log entries to it any longer, the database comes to a stand-still. You can only continue working after you have backed up redo log entries from the log area to data carriers.
Exception: You have switched on the overwrite mode for the log area. This is not recommended in production systems though. More information: Glossary, Overwrite Mode for the Log Area
Note that you cannot start any other backup while a log backup is running. Exception: When automatic log backup is active, you can perform data backups.
You can only back up redo log entries after you have created at least one complete data backup of the database.
More information: Backing Up Data
You have defined a backup template.
More information: Backup Templates and Data Carriers
If you plan to back up to a data carrier on a remote computer (not the database computer), then additional preparations may be necessary.
More information: Backing Up and Restoring Data with Remote Computers
The database is in the ONLINE or ADMIN operational state.
For log backups, use Database Studio, Database Manager CLI, or CCMS (in SAP systems only).
During a manual log backup, you back up all redo log entries that the system has written since the last log backup.
You can back up log entries to files or to pipes. When backing up to files, the system creates the necessary files one after the other. Each file has the size of a log segment. Note that restrictions apply for backing up to pipes, see Backup Templates and Data Carriers.
More information:
Database Studio, Backing up Log Entries
Database Manager CLI Tutorial,
Database Administration in CCMS, Scheduling Interactive Log Backups
If automatic log backup is on, the database system automatically backs up redo log entries to backup files.
The system starts a log backup at the following times:
When a log segment is full
You configure the size of the log segments with the general database parameter AutoLogBackupSize.
More information: General Database Parameters
When the configured time interval has elapsed
You can specify the time interval when switching automatic log backup on.
Recommendation
We recommend automatic log backup in particular for databases in which large amounts of data are changed and therefore a great number of redo log entries are written.
Caution
For automatic log backup, you cannot use pipes.
More information: SAP Note 869267
More information:
Database Studio, Activating or Deactivating Automatic Log Backup
Database Manager CLI Tutorial, Activating Automatic Log Backup
Database Administration in CCMS, Activating Automatic Log Backup
For log backups to files, you have to archive the backup files regularly.
More information: Archiving Backup Files