Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Archive log file

> The AI File Management Utility creates a log of the extents it archives. The log file is written to the same directory as your database `.db` file, and is named, `database-name``.archival.log`. The log file is created the first time an extent is archived. The information stored in the archive log file provides details of when the AI file management utility was started, and extent archiving activity that you can use to develop either an automated or manual recovery a database.

> Each time the AI File Management daemon is started, two lines are written to the archive to record the data and time. It is formatted as follows:

>     # After-image Extent Manager started on : Tuesday October 11, 2005 at 10:02:25
>     # 0255,20051011,100225,100100

> In the second line of the example above provides version and startup information and is formatted as follows:

>     # 0255, date, time, release

> Table 7–2: Format of an archival log startup line
> Field | Value
> --- | ---
> `Version indicator (0255)` | Version line indicator.
> `date` | Date the Extent Manager started in YYYYMMDD format.
> `time` | Time the Extent Manager started in HHMMSS format.

> After the header lines, each line of the file describes an archive event with a comma separated list of details. An archive line is formatted as follows:

>     0001,database,date,time,buseq,aibegin-date,aibegin-time,aiseq,extent-name,
>           target-directory,target-extent-name

> Table 7–3 describes each element of an AI extent archive line.

> Table 7–3: Format of an archive log file AI extent archive line
> Field | Value
> --- | ---
> Extent Archive indicator (0001) | AI extent archive indicator.
> `database` | Name of the database.
> `date` | Date of the backup in YYYYMMDD format.
> `time` | Time of the backup in HHMMSSUUU format.
> `buseq` | Backup sequence number of the backup.
> `aibegin-date` | Date that after imaging was started for the database in YYYYMMDD format.
> `aibegin-time` | Date that after imaging was started for the database in HHMMSSUUU format.
> `aiseq` | AI extent sequence number, with leading zeros
> `extent-name` | Source name of the archived extent.
> `target-directory` | The directory where the extent is archived.
> `target-extent-name` | The file name of archived extent.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095