Show TOC

Scheduling an Interactive Log BackupLocate this document in the navigation structure

Use

Schedule regular log backups by activating automatic log backups.

If you do not activate automatic log backups, check that there is enough memory in the log area ( Monitoring the Log Area) at regular intervals, and backup the log entries immediately, if necessary. You can schedule and execute an interactive log backup in the DBA Planning Calendar.

Prerequisites

DBA Planning Calendar

Setting Up and Using the DBA Planning Calendar

Define appropriate backup templates. Specify a file as the data carrier.

Procedure
  1. Follow the scheduling concept.

  2. Open the DBA Planning Calendar.

  3. To schedule interactive log backups, proceed as described in Scheduling an Action. Use the following action: Log Backup

Note

Before a scheduled backup action is due to start, make sure that the data-carriers have been inserted and are ready to run.

When you make a log backup, you copy the contents of the log area (log entries) into backup files or back them up at the desired time using a backup tool from another provider. If you need to back up the log area immediately, proceed as described in Starting an Action Immediately.

Result

The required backup is scheduled. Check the schedules of the interactive log backups. The interactive log backup is started at the specified time, and the log segments are copied to the backup files.

Archive older backup files regularly to another data carrier. If you are using a backup tool from another provider, you can automate this procedure. Follow the procedure described in Archiving Backup Files.

Check the results of the log backups in the DBA Planning Calendar, as described in Displaying Actions. Use the information displayed in the DBA History. Also use the Log Area display in the Database Alert Monitor or liveCache Alert Monitor.

More Information