View the archiving progress

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.

1. Log on to the sys tenant of a cluster as the root user.

2. 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: 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: 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
   2 row in set
   

   In the preceding example, the current cluster contains two tenants with the IDs 1002 and 1004. Archiving is in progress for the two tenants.

   round_id of tenant 1002 is 2, indicating that log archiving is enabled the second time. The archive media type is NFS, and the archive path is /data/nfs/backup/archive. One piece with the piece ID 4 has 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 amount of raw log data is 15 GB and the amount of archived data is 7 GB, with a compression ratio of 2.14.

   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 view, see CDB_OB_ARCHIVELOG.

View the archiving progress of a user tenant

You can query the oceanbase.DBA_OB_ARCHIVELOG view from a user tenant in MySQL mode or the sys.DBA_OB_ARCHIVELOG view from a user tenant in Oracle mode for the archiving progress of the tenant.

1. Log on to the database as a tenant administrator.

   Note

   The administrator user is root for MySQL tenants and SYS for Oracle tenants.

2. Execute the following statement to 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
   

More information

View the archiving history