Show TOC

Backup TemplateLocate this document in the navigation structure

Use

Before you can back up data and redo log entries to a data carrier, you must create a backup template.

Property

Description

Name

The name of the backup template has no influence on the name of the backup created later using this backup template.

Backup Type

  • COMPLETE DATA: Complete data backup

  • INCREMENTAL DATA: Incremental data backup

  • LOG: Log backup

Device Type

Data carrier type

  • FILE: file

  • TAPE: tape

  • PIPE: pipe (cannot be used for automatic log backups)

  • EXTERNAL: database snapshot (used for external file system backup)

Backup Tool

Only if you are using a third-party backup tool

Specify the backup tool:

  • BACKINT: Backint for Oracle or Backint for MaxDB

  • NETWORKER: Networker

  • TSM: TSM

More information: Database Administration, Using Third-Party Backup Tools

Device/File

Depending on the backup type enter the required information:

  • Name of the tape device in the operating system

  • Path and file name of the file in the file system

    Caution

    If you do not enter a full path here, the system stores your backup in the run directory of the database.

    More information: Glossary, Run Directory

  • Path and name of the pipe

We recommend that you do not use the same data carrier for several databases.

For log backups to files, the system adds a sequence number to the name of each new backup file. It assigns the numbers sequentially as long as the history of the log backups is not interrupted. If the log backup history is interrupted (for example after the database was initialized), the system starts numbering at 001 again.

It also uses sequential numbers if you carry out multiple log backups for one database onto different data carriers, and thus to files with different file names.

Example

LogUri.001

LogKai.002

LogOleg.003

LogUri.004

LogAlexander.005

If automatic log backup is switched on, the system stores all backup files under the same file name using a sequence number.

Example

DEMODB_MYLOG.001

DEMODB_MYLOG.002

DEMODB_MYLOG.003

DEMODB_MYLOG.004

DEMODB_MYLOG.005

You can use the following placeholders:

  • #YYYY: year

  • #MM: month

  • #DD: day

  • #hh: hour

  • #mm: minute

  • #ss: second

Example

DEMODB_DATA_#YYYY-#MM-#DD

You can also back up to data carriers on remote computers. More information: Database Administration, Backing Up and Restoring Data with Remote Computers

Size

There is no size restriction in default mode.

The size of log backups to files is calculated as the size of a log segment (general database parameter AutoLogBackupSize) plus the space required by system information.

More information: Database Administration, General Database Parameters

Compressed

For backup templates of the FILE and PIPE types only

Specifies whether the backup is compressed

Overwrite

For backup templates of the FILE type only

Specifies whether the backup file can be overwritten

We recommend that you do not overwrite a backup with the backup that immediately follows it. Always keep an older version of the backup.

Block Size

Block size that the system uses to write backups to the data carrier.

Autoloader

Select this option if you want to use a tape device with an automatic tape loader.

OS Command

For backup templates for the TAPE type only

Operating system command for backing up to tape devices

More Information