DATABASE_BACKUPS

Lists historical information for each backup that successfully completed after running the vbr utility.

Lists historical information for each backup that successfully completed after running the vbr utility. This information is useful for determining whether to create a new backup before you advance the AHM. Because this system table displays historical information, its contents do not always reflect the current state of a backup repository. For example, if you delete a backup from a repository, the DATABASE_BACKUPS system table continues to display information about it.

To list existing backups, run vbr as described in Viewing backups.

Column Name Data Type Description
BACKUP_TIMESTAMP TIMESTAMP The timestamp of the backup.
NODE_NAME VARCHAR The name of the initiator node that performed the backup.
SNAPSHOT_NAME VARCHAR The name of the backup, as specified in the snapshotName parameter of the vbr configuration file.
BACKUP_EPOCH INTEGER The database epoch at which the backup was saved.
NODE_COUNT INTEGER The number of nodes backed up in the completed backup, and as listed in the [Mappingn] sections of the configuration file.
OBJECTS VARCHAR The name of the object(s) contained in an object-level backup. This column is empty if the record is for a full cluster backup.
FILE_SYSTEM_TYPE VARCHAR The type of file system, such as Linux.

Privileges

Superuser