Overview
The DBA_OB_TENANT_flashBACK_LOG_SCN view displays information about each log truncation for the current tenant.
Columns
field |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| TIMESTAMP | timestamp(6) | NO | Creation time, in microseconds |
| SWITCHOVER_EPOCH | bigint(20) | NO | Tenant role switched to NORMAL When the status is SWITCHOVER_EPOCH. SWITCHOVER_EPOCH is a flag used to identify tenant role switchover/Failover is the unique identifier of the operation. |
| OP_TYPE | varchar(64) | NO | Operation type. Valid values:
|
| FLASHBACK_LOG_SCN | bigint(20) unsigned | NO | End Point for Trimming Tenant Logs from Back to Front |
Sample query
Query information about each log trimming operation in the current tenant.
obclient(root@sys)[oceanbase]> SELECT * FROM oceanbase.DBA_OB_TENANT_FLASHBACK_LOG_SCN;
References
- Failover