Purpose
The oceanbase.DBA_OB_BACKUP_JOB_HISTORY view displays the history of backup jobs in the current tenant.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| 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 is incremented from 1 for user tenants. |
| INITIATOR_TENANT_ID | bigint(20) | NO | The tenant ID of the job initiator, which indicates the initiating tenant of 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 job 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. |