Note
This view is available starting with V4.0.0.
Purpose
This view displays the information about the backup destinations used for backup and restore in the current tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| PATH | VARCHAR2(1024) | NO | The root path for backup. |
| ENDPOINT | VARCHAR2(256) | NO | The HOST to be set for object storage access. |
| DEST_ID | NUMBER(38) | YES | The ID of the backup destination. |
| DEST_TYPE | VARCHAR2(64) | YES | The type of the backup destination. Valid values:
|
| AUTHORIZATION | VARCHAR2(1024) | NO | The authorization information for object storage. |
| EXTENSION | VARCHAR2(512) | NO | The remaining parameters of the backup destination. |
| CHECK_FILE_NAME | VARCHAR2(256) | YES | The name of the file for connectivity verification. |
| LAST_CHECK_TIMESTAMP | VARCHAR2(256) | NO | The time when the last connectivity check was successful. |
| MAX_IOPS | NUMBER(38) | NO | The maximum IOPS allowed for the backup media used for backup.
NoteThis column is available starting with V4.3.5. |
| MAX_BANDWIDTH | NUMBER(38) | NO | The maximum bandwidth allowed for the backup media used for backup, in bytes.
NoteThis column is available starting with V4.3.5. |
| MAX_BANDWIDTH_DISPLAY | VARCHAR2(44) | NO | The display format of the maximum bandwidth. The converted format is similar to 10GB/s or 10MB/s.
NoteThis column is available starting with V4.3.5. |
Sample query
Query the information about the backup destinations used for backup and restore in the user tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_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 | MAX_IOPS | MAX_BANDWIDTH | MAX_BANDWIDTH_DISPLAY |
+-----------+--------------------------------------------+----------+---------+-------------+---------------+-----------+-----------------------------------------+----------------------------+----------+---------------+-----------------------+
| 1004 | file:///home/admin/oceanbase/arglogorc | | 1001 | archive_log | | | 1004_connect_file_20250103T081853.obbak | 2025-01-03 16:19:04.807451 | 0 | 0 | UNLIMITED |
| 1004 | file:///home/admin/oceanbase/backupdataorc | | 1002 | backup_data | | | 1004_connect_file_20250103T081928.obbak | 2025-01-03 16:20:34.069255 | 0 | 0 | UNLIMITED |
+-----------+--------------------------------------------+----------+---------+-------------+---------------+-----------+-----------------------------------------+----------------------------+----------+---------------+-----------------------+
2 rows in set