SHOW-BACKUPS v2.6
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 { <server_name> | all }--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 { <backup_id> | <backup_name> | all } --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 --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