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 |
|
Device Type |
Data carrier type
|
Backup Tool |
Only if you are using a third-party backup tool Specify the backup tool:
More information: Database Administration, Using Third-Party Backup Tools |
Device/File |
Depending on the backup type enter the required information:
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:
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 |
Database Administration, Backup Templates and Data Carriers
Database Studio,
Database Manager CLI, backup_template_create
Database Administration in CCMS, Backup Templates