Check data backup

This topic describes how to check the data backup progress and history. The information helps you evaluate whether the backup bandwidth and storage resources are sufficient and whether backup configurations are appropriate.

Check the data backup progress and history in views

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:

   • Check the backup progress.

     obclient> SELECT * FROM CDB_OB_BACKUP_PROGRESS;
     

   • Check the backup history.

     obclient> SELECT * FROM CDB_OB_BACKUP_SET_DETAILS;
     

   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

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

2. Access the database named oceanbase.

   obclient> USE oceanbase;
   

3. 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 (0.00 sec)
   

   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).

Note

The GUI of OCP may vary with the version. This topic takes OCP V3.1.1 as an example. For OCP of other versions, see User Guide of the corresponding version.

1. Log on to the OCP console.

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

3. 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, Backup Method, Data Backup Method, Data Version, Started At, Ended At, Storage Directory, and Status.

   • 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, Start Time, and Status.