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 ]

The following table describes the SHOW-BACKUPS options:

Options Description
-s 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.
-i 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 code sample 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 code sample 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 code sample 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 code sample 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