VERIFY-CHKSUM v2.6

The VERIFY-CHKSUM subcommand verifies the MD5 checksums of the full backups and any user-defined tablespaces for the specified database server or for all database servers. The checksum is verified by comparing the current checksum of the backup against the checksum when the backup was taken.

Note

The VERIFY-CHKSUM subcommand is only used for tar format backups.

Syntax:

bart VERIFY-CHKSUM
[ –s { <server_name> | all } ]
[ -i { <backup_id> | <backup_name> | all } ]

The following table describes the VERIFY-CHKSUM options:

OptionsDescription
-s { <server_name> | all }
--server { <server_name> | all }
<server_name> is the name of the database server whose tar backup checksums are to be verified.
If all is specified or if the -s option is omitted, the checksums of all tar backups are verified for all database servers.
-i {<backup_id> | <backup_name> | all }

--backupid {<backup_id> | <backup_name> | all }
<backup_id> is the backup identifier of a tar format full backup whose checksum is to be verified along with any user-defined tablespaces. <backup_name> is the user-defined alphanumeric name for the full backup.
If all is specified or if the -i option is omitted, the checksums of all tar backups for the relevant database server are verified.

Example

The following code sample verifies the checksum of all tar format backups of the specified database server:

-bash-4.1$ bart VERIFY-CHKSUM -s acctg -i all
SERVER NAME    BACKUP ID     VERIFY
acctg          1430239348243 OK
acctg          1430232284202 OK
acctg          1430232016284 OK
acctg          1430231949065 OK
acctg          1429821844271 OK