Home | Previous Page | Next Page   Overview of the ON-Bar Backup and Restore System > ON-Bar Catalog Tables >

The bar_action Table

The bar_action table lists all backup and restore actions that are attempted against an object, except during certain types of cold restores. Use the information in this table to track backup and restore history.

Column Name Type Explanation
act_aid SERIAL Action identifier. A unique number within the table. Can be used with act_oid to join with the bar_instance table.
act_oid INTEGER Object identifier. Identifies the backup object against which a backup or restore attempt is made. Can be used with act_aid to join with bar_instance. The act_oid column of the bar_action table equals the obj_oid column of the bar_object table.
act_type SMALLINT Identifies the attempted action: 1 for backup, 2 for restore, 3 for a foreign or imported restore, 4 for a fake backup, 5 for a whole-system backup, 6 for a whole-system restore, 7 for expired or deleted objects, 8 for an external restore. Fake backups, whole-system backups, and whole-system restores are available on IDS only.
act_status INTEGER Identifies the result of the action: 0 if successful, otherwise an ON-Bar-specific error code. For more information, see ON-Bar Messages and Return Codes.
act_start DATETIME
YEAR TO
SECONDS
The date and time when the action began.
act_end DATETIME
YEAR TO
SECONDS
The date and time when the action finished.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]