Views related to physical restore

OceanBase Database allows you to query views for the restore progress and results.

CDB_OB_RESTORE_PROGRESS

The CDB_OB_RESTORE_PROGRESS view displays the restore progress of tenants.

DBA_OB_RESTORE_PROGRESS

The DBA_OB_RESTORE_PROGRESS view displays ongoing restore jobs.

• For more information about this view in the sys tenant, see DBA_OB_RESTORE_PROGRESS.

• For more information about this view in an Oracle tenant, see DBA_OB_RESTORE_PROGRESS.

• For more information about this view in a MySQL tenant, see DBA_OB_RESTORE_PROGRESS.

CDB_OB_RESTORE_HISTORY

The CDB_OB_RESTORE_HISTORY view displays the restore results of tenants.

DBA_OB_RESTORE_HISTORY

The DBA_OB_RESTORE_HISTORY view displays the restore jobs that have been completed.

• For more information about this view in the sys tenant, see DBA_OB_RESTORE_HISTORY.

• For more information about this view in an Oracle tenant, see DBA_OB_RESTORE_HISTORY.

• For more information about this view in a MySQL tenant, see DBA_OB_RESTORE_HISTORY.

DBA_OB_TENANTS

The DBA_OB_TENANTS view displays the basic information of tenants. The RESTORE_DATA_MODE column in the view records physical restore information.

• For more information about this view in the sys tenant, see DBA_OB_TENANTS.

• For more information about this view in an Oracle tenant, see DBA_OB_TENANTS.

• For more information about this view in a MySQL tenant, see DBA_OB_TENANTS.