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 column 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. |
| 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. |