You display the content of the backup history. You can specify options to restrict or extend the information displayed.
To save time, we recommend that you execute the DBM command for retrieving the backup history first. If you do not execute this command first, it is executed implicitly with the DBM command for displaying the backup history.
You have the server authorization Backup or DBInfoRead.
backup_history_list [-c <columns>] [-k <key>] [-l <label>] [-a <action>] [-r <restore_flag>] –u <yyyymmddHHMMSS>] –m] [-e] [-Inverted]
-c <columns> |
You specify
which columns are to be displayed. If you enter several columns, separate them
with commas. The keywords for the individual columns are: 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 medium used PAGES Size of the backup in pages VOLUMES Number of parts contained in the backup RC Return value from database instance 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 that contain the specified backup ID are displayed. This option must not be used with the -r option. |
-a <action> |
Only the lines of the backup history that match the specified backup type are displayed. This option must not be used with the -r option. |
-r <restore_flag> |
Only backups that were required to restore the database instance are displayed. The following values are possible for <restore_flag>: * | LAST | <key> If you specify *, all data backups required to restore the database instance are displayed. If the log volume is intact, only the data backups that match the available log are displayed. If you enter LAST, all the backups – beginning with the last complete data backup – are displayed that are required to recover the database instance. If you specify <key> for the complete data backup, all backups that are required to restore the database instance 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 those lines in the backup history that contain data that was saved in the database instance before the specified time are displayed. This option cannot be used with the -r option. |
-m |
For each line that relates to a backup, information is displayed on the backup medium used. |
-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 (the most recent backup first). |
OK<NL>
(END|CONTINUE)<NL>
<history_line><NL>
[<media_line><NL>]
[<external_backup_id-line><NL>]
<history_line><NL>
[<media_line><NL>]
[<external_backup_id-line><NL>]
....
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 storage available for replies. You can display this data by entering the above command or close the backup history. |
<history_line> |
Information on the completed backups. The individual columns are separated by |. A separate line is displayed for each backup. |
<media_line> |
Information on the medium used for the backup |
<external_backup_id_line> |
If the
backup was created using an external backup tool, information about the
external backup ID is shown here. You have to specify this information
when restoring
a database instance from an external backup tool. |
In the event of errors, see Reply Format.