Verify backup data in a specified path across clusters

You can verify backup data or secondary backup data in a specified path across clusters.

Considerations

Before you validate the backup data, make sure that the data to be verified meets the following requirements:

• All backup data is generated upon a successful backup.

• The backup data is not cleared.

Verify all backup data or secondary backup data

1. Log on to the sys tenant of a cluster other than the one with the backup data with the root account.

2. Execute the following statement to verify all backup data or secondary backup data in a specified path.

   Syntax:

   obclient> obclient> ALTER SYSTEM VALIDATE DATABASE backup_dest='xxx' WITH 'backup_cluster_name=yyy&backup_cluster_id=zzz';
   

   Parameters:

   • xxx is the path specified for the backup. Replace it with the actual path.

   • yyy and zzz are the name and ID of the cluster where the backup data is located. You can log on to the cluster where the backup data is located and query the oceanbase.v$ob_cluster view to view the information.

Verify a specified backup set or secondary backup set

1. Log on to the sys tenant of a cluster other than the one with the backup data with the root account.

2. Execute the following statement to verify the backup set or secondary backup set in a specified path in a cluster.

   Syntax:

   obclient> ALTER SYSTEM VALIDATE BACKUPSET backup_set_id backup_dest = 'xxx' WITH 'backup_cluster_name=yyy&backup_cluster_id=zzz';
   

   Parameters:

   • backup_set_id is the ID of the backup set or secondary backup set.

   • xxx is the path specified for the backup. Replace it with the actual path.

   • yyy and zzz are the name and ID of the cluster where the backup data is located. You can log on to the cluster where the backup data is located and query the oceanbase.v$ob_cluster view to view the information.

Verify the specified log backup or secondary log backup

1. Log on to the sys tenant of a cluster other than the one with the backup data with the root account.

2. Execute the following statement to verify the log backup or the secondary log backup in a specified path in a cluster.

   Syntax:

   obclient> ALTER SYSTEM VALIDATE BACKUPPIECE backup_piece_id backup_dest = 'xxx' WITH 'backup_cluster_name=yyy&backup_cluster_id=zzz';
   

   Parameters:

   • backup_piece_id is the piece_id of the log backup or the secondary log backup.

   • xxx is the path specified for the log backup. Replace it with the actual path.

   • yyy and zzz are the name and ID of the cluster where the backup data is located. You can log on to the cluster where the backup data is located and query the oceanbase.v$ob_cluster view to view the information.

Related topics

After you perform verification, you can query the corresponding views to check the verification results. For more information, see View data verification results.