Background documentationbackup_history_list Locate this document in the navigation structure

 

With this command you can display the content of the backup history. You can restrict or extend the display by specifying options.

To save time, we recommend that you execute the DBM command for getting the backup history (see: backup_history_open). If you do not execute this command first, it is executed implicitly with the DBM command for displaying the backup history described here.

Prerequisites

You have the server permission Backup or DBInfoRead.

Structure

backup_history_list [<option_list>]

<option_list> :: = <option> | <option>,<option>, ...

<option> :: = -c <columns> | -k <key> | -l <label> | -a <action> | -r <restore_flag> | -u <yyyymmddHHMMSS> | -m | -e | -Inverted

Options

Option

Description

-c <columns>

Specify which columns are to be displayed. If you specify multiple columns, separate them using commas. The keywords for the individual columns are:

KEY: key value for the backup

LABEL: label for the backup

ACTION: backup action

STAMP1: first time stamp for the backup

STAMP2: second time stamp for the backup

START: start of backup

STOP: end of backup

FIRSTLOG: first log IO sequence number for the backup

LASTLOG: last log IO sequence number for the backup

LOG: states whether log backups have to be imported after data backup has been imported

MEDIA: name of the backup template used

PAGES: size of the backup in pages

VOLUMES: number of parts that comprise the backup

RC: return value from database for the backup

ERROR: backup error message

-k <key>

Only the line of the backup history that contains the key value specified under <key> is displayed.

This option must not be used with the -r option.

-l <label>

Only the lines of the backup history containing the backup label specified are displayed.

This option must not be used with the -r option.

-a <action>

Only the lines of the backup history that match the backup type specified are displayed.

This option must not be used with the -r option.

-r <restore_flag>

Only backups required to restore the database are displayed. Possible values for <restore_flag>:

* | LAST | <key>

*: All data backups required to restore the database are displayed. If the log volume is still intact, then only the data backups that match the existing log entries in the log volume are displayed.

LAST: All backups that are required to recover the database are displayed including the last complete database backup.

<key>: Key value of the complete data backup

All the backups required to restore the database are displayed. The key value of the complete data backup is stored in the backup history in the first column of the entry for this backup.

-u <yyyymmddHHMMSS>

Only the lines in the backup history containing data saved in the database before the specified time are displayed.

Time format: Year Month Day Hours Minutes Seconds

-m

For each line that relates to a backup, information on the backup template used is output.

-e

For each line that relates to a backup, information is displayed about the associated external backup ID.

-Inverted

The backup history is displayed in reverse order; that is, starting with the most recent backup.

Result

OK

END | CONTINUE

<history_line>

[<media_line>

[<external_backup_id-line>]

<history_line>

[<media_line>]

[<external_backup_id-line>]

....

Values for the Reply Fields

Value

Description

END

The contents of the backup history have been transferred in full. The file is closed automatically.

CONTINUE

The backup history contains further entries that were not transferred due to the limited size of the reply package. You can display this data by entering the DBM command again, or close the backup history (see: backup_history_close).

<history_line>

Information about the last backups

The columns are separated by a vertical slash (|). A separate line is displayed for each backup.

<media_line>

Information about the backup template used for the backup

The line has an M: prefix and is followed by the columns, each separated by a vertical slash (|).

<external_backup_id_line>

If the backup was created using a backup tool, information about the external backup ID is shown here.

The line has an E: prefix and is followed by the columns, each separated by a vertical slash (|).

In the event of errors, see Reply Format.

More Information

Database Administration, Log Files