Check the backup progress|V3.2.4|OceanBase Database| docs|Distributed Database

Check the backup progress

Last Updated：2023-10-27 09:57:43 Updated

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

Check the data backup progress and history in views

Log on to the sys tenant as the root user.
Access the database named oceanbase.
```
obclient> USE oceanbase;
```

Perform the following steps:

Check the backup progress.

obclient> SELECT * FROM CDB_OB_BACKUP_PROGRESS;
+-------------+--------+-------------+-----------+-----------------+-------------------+------------------------+--------------------------+-------------+--------------+----------------------------+----------------------------+---------+
| INCARNATION | BS_KEY | BACKUP_TYPE | TENANT_ID | PARTITION_COUNT | MACRO_BLOCK_COUNT | FINISH_PARTITION_COUNT | FINISH_MACRO_BLOCK_COUNT | INPUT_BYTES | OUTPUT_BYTES | START_TIME                 | COMPLETION_TIME            | STATUS  |
+-------------+--------+-------------+-----------+-----------------+-------------------+------------------------+--------------------------+-------------+--------------+----------------------------+----------------------------+---------+
|           1 |      1 | D           |         1 |               0 |                 0 |                      0 |                        0 |           0 |            0 | 2021-12-08 15:27:24.600816 | 2021-12-08 15:27:24.917454 | RUNNING |
|           1 |      1 | D           |      1001 |             163 |                 0 |                      0 |                        0 |           0 |            0 | 2021-12-08 15:27:24.600816 | 2021-12-08 15:27:24.891446 | RUNNING |
|           1 |      1 | D           |      1002 |             151 |                 0 |                      0 |                        0 |           0 |            0 | 2021-12-08 15:27:24.600816 | 2021-12-08 15:27:24.875818 | RUNNING |
|           1 |      1 | D           |      1003 |             145 |                 0 |                      0 |                        0 |           0 |            0 | 2021-12-08 15:27:24.600816 | 2021-12-08 15:27:24.859345 | RUNNING |
+-------------+--------+-------------+-----------+-----------------+-------------------+------------------------+--------------------------+-------------+--------------+----------------------------+----------------------------+---------+
4 rows in set

Check the backup history.

obclient> SELECT * FROM CDB_OB_BACKUP_SET_DETAILS;
+-------------+-----------+--------+---------+-------------+-----------------+----------------------------+----------------------------+------------------+------+------------+-------------+------------+--------------+-------------------+-------------------+----------------------+---------------------------+--------------------+--------+---------------------+----------+--------------+
| INCARNATION | TENANT_ID | BS_KEY | COPY_ID | BACKUP_TYPE | ENCRYPTION_MODE | START_TIME                 | COMPLETION_TIME            | ELAPSED_SECONDES | KEEP | KEEP_UNTIL | DEVICE_TYPE | COMPRESSED | OUTPUT_BYTES | OUTPUT_RATE_BYTES | COMPRESSION_RATIO | OUTPUT_BYTES_DISPLAY | OUTPUT_RATE_BYTES_DISPLAY | TIME_TAKEN_DISPLAY | STATUS | START_REPLAY_LOG_TS | DATE     | BACKUP_LEVEL |
+-------------+-----------+--------+---------+-------------+-----------------+----------------------------+----------------------------+------------------+------+------------+-------------+------------+--------------+-------------------+-------------------+----------------------+---------------------------+--------------------+--------+---------------------+----------+--------------+
|           1 |         1 |      1 | 0       | D           | NONE            | 2021-12-08 15:27:24.600816 | 2021-12-08 15:32:25.445473 |              301 | NO   |            | FILE        | NO         |            0 |            0.0000 |              NULL | 0.00MB               | 0.00MB/S                  | 00:05:00.844657    | FAILED |                   0 | 20211208 | CLUSTER      |
|           1 |      1001 |      1 | 0       | D           | NONE            | 2021-12-08 15:27:24.600816 | 2021-12-08 15:32:25.207404 |              301 | NO   |            | FILE        | NO         |            0 |            0.0000 |              NULL | 0.00MB               | 0.00MB/S                  | 00:05:00.606588    | FAILED |                   0 | 20211208 | CLUSTER      |
|           1 |      1002 |      1 | 0       | D           | NONE            | 2021-12-08 15:27:24.600816 | 2021-12-08 15:32:25.180556 |              301 | NO   |            | FILE        | NO         |            0 |            0.0000 |              NULL | 0.00MB               | 0.00MB/S                  | 00:05:00.579740    | FAILED |                   0 | 20211208 | CLUSTER      |
|           1 |      1003 |      1 | 0       | D           | NONE            | 2021-12-08 15:27:24.600816 | 2021-12-08 15:32:25.158159 |              301 | NO   |            | FILE        | NO         |            0 |            0.0000 |              NULL | 0.00MB               | 0.00MB/S                  | 00:05:00.557343    | FAILED |                   0 | 20211208 | CLUSTER      |
+-------------+-----------+--------+---------+-------------+-----------------+----------------------------+----------------------------+------------------+------+------------+-------------+------------+--------------+-------------------+-------------------+----------------------+---------------------------+--------------------+--------+---------------------+----------+--------------+
4 rows in set

For more information about the CDB_OB_BACKUP_PROGRESS and CDB_OB_BACKUP_SET_DETAILS views, see CDB_OB_BACKUP_PROGRESS and CDB_OB_BACKUP_SET_DETAILS.

Check the log backup progress in the relevant view

Log on to the sys tenant as the root user.
Access the database named oceanbase.
```
obclient> use oceanbase;
```

Execute the following statement to check the log backup progress. Statement and sample result:

obclient> SELECT * FROM CDB_OB_BACKUP_ARCHIVELOG;
+-------------+-------------------+-----------+--------+----------------+-----------------+----------------------------+----------------------------+-------------+--------------+-------------------+---------------------+----------------------+
| INCARNATION | LOG_ARCHIVE_ROUND | TENANT_ID | STATUS | START_PIECE_ID | BACKUP_PIECE_ID | MIN_FIRST_TIME             | MAX_NEXT_TIME              | INPUT_BYTES | OUTPUT_BYTES | COMPRESSION_RATIO | INPUT_BYTES_DISPLAY | OUTPUT_BYTES_DISPLAY |
+-------------+-------------------+-----------+--------+----------------+-----------------+----------------------------+----------------------------+-------------+--------------+-------------------+---------------------+----------------------+
|           1 |                 1 |         1 | DOING  |              1 |               1 | 2021-07-22 15:18:06.135913 | 2021-07-22 15:18:10.116704 |           0 |            0 |              NULL | 0.00MB              | 0.00MB               |
|           1 |                 1 |      1001 | DOING  |              1 |               1 | 2021-07-22 15:18:06.135913 | 2021-07-22 15:18:10.483601 |           0 |            0 |              NULL | 0.00MB              | 0.00MB               |
|           1 |                 1 |      1002 | DOING  |              1 |               1 | 2021-07-22 15:18:06.135913 | 2021-07-22 15:18:10.116704 |           0 |            0 |              NULL | 0.00MB              | 0.00MB               |
+-------------+-------------------+-----------+--------+----------------+-----------------+----------------------------+----------------------------+-------------+--------------+-------------------+---------------------+----------------------+
3 rows in set

For more information about the CDB_OB_BACKUP_ARCHIVELOG view, see CDB_OB_BACKUP_ARCHIVELOG.

Check the backup progress in OCP

After a backup task starts, you can check its progress in OceanBase Cloud Platform (OCP).

Log on to the OCP console.
In the left-side navigation pane, choose Backup and Recovery > Backup.
Check the progress of data backup and log backup tasks on the corresponding tabs.
- On the Data Backup Tasks tab, find the required data backup task and check its progress.
  
  The information about the data backup task is displayed in the following columns: ID, Cluster, Tenant, Data Backup Method, Backup Set ID, Started At, Ended At, Status, and Second Backup.
- On the Log Backup Tasks tab, find the required log backup task and check its progress.
  
  The information about the log backup task is displayed in the following columns: Cluster, Backup Method, Host IP Address, Last Backed up At, Latency, Storage Directory, Started At, and Status.