After log archiving is enabled, you can query views for the archiving progress.
View the archiving progress of all tenants from the sys tenant
You can query the oceanbase.CDB_OB_ARCHIVELOG view from the sys tenant for the archiving progress of all tenants in the cluster.
Log on to the
systenant of the cluster as therootuser.Execute the following statement to view the log archiving progress:
obclient [(none)]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG\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: 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 2 row in setIn the preceding example, the current cluster contains two tenants with the IDs
1002and1004. Archiving is in progress for the two tenants.The value of
round_idof tenant1002is2, indicating that log archiving is enabled the second time. The archive media isNFS, and the archive path is/data/nfs/backup/archive. One piece with the piece ID4has been generated since log archiving is enabled. Logs whose SCNs fall in the range from'2022-06-20 12:00:00.000000'to'2022-06-21 08:00:00.000000'are archived.The value of
round_idof tenant1004is1, indicating that log archiving is enabled the first time. The archive media isOSS, the storage bucket isoceanbase-test-bucket, and the archive path is/backup/archive. Two pieces with the piece IDs1and2have 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.
For more information about the CDB_OB_ARCHIVELOG view, see CDB_OB_ARCHIVELOG.
View the archiving progress of a user tenant
You can query the oceanbase.DBA_OB_ARCHIVELOG view from a MySQL tenant or the sys.DBA_OB_ARCHIVELOG view from an Oracle tenant for the archiving progress of the tenant.
Log on to the database as a tenant administrator.
Note
The administrator user of a MySQL tenant is
rootand that of an Oracle tenant isSYS.View the log archiving progress of the current tenant.
To view all pieces of a MySQL tenant, execute the following statement:
obclient [(none)]> SELECT * FROM oceanbase.DBA_OB_ARCHIVELOG\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 1 row in set