You can query views for the archiving history, including information about ongoing archiving tasks.
View the archiving history of all tenants from the sys tenant
You can query the oceanbase.CDB_OB_ARCHIVELOG_SUMMARY view from the sys tenant for the archiving history of all tenants in the cluster.
Log in to the
systenant of the cluster as therootuser.Execute the following statement to view the archiving history of all tenants in the cluster:
obclient [(none)]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY\G *************************** 1. row *************************** TENANT_ID: 1002 DEST_ID: 1002 ROUND_ID: 2 INCARNATION: 1 DEST_NO: 0 STATUS: DOING START_SCN: 1655697600000000000 START_SCN_DISPLAY: 2022-06-20 12:00:00.000000 CHECKPOINT_SCN: 1655769600000000000 CHECKPOINT_SCN_DISPLAY: 2022-06-21 08:00:00.000000 COMPATIBLE: 1 BASE_PIECE_ID: 4 USED_PIECE_ID: 4 PIECE_SWITCH_INTERVAL: 1d INPUT_BYTES: 16106127360 INPUT_BYTES_DISPLAY: 15.00GB OUTPUT_BYTES: 16106127360 OUTPUT_BYTES_DISPLAY: 15.00GB COMPRESSION_RATIO: 1.00 DELETED_INPUT_BYTES: 0 DELETED_INPUT_BYTES_DISPLAY: 0.00MB DELETED_OUTPUT_BYTES: 0 DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB COMMENT: PATH: s3://oceanbase-test-bucket/backup/data?host=obs.****.myhuaweicloud.com *************************** 2. row *************************** TENANT_ID: 1002 DEST_ID: 1002 ROUND_ID: 1 INCARNATION: 1 DEST_NO: 0 STATUS: STOP START_SCN: 1654034400000000000 START_SCN_DISPLAY: 2022-06-01 06:00:00.000000 CHECKPOINT_SCN: 1654228800000000000 CHECKPOINT_SCN_DISPLAY: 2022-06-03 12:00:00.000000 COMPATIBLE: 1 BASE_PIECE_ID: 1 USED_PIECE_ID: 3 PIECE_SWITCH_INTERVAL: 1d INPUT_BYTES: 96636764160 INPUT_BYTES_DISPLAY: 90.00GB OUTPUT_BYTES: 96636764160 OUTPUT_BYTES_DISPLAY: 90.00GB COMPRESSION_RATIO: 1.00 DELETED_INPUT_BYTES: 26843545600 DELETED_INPUT_BYTES_DISPLAY: 25.00GB DELETED_OUTPUT_BYTES: 26843545600 DELETED_OUTPUT_BYTES_DISPLAY: 25.00GB COMMENT: PATH: s3://oceanbase-test-bucket/backup/data?host=obs.****.myhuaweicloud.com *************************** 3. row *************************** TENANT_ID: 1004 DEST_ID: 1001 ROUND_ID: 1 INCARNATION: 1 DEST_NO: 0 STATUS: DOING START_SCN: 1655658000000000000 START_SCN_DISPLAY: 2022-06-20 01:00:00.000000 CHECKPOINT_SCN: 1655769600000000000 CHECKPOINT_SCN_DISPLAY: 2022-06-21 08:00:00.000000 COMPATIBLE: 1 BASE_PIECE_ID: 1 USED_PIECE_ID: 2 PIECE_SWITCH_INTERVAL: 1d INPUT_BYTES: 161061273600 INPUT_BYTES_DISPLAY: 150.00GB OUTPUT_BYTES: 161061273600 OUTPUT_BYTES_DISPLAY: 150.00GB COMPRESSION_RATIO: 1.00 DELETED_INPUT_BYTES: 0 DELETED_INPUT_BYTES_DISPLAY: 0.00MB DELETED_OUTPUT_BYTES: 0 DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB COMMENT: PATH: s3://oceanbase-test-bucket/backup/archive?host=xxx.aliyun-inc.com 3 row in set
In the preceding example, the current cluster contains two tenants with the IDs 1002 and 1004. For tenant 1002, archiving is enabled for the second time and information about two rounds of archiving exists. For tenant 1004, archiving is enabled for the first time and only information about the current round of archiving exists.
For tenant 1002, logs whose SCNs fall within the range from '2022-06-01 06:00:00.000000' to '2022-06-03 12:00:00.000000' are archived during the first round of archiving, generating three pieces with the piece IDs 1 to 3. The amount of archived log data is 90 GB.
The value of round_id of tenant 1004 is 1, indicating that archiving is enabled for the first time. The archive media is S3, the bucket is oceanbase-test-bucket, and the archive path is /backup/archive. Two pieces with the piece IDs 1 and 2 have been generated since archiving is enabled. Logs whose SCNs fall within the range from '2022-06-20 01:00:00.000000' to '2022-06-21 08:00:00.000000' are archived.
For more information about the CDB_OB_ARCHIVELOG_SUMMARY view, see CDB_OB_ARCHIVELOG_SUMMARY.
View the archiving history of a user tenant
You can query the oceanbase.DBA_OB_ARCHIVELOG_SUMMARY view from a user tenant for the archiving history of the tenant.
Log in to the database as the tenant administrator of the user tenant.
Note
The administrator user of a user tenant is the
rootuser.View the log archiving history of the current tenant.
Here is an example of how to view the archiving history of the current tenant from a user tenant:
obclient [(none)]> SELECT * FROM oceanbase.DBA_OB_ARCHIVELOG_SUMMARY\G *************************** 1. row *************************** DEST_ID: 1002 ROUND_ID: 2 INCARNATION: 1 DEST_NO: 0 STATUS: DOING START_SCN: 1655697600000000000 START_SCN_DISPLAY: 2022-06-20 12:00:00.000000 CHECKPOINT_SCN: 1655769600000000000 CHECKPOINT_SCN_DISPLAY: 2022-06-21 08:00:00.000000 COMPATIBLE: 1 BASE_PIECE_ID: 4 USED_PIECE_ID: 4 PIECE_SWITCH_INTERVAL: 1d INPUT_BYTES: 16106127360 INPUT_BYTES_DISPLAY: 15.00GB OUTPUT_BYTES: 16106127360 OUTPUT_BYTES_DISPLAY: 15.00GB COMPRESSION_RATIO: 1.00 DELETED_INPUT_BYTES: 0 DELETED_INPUT_BYTES_DISPLAY: 0.00MB DELETED_OUTPUT_BYTES: 0 DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB COMMENT: PATH: s3://oceanbase-test-bucket/backup/data?host=obs.****.myhuaweicloud.com *************************** 2. row *************************** DEST_ID: 1002 ROUND_ID: 1 INCARNATION: 1 DEST_NO: 0 STATUS: STOP START_SCN: 1654034400000000000 START_SCN_DISPLAY: 2022-06-01 06:00:00.000000 CHECKPOINT_SCN: 1654228800000000000 CHECKPOINT_SCN_DISPLAY: 2022-06-03 12:00:00.000000 COMPATIBLE: 1 BASE_PIECE_ID: 1 USED_PIECE_ID: 3 PIECE_SWITCH_INTERVAL: 1d INPUT_BYTES: 96636764160 INPUT_BYTES_DISPLAY: 90.00GB OUTPUT_BYTES: 96636764160 OUTPUT_BYTES_DISPLAY: 90.00GB COMPRESSION_RATIO: 1.00 DELETED_INPUT_BYTES: 32212254720 DELETED_INPUT_BYTES_DISPLAY: 30.00GB DELETED_OUTPUT_BYTES: 32212254720 DELETED_OUTPUT_BYTES_DISPLAY: 30.00GB COMMENT: PATH: s3://oceanbase-test-bucket/backup/data?host=obs.****.myhuaweicloud.com 2 row in set