Try OpenEdge Now
skip to main content
Database Administration
Protecting Your Data : After-imaging : AI File Management utility : Archive log file : Backup record
 
Backup record
A backup record is formatted as follows:
Record type,database,date,time,online indicator,buseq,backup-date,
      backup-time,
[incr-seq,]aiseq,backupset-name,target-count,
      backup-targets
The table below describes each field of a backup record.
Table 31. Format of a backup record in the archive log file
Field
Value
Current field position
Prior field position1
Record type
Backup indicator record values are:
*0032 — Full backup
*0033 — Incremental backup
1
1
database
Name of the database
2
2
date
Date the backup record was written to the archive log file in YYYYMMDD format
3
3
time
Time the backup record was written to the archive log file in HHMMSS format
4
4
online indicator
Online indicator; possible values are:
*0 — offline
*1 — online
5
5
buseq
Backup sequence number of the backup
6
6
backup-date
Date that the backup was started for the database in YYYYMMDD format
7
7
backup-time
Date that the backup was started for the database in HHMMSS format
8
8
incr-seq
For incremental backups only, the incremental backup sequence number; if a full backup, this field is omitted
9 (for 0033)
9 (for 0033)
aiseq
AI extent sequence number, with leading zeros (number of AI extents since last AIMAGE BEGIN)
9 (for 0032)
10 (for 0033)
9 (for 0032)
10 (for 0033)
backupset-name
The backup set name—the format is BACKUP_SET_YYYYMMDD_HHMMSS where the date and time components reflect the backup-date and backup-time values
10 (for 0032)
11 (for 0033)
12 (for 0032)
13 (for 0033)
target-count
Number of backup target files
11 (for 0032)
12 (for 0033)
10 (for 0032)
11 (for 0033)
backup-targets
Comma separated list of backup target names
12 (for 0032)
13 (for 0033)
11 (for 0032)
12 (for 0033)

1 Field record position for a backup record prior to OpenEdge Release 10.1C02.