You can query views for the archiving history, including the information about ongoing archiving jobs.
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 current cluster.
Log in to the
systenant of the cluster as therootuser.Execute the following statement to query 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: file:///data/nfs/backup/archive *************************** 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: file:///data/nfs/backup/archive *************************** 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: oss://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, log archiving is enabled the second time and information about two rounds of archiving exists. For tenant 1004, log archiving is enabled the first time and only information about the current round of archiving exists.
For tenant 1002, three pieces with the piece IDs 1 to 3 are generated during the first round of archiving. Logs whose system change numbers (SCNs) fall within the range of '2022-06-01 06:00:00.000000' to '2022-06-03 12:00:00.000000' are archived. 10 GB of archived data is deleted, which is 25 GB in size before it is compressed.
round_id of tenant 1004 is 1, indicating that log archiving is enabled the first time. The archive destination type is OSS, 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 log archiving was enabled. Logs whose SCNs fall within the range of '2022-06-20 01:00:00.000000' to '2022-06-21 08:00:00.000000' are archived.
View the archiving history of a user tenant
You can query the oceanbase.DBA_OB_ARCHIVELOG_SUMMARY view from a user tenant in MySQL mode or the sys.DBA_OB_ARCHIVELOG_SUMMARY view from a user tenant in Oracle mode for the archiving history of the tenant.
Log in to the database as an administrator of a user tenant.
Note
The administrator user is the
rootuser in a MySQL tenant and theSYSuser in an Oracle tenant.View the log archiving history of the current tenant.
To view the log archiving history of a MySQL tenant, execute the following statement:
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: file:///data/nfs/backup/archive *************************** 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: file:///data/nfs/backup/archive 2 row in set