SHOW-BACKUPS

The SHOW-BACKUPS subcommand displays the backup information for the managed database servers.

Syntax:

bart SHOW-BACKUPS [ –s { <server_name> | all } ]
[ -i { <backup_id> | <backup_name> | all } ]
[ -t ]

Options

  • -s { <server_name> | all } or --server { <server_name> | all }

    • <server_name> is the name of the database server whose backup information is to be displayed.
    • If all is specified or if the option is omitted, the backup information for all database servers is displayed with the exception as described by the following note:

    If you invoke the SHOW-BACKUPS subcommand while the BART BACKUP subcommand is in progress, backups affected by the backup process are shown in progress status in the displayed backup information.

  • -i { <backup_id> | <backup_name> | all } or --backupid { <backup_id> | <backup_name> | all }

    • <backup_id> is a backup identifier and <backup_name> is the user-defined alphanumeric name for the backup.
    • If all is specified or if the option is omitted, all backup information for the relevant database server is displayed.
  • -t or --toggle

Displays detailed backup information in list format. If the option is omitted, the default is a tabular format.

Example

The following example shows the backup from database server dev:

-bash-4.2$ bart SHOW-BACKUPS -s dev
SERVER NAME              BACKUP ID       BACKUP NAME               BACKUP PARENT
BACKUP TIME              BACKUP SIZE     WAL(s) SIZE               WAL FILES STATUS
dev                      1477579596637   dev_2016-10-27T10:46:36   none
2016-10-27 10:46:37 EDT  54.50 MB        96.00 MB                  6         active

The following example shows detailed information using the -t option.

-bash-4.2$ bart SHOW-BACKUPS -s dev -i 1477579596637 -t
SERVER NAME : dev
BACKUP ID : 1477579596637
BACKUP NAME : dev_2016-10-27T10:46:36
BACKUP PARENT : none
BACKUP STATUS : active
BACKUP TIME : 2016-10-27 10:46:37 EDT
BACKUP SIZE : 54.50 MB
WAL(S) SIZE : 80.00 MB
NO. OF WALS : 5
FIRST WAL FILE : 0000000100000001000000EC
CREATION TIME : 2016-10-27 10:46:37 EDT
LAST WAL FILE : 0000000100000001000000F0
CREATION TIME : 2016-10-27 11:22:01 EDT

The following example shows a listing of an incremental backup along with its parent backup.

-bash-4.2$ bart SHOW-BACKUPS
SERVER NAME              BACKUP ID         BACKUP NAME       BACKUP PARENT
BACKUP TIME              BACKUP SIZE       WAL(s) SIZE       WAL FILES       STATUS
acctg                    1477580293193     acctg_2016-10-27  none
2016-10-27 10:58:13 EDT  16.45 MB          16.00 MB          1               active
acctg 1477580111358 acctg_2016-10-27 none 2016-10-27 10:55:11 EDT 59.71
MB 16.00 MB 1 active

The following example shows the complete, detailed information of the incremental backup and the parent backup.

-bash-4.2$ bart SHOW-BACKUPS -t
SERVER NAME : acctg
BACKUP ID : 1477580293193
BACKUP NAME : none
BACKUP PARENT : acctg_2016-10-27
BACKUP STATUS : active
BACKUP TIME : 2016-10-27 10:58:13 EDT
BACKUP SIZE : 16.45 MB
WAL(S) SIZE : 16.00 MB
NO. OF WALS : 1
FIRST WAL FILE : 0000000100000002000000D9
CREATION TIME : 2016-10-27 10:58:13 EDT
LAST WAL FILE : 0000000100000002000000D9
CREATION TIME : 2016-10-27 10:58:13 EDT
SERVER NAME : acctg
BACKUP ID : 1477580111358
BACKUP NAME : acctg_2016-10-27
BACKUP PARENT : none
BACKUP STATUS : active
BACKUP TIME : 2016-10-27 10:55:11 EDT
BACKUP SIZE : 59.71 MB
WAL(S) SIZE : 16.00 MB
NO. OF WALS : 1
FIRST WAL FILE : 0000000100000002000000D8
CREATION TIME : 2016-10-27 10:55:12 EDT
LAST WAL FILE : 0000000100000002000000D8
CREATION TIME : 2016-10-27 10:55:12 EDT