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 cluster.
Log on to the
systenant of a 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: 7516192768 OUTPUT_BYTES_DISPLAY: 7.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: 42949672960 OUTPUT_BYTES_DISPLAY: 40.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: 32212254720 OUTPUT_BYTES_DISPLAY: 30.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 pieces ID 1 to 3 are generated during the first round of archiving. Logs whose SCNs fall in the range from '2022-06-01 06:00:00.000000' to '2022-06-03 12:00:00.000000' are archived. The amount of raw log data is 90 GB and the amount of archived log data is 40 GB, with a compression ratio of 2.25. 10 GB of archived data is deleted, which sized 25 GB before it is compressed.
round_id of tenant 1004 is 1, indicating that log archiving is enabled the first time. The archive media type is OSS, the storage 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 is enabled. Logs whose SCNs fall in the range from '2022-06-20 01:00:00.000000' to '2022-06-21 08:00:00.000000' are archived. The amount of raw log data is 150 GB and the amount of archived data is 30 GB, with a compression ratio of 5.
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 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 on to the database as an administrator of a user tenant.
Note
The administrator user is
rootfor MySQL tenants andSYSfor Oracle tenants.Execute the following statement to view the log archiving history of the current tenant:
To view the log archive 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: 7516192768 OUTPUT_BYTES_DISPLAY: 7.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