View the progress of secondary data backup tasks

This topic describes how to view the progress of secondary backup tasks after they are initiated.

The method of viewing the progress of secondary backup tasks for a cluster is the same as that for a tenant.

View the status of a secondary data backup task

After the worker thread for running a secondary backup task is started, you can check the status of the secondary backup task by using the following views:

• oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB

• oceanbase.CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY

• oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK

• oceanbase.CDB_OB_BACKUP_BACKUPSET_TASK_HISTORY

• oceanbase.CDB_OB_BACKUP_BACKUP_ARCHIVELOG_SUMMARY

• oceanbase.CDB_OB_BACKUP_PIECE_FILES

• oceanbase.CDB_OB_BACKUP_SET_FILES

For more information about the fields of each view, see System views.

View the progress and history of secondary data backup tasks in a view

1. Log on to the sys tenant as the root user.

2. Access the database named oceanbase.

   obclient> USE oceanbase;
   

3. Perform the following steps:

   • View the progress of a secondary data backup task

     obclient> SELECT * FROM CDB_OB_BACKUP_BACKUPSET_JOB;
     +--------+-----------+-------------+---------------+-------------------+-------------+----------+-----------------------------------------+------------------+--------+
     | JOB_ID | TENANT_ID | INCARNATION | BACKUP_SET_ID | TYPE              | TENANT_NAME | STATUS   | BACKUP_DEST                             | MAX_BACKUP_TIMES | RESULT |
     +--------+-----------+-------------+---------------+-------------------+-------------+----------+-----------------------------------------+------------------+--------+
     |      1 |         1 |           1 |             1 | SINGLE_BACKUP_SET |             | SCHEDULE |  file:///data/nfs/backup_backup         |               -1 |      0 |
     +--------+-----------+-------------+---------------+-------------------+-------------+----------+-----------------------------------------+------------------+--------+
     1 row in set (0.10 sec)
     

   • View the result of a secondary data backup task

     obclient> SELECT * FROM CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY;
     +--------+-----------+-------------+---------------+-------------------+-------------+---------+-----------------------------+------------------+--------+
     | JOB_ID | TENANT_ID | INCARNATION | BACKUP_SET_ID | TYPE              | TENANT_NAME | STATUS  | BACKUP_DEST                 | MAX_BACKUP_TIMES | RESULT |
     +--------+-----------+-------------+---------------+-------------------+-------------+---------+-----------------------------+------------------+--------+
     |      1 |         1 |           1 |             1 | SINGLE_BACKUP_SET |             | SUCCESS | file:///data/1/backupbackup |               -1 |      0 |
     +--------+-----------+-------------+---------------+-------------------+-------------+---------+-----------------------------+------------------+--------+
     

   For more information about the CDB_OB_BACKUP_BACKUPSET_JOB and CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY views, see CDB_OB_BACKUP_BACKUPSET_JOB and CDB_OB_BACKUP_BACKUPSET_JOB_HISTORY.

View the progress and history of secondary log backup tasks in a view

1. Log on to the sys tenant as the root user.

2. Access the database named oceanbase.

   obclient> USE oceanbase;
   

3. Perform the following steps:

   • View the progress of a secondary log backup task

     obclient> SELECT * FROM CDB_OB_BACKUP_BACKUPPIECE_JOB;
     +--------+-----------+-------------+-----------------+------------------+--------+--------+--------------------------------+---------+------+
     | JOB_ID | TENANT_ID | INCARNATION | BACKUP_PIECE_ID | MAX_BACKUP_TIMES | RESULT | STATUS | BACKUP_DEST                    | COMMENT | TYPE |
     +--------+-----------+-------------+-----------------+------------------+--------+--------+--------------------------------+---------+------+
     |      3 |         1 |           1 |               1 |               -1 |      0 |  DOING | file:///data/nfs/backup_backup |         |    0 |
     |      4 |         1 |           1 |               2 |               -1 |      0 |  DOING | file:///data/nfs/backup_backup |         |    0 |
     +--------+-----------+-------------+-----------------+------------------+--------+--------+--------------------------------+---------+------+
     2 rows in set (0.09 sec)
     

   • View the result of a secondary log backup task

     obclient> SELECT * FROM CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY;
     +--------+-----------+-------------+-----------------+------------------+--------+--------+-------------------------------+---------+------+
     | JOB_ID | TENANT_ID | INCARNATION | BACKUP_PIECE_ID | MAX_BACKUP_TIMES | RESULT | STATUS | BACKUP_DEST                   | COMMENT | TYPE |
     +--------+-----------+-------------+-----------------+------------------+--------+--------+-------------------------------+---------+------+
     |      3 |         1 |           1 |               1 |               -1 |      0 | FINISH | file:///data/nfs/backup_backup|         |    0 |
     |      4 |         1 |           1 |               2 |               -1 |      0 | FINISH | file:///data/nfs/backup_backup|         |    0 |
     +--------+-----------+-------------+-----------------+------------------+--------+--------+-------------------------------+---------+------+
     2 rows in set (0.09 sec)
     

   For more information about the CDB_OB_BACKUP_BACKUPPIECE_JOB and CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY views, see CDB_OB_BACKUP_BACKUPPIECE_JOB and CDB_OB_BACKUP_BACKUPPIECE_JOB_HISTORY.

Check the secondary backup progress in OCP

After a secondary data or log backup task is launched, you can view the progress and result of the backup in OceanBase Cloud Platform (OCP).

1. Log on to the OCP console.

2. In the left-side navigation pane, choose Backup and Recovery > Backup.

3. On the Secondary Backup tab, view the backup progress.

   • On the Secondary Data Backup tab, find the target task and check its progress and result.

     The information about the secondary data backup task is displayed in the following columns: ID, Cluster, Tenant, Backup Set ID, Started At, Ended At, Storage Directory, and Status.

   • On the Secondary Log Backup tab, find the target task and check its progress and result.

     The information about the secondary log backup task is displayed in the following columns: Cluster, Latest Backup Time, Storage Directory, Started At, and Status.