View data verification results

After data verification is performed, you can view the data verification results in views.

View an ongoing data verification task

1. Log on to the sys tenant of the cluster, in which the ongoing data verification task is performed, with the root account.

2. Access the database named oceanbase.

   obclient> USE oceanbase;
   

3. Perform the following steps:

   • View the progress of the ongoing data verification task.

     obclient> SELECT * FROM CDB_OB_BACKUP_VALIDATION_JOB;
     

   • View the details of the ongoing data verification task.

     obclient> SELECT * FROM CDB_OB_TENANT_BACKUP_VALIDATION_TASK;
     

   In the returned result, check the values of the STATUS and RESULT fields. If the value of STATUS is FINISH and the value of RESULT is 0, the backup data is valid. If the value of STATUS is FINISH and the value of RESULT is not 0, the backup data is abnormal.

View a completed data verification task

1. Log on to the sys tenant of the cluster, in which the ongoing data verification task is performed, with the root account.

2. Access the database named oceanbase.

   obclient> USE oceanbase;
   

3. Perform the following steps:

   • View a completed data verification task.

     obclient> SELECT * FROM CDB_OB_BACKUP_VALIDATION_JOB_HISTORY;
     

   • View the details of the completed data verification task.

     obclient> SELECT * FROM CDB_OB_BACKUP_VALIDATION_TASK_HISTORY;
     

   In the returned result, check the values of the STATUS and RESULT fields. If the value of STATUS is FINISH and the value of RESULT is 0, the backup data is valid. If the value of STATUS is FINISH and the value of RESULT is not 0, the backup data is abnormal.

Related topics

• Verify backup data in a cluster

• Verify backup data in a specified path in a cluster

• Verify backup data in a specified path across clusters