Purpose
The oceanbase.CDB_OB_BACKUP_JOBS view displays the backup jobs of all tenants in the cluster. Each time a user initiates a backup job, a job record is generated.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
| Column | Column | Nullable? | Column |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| JOB_ID | bigint(20) | NO | The ID of the backup job. A job record is generated for each backup job. |
| INCARNATION | bigint(20) | NO | The Nth incarnation of the database after the Flashback Database operation. |
| BACKUP_SET_ID | bigint(20) | YES | The ID of the backup set. The default value for the sys tenant is 0. The value increments starting from 1 for user tenants. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The ID of the tenant that initiated the job. The value corresponds to the tenant that executes the backup SQL statement. |
| INITIATOR_JOB_ID | bigint(20) | NO | The job ID of the initiator. |
| EXECUTOR_TENANT_ID | varchar(65536) | NO | The ID of the tenant that is associated with the backup job for execution. |
| PLUS_ARCHIVELOG | varchar(4096) | NO | Indicates whether log synchronization is enabled. Valid values:ON: Log synchronization is enabled.OFF: Log synchronization is disabled. |
| BACKUP_TYPE | varchar(4096) | NO | The type of the backup. Valid values:D: indicates full backup.I: indicates incremental backup. |
| JOB_LEVEL | varchar(4096) | NO | The job level. Valid values:CLUSTER: The sys tenant initiates backup jobs for all tenants.SYS_TENANT: The sys tenant initiates backup jobs for specified tenants.USER_TENANT: A user tenant initiates its own backup jobs. |
| ENCRYPTION_MODE | varchar(4096) | YES | The encryption mode. Valid values:None: indicates that encryption is not implemented.Password: indicates that only the password is used for protection.Password Encryption: indicates that encryption is implemented and the password is used for protection.Transparent Encryption: indicates that TDE is used for encryption.Dual Mode Encryption: indicates that TDE encryption is implemented and the password is used for protection.Currently, only the None and Password modes are supported. |
| PASSWD | varchar(4096) | YES | The password. |
| START_TIMESTAMP | timestamp(6) | NO | The start time of the backup job. |
| END_TIMESTAMP | timestamp(6) | NO | The end time of the backup job. |
| STATUS | varchar(4096) | NO | The backup status. |
| RESULT | bigint(20) | NO | The returned backup error code. |
| COMMENT | varchar(4096) | YES | The description of the error code. |
| DESCRIPTION | varchar(4096) | YES | The backup description specified by the user. |
| PATH | varchar(4096) | YES | The backup path. |