Note
This view is available starting with V4.0.0.
Overview
Displays information about backup destinations used for backup and restore operations under all tenants.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| PATH | varchar(1024) | NO | Root Path of Backup |
| ENDPOINT | varchar(256) | NO | Host for object storage access |
| DEST_ID | bigint(20) | YES | Backup Destination ID |
| DEST_TYPE | varchar(64) | YES | Type of the backup destination:
|
| AUTHORIZATION | varchar(1024) | NO | Object Storage Authorization Information |
| EXTENSION | varchar(512) | NO | Other parameters of the backup destination |
| CHECK_FILE_NAME | varchar(256) | YES | Verification File Name for Connectivity |
| LAST_CHECK_TIMESTAMP | timestamp(6) | YES | Time of Last Connectivity Check Pass |
Sample query
View the backup destination information used for backup and restore operations under all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_STORAGE_INFO;
The query result is as follows:
+-----------+-----------------------------------------+----------+---------+-------------+---------------+-----------+-----------------------------------------+----------------------------+
| TENANT_ID | PATH | ENDPOINT | DEST_ID | DEST_TYPE | AUTHORIZATION | EXTENSION | CHECK_FILE_NAME | LAST_CHECK_TIMESTAMP |
+-----------+-----------------------------------------+----------+---------+-------------+---------------+-----------+-----------------------------------------+----------------------------+
| 1002 | file:///home/admin/oceanbase/arglog | | 1001 | archive_log | | | 1002_connect_file_20250102T104305.obbak | 2025-01-02 11:13:56.170960 |
| 1002 | file:///home/admin/oceanbase/backupdata | | 1002 | backup_data | | | 1002_connect_file_20250102T105759.obbak | 2025-01-02 10:58:00.002272 |
+-----------+-----------------------------------------+----------+---------+-------------+---------------+-----------+-----------------------------------------+----------------------------+
2 rows in set