alter system backup database; 备份失败

[孤独的狼]

【 使用环境 】生产环境 or 测试环境
测试环境
【 OB or 其他组件 】
【 使用版本 】
【问题描述】清晰明确描述问题
【复现路径】问题出现前后相关操作
【问题现象及影响】
MySQL [oceanbase]>
MySQL [oceanbase]> select incarnation, tenant_id, status, now() from CDB_OB_ARCHIVELOG_SUMMARY;
±------------±----------±------------±--------------------+
| incarnation | tenant_id | status | now() |
±------------±----------±------------±--------------------+
| 1 | 1002 | INTERRUPTED | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
| 1 | 1002 | STOP | 2023-05-16 13:58:26 |
±------------±----------±------------±--------------------+
15 rows in set (0.00 sec)

MySQL [oceanbase]>
MySQL [oceanbase]>
MySQL [oceanbase]> select * from oceanbase.__all_zone where name=‘merge_status’;
Empty set (0.00 sec)

MySQL [oceanbase]>

【附件】

[孤独的狼]

我尝试过重新开启归档。开启后也CDB_OB_ARCHIVELOG_SUMMARY的status字段还是断档状态，我不知道我的问题在哪
[root@dbatest-9-21 data]# obclient -h172.22.9.21 -P2881 -uroot@ocp -p -A oceanbase
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221638892
Server version: OceanBase_CE 4.1.0.0 (r100000202023040520-0765e69043c31bf86e83b5d618db0530cf31b707) (Built Apr 5 2023 20:26:14)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM SET LOG_ARCHIVE_DEST=‘LOCATION=file:///data/nfs/backup/archive’;
Query OK, 0 rows affected (0.028 sec)

obclient [oceanbase]> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE=‘ENABLE’;
Query OK, 0 rows affected (0.014 sec)

obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG Ctrl-C – exit!
Aborted
[root@dbatest-9-21 data]# SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = ‘USER’\G
-bash: SELECT: 未找到命令
[root@dbatest-9-21 data]# obclient -h172.22.9.21 -P2881 -uroot@ocp -p -A oceanbase
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221658477
Server version: OceanBase_CE 4.1.0.0 (r100000202023040520-0765e69043c31bf86e83b5d618db0530cf31b707) (Built Apr 5 2023 20:26:14)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = ‘USER’\G
*************************** 1. row ***************************
TENANT_NAME: ocp
LOG_MODE: NOARCHIVELOG
1 row in set (0.006 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG TENANT = ALL;
ERROR 1227 (42501): Access denied
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> Bye
[root@dbatest-9-21 data]#
[root@dbatest-9-21 data]#
[root@dbatest-9-21 data]# obclient -h172.22.9.21 -P2881 -uroot@sys -p -A oceanbase
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221666952
Server version: OceanBase_CE 4.1.0.0 (r100000202023040520-0765e69043c31bf86e83b5d618db0530cf31b707) (Built Apr 5 2023 20:26:14)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM ARCHIVELOG TENANT = ALL;
Query OK, 0 rows affected (0.006 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> SELECT TENANT_NAME, LOG_MODE FROM oceanbase.DBA_OB_TENANTS WHERE TENANT_TYPE = ‘USER’\G
*************************** 1. row ***************************
TENANT_NAME: ocp
LOG_MODE: ARCHIVELOG
*************************** 2. row ***************************
TENANT_NAME: TEST
LOG_MODE: ARCHIVELOG
2 rows in set (0.003 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM SET data_backup_dest=‘file:///backup/data’ ;
ERROR 1235 (0A000): Not supported feature or function
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> show parameters like ‘%backup_dest%’;
Empty set (0.021 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM SET data_backup_dest=‘file:///backup/data’ ;
ERROR 1235 (0A000): Not supported feature or function
obclient [oceanbase]> Bye
您在 /var/spool/mail/root 中有邮件
[root@dbatest-9-21 data]# obclient -h172.22.9.21 -P2881 -uroot@ocp -p -A oceanbase
Enter password:
Welcome to the OceanBase. Commands end with ; or \g.
Your OceanBase connection id is 3221706014
Server version: OceanBase_CE 4.1.0.0 (r100000202023040520-0765e69043c31bf86e83b5d618db0530cf31b707) (Built Apr 5 2023 20:26:14)

Copyright (c) 2000, 2018, OceanBase and/or its affiliates. All rights reserved.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM SET data_backup_dest=‘file:///backup/data’ ;
Query OK, 0 rows affected (0.405 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> show parameters like ‘%backup_dest%’;
Empty set (0.019 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> select * from oceanbase.cdb_ob_backup_archivelog_summary;
ERROR 1146 (42S02): Table ‘oceanbase.cdb_ob_backup_archivelog_summary’ doesn’t exist
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY;
ERROR 1146 (42S02): Table ‘oceanbase.cdb_ob_archivelog_summary’ doesn’t exist
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_BACKUP_PARAMETER\G
ERROR 1146 (42S02): Table ‘oceanbase.cdb_ob_backup_parameter’ doesn’t exist
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> alter system major freeze;
Query OK, 0 rows affected (0.009 sec)

obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> select * from __all_zone where name=‘merge_status’;
ERROR 1146 (42S02): Table ‘oceanbase.__all_zone’ doesn’t exist
obclient [oceanbase]> alter system backup database;
ERROR 9040 (HY000): backup can not start, because log archive status is not doing.
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> ALTER SYSTEM MAJOR FREEZE;
Query OK, 0 rows affected (0.011 sec)

obclient [oceanbase]> alter system backup database;
ERROR 9040 (HY000): backup can not start, because log archive status is not doing.
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]>
obclient [oceanbase]> select * from oceanbase.__all_zone where name=‘merge_status’;
ERROR 1146 (42S02): Table ‘oceanbase.__all_zone’ doesn’t exist
obclient [oceanbase]>

[渠磊]

@孤独的狼

SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY;

问题好像比较多，我这边逐条回复， 查看集群中所有租户的归档历史需要走root@sys， 用户租户查看当前租户的归档历史走对应租户的root用户就行，我看你这边走的ocp的租户是对ocp进行了日志归档么

关联：https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001697270

[渠磊]

@孤独的狼

ALTER SYSTEM ARCHIVELOG TENANT = ALL;

开启日志备份之后，check以下日志归档任务的状态再发起全量数据备份

关联：前提条件 https://www.oceanbase.com/docs/common-oceanbase-database-cn-10000000001698750

[孤独的狼]

[root@dbatest-9-21 data]# mysql -h172.22.9.21 -P2881 -uroot@sys -p
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 3221550023
Server version: 5.7.25 OceanBase_CE 4.1.0.0 (r100000202023040520-0765e69043c31bf86e83b5d618db0530cf31b707) (Built Apr 5 2023 20:26:14)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MySQL [(none)]> SELECT * FROM oceanbase.CDB_OB_ARCHIVELOG_SUMMARY\G
*************************** 1. row ***************************
TENANT_ID: 1002
DEST_ID: 1009
ROUND_ID: 16
INCARNATION: 1
DEST_NO: 0
STATUS: INTERRUPTED
START_SCN: 1684217303621246420
START_SCN_DISPLAY: 2023-05-16 14:08:23.621246
CHECKPOINT_SCN: 1684217303621246420
CHECKPOINT_SCN_DISPLAY: 2023-05-16 14:08:23.621246
COMPATIBLE: 1
BASE_PIECE_ID: 16
USED_PIECE_ID: 16
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 1075196277
INPUT_BYTES_DISPLAY: 1.00GB
OUTPUT_BYTES: 1075196277
OUTPUT_BYTES_DISPLAY: 1.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
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 2. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 1
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684139623573214377
START_SCN_DISPLAY: 2023-05-15 16:33:43.573214
CHECKPOINT_SCN: 1684139623573214377
CHECKPOINT_SCN_DISPLAY: 2023-05-15 16:33:43.573214
COMPATIBLE: 1
BASE_PIECE_ID: 1
USED_PIECE_ID: 1
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 31865465
INPUT_BYTES_DISPLAY: 30.39MB
OUTPUT_BYTES: 31865465
OUTPUT_BYTES_DISPLAY: 30.39MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 3. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 2
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684139748542856205
START_SCN_DISPLAY: 2023-05-15 16:35:48.542856
CHECKPOINT_SCN: 1684139748542856205
CHECKPOINT_SCN_DISPLAY: 2023-05-15 16:35:48.542856
COMPATIBLE: 1
BASE_PIECE_ID: 2
USED_PIECE_ID: 2
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 65200696
INPUT_BYTES_DISPLAY: 62.18MB
OUTPUT_BYTES: 65200696
OUTPUT_BYTES_DISPLAY: 62.18MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 4. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 3
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684199479528490470
START_SCN_DISPLAY: 2023-05-16 09:11:19.528490
CHECKPOINT_SCN: 1684199479528490470
CHECKPOINT_SCN_DISPLAY: 2023-05-16 09:11:19.528490
COMPATIBLE: 1
BASE_PIECE_ID: 3
USED_PIECE_ID: 3
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 163148473
INPUT_BYTES_DISPLAY: 155.59MB
OUTPUT_BYTES: 163148473
OUTPUT_BYTES_DISPLAY: 155.59MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1003 interrupted.
*************************** 5. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 4
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203125738195166
START_SCN_DISPLAY: 2023-05-16 10:12:05.738195
CHECKPOINT_SCN: 1684203125738195166
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:12:05.738195
COMPATIBLE: 1
BASE_PIECE_ID: 4
USED_PIECE_ID: 4
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 244059470
INPUT_BYTES_DISPLAY: 232.75MB
OUTPUT_BYTES: 244059470
OUTPUT_BYTES_DISPLAY: 232.75MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 6. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 5
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203398943058262
START_SCN_DISPLAY: 2023-05-16 10:16:38.943058
CHECKPOINT_SCN: 1684203398943058262
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:16:38.943058
COMPATIBLE: 1
BASE_PIECE_ID: 5
USED_PIECE_ID: 5
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 328492889
INPUT_BYTES_DISPLAY: 313.28MB
OUTPUT_BYTES: 328492889
OUTPUT_BYTES_DISPLAY: 313.28MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 7. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 6
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203507333482117
START_SCN_DISPLAY: 2023-05-16 10:18:27.333482
CHECKPOINT_SCN: 1684203507333482117
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:18:27.333482
COMPATIBLE: 1
BASE_PIECE_ID: 6
USED_PIECE_ID: 6
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 414325457
INPUT_BYTES_DISPLAY: 395.13MB
OUTPUT_BYTES: 414325457
OUTPUT_BYTES_DISPLAY: 395.13MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 8. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 7
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203632948267305
START_SCN_DISPLAY: 2023-05-16 10:20:32.948267
CHECKPOINT_SCN: 1684203632948267305
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:20:32.948267
COMPATIBLE: 1
BASE_PIECE_ID: 7
USED_PIECE_ID: 7
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 501613952
INPUT_BYTES_DISPLAY: 478.38MB
OUTPUT_BYTES: 501613952
OUTPUT_BYTES_DISPLAY: 478.38MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 9. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 8
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203769238952149
START_SCN_DISPLAY: 2023-05-16 10:22:49.238952
CHECKPOINT_SCN: 1684203769238952149
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:22:49.238952
COMPATIBLE: 1
BASE_PIECE_ID: 8
USED_PIECE_ID: 8
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 590399401
INPUT_BYTES_DISPLAY: 563.05MB
OUTPUT_BYTES: 590399401
OUTPUT_BYTES_DISPLAY: 563.05MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 10. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 9
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684203981348897937
START_SCN_DISPLAY: 2023-05-16 10:26:21.348897
CHECKPOINT_SCN: 1684203981348897937
CHECKPOINT_SCN_DISPLAY: 2023-05-16 10:26:21.348897
COMPATIBLE: 1
BASE_PIECE_ID: 9
USED_PIECE_ID: 9
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 681961385
INPUT_BYTES_DISPLAY: 650.37MB
OUTPUT_BYTES: 681961385
OUTPUT_BYTES_DISPLAY: 650.37MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 11. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 10
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684206931722247420
START_SCN_DISPLAY: 2023-05-16 11:15:31.722247
CHECKPOINT_SCN: 1684206931722247420
CHECKPOINT_SCN_DISPLAY: 2023-05-16 11:15:31.722247
COMPATIBLE: 1
BASE_PIECE_ID: 10
USED_PIECE_ID: 10
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 743796250
INPUT_BYTES_DISPLAY: 709.34MB
OUTPUT_BYTES: 743796250
OUTPUT_BYTES_DISPLAY: 709.34MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 12. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 11
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684208077776746389
START_SCN_DISPLAY: 2023-05-16 11:34:37.776746
CHECKPOINT_SCN: 1684208077776746389
CHECKPOINT_SCN_DISPLAY: 2023-05-16 11:34:37.776746
COMPATIBLE: 1
BASE_PIECE_ID: 11
USED_PIECE_ID: 11
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 824916258
INPUT_BYTES_DISPLAY: 786.70MB
OUTPUT_BYTES: 824916258
OUTPUT_BYTES_DISPLAY: 786.70MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 13. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 12
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684208284968301077
START_SCN_DISPLAY: 2023-05-16 11:38:04.968301
CHECKPOINT_SCN: 1684208284968301077
CHECKPOINT_SCN_DISPLAY: 2023-05-16 11:38:04.968301
COMPATIBLE: 1
BASE_PIECE_ID: 12
USED_PIECE_ID: 12
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 909159522
INPUT_BYTES_DISPLAY: 867.04MB
OUTPUT_BYTES: 909159522
OUTPUT_BYTES_DISPLAY: 867.04MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 14. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 13
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684209035397541794
START_SCN_DISPLAY: 2023-05-16 11:50:35.397541
CHECKPOINT_SCN: 1684209035397541794
CHECKPOINT_SCN_DISPLAY: 2023-05-16 11:50:35.397541
COMPATIBLE: 1
BASE_PIECE_ID: 13
USED_PIECE_ID: 13
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 1006560993
INPUT_BYTES_DISPLAY: 959.93MB
OUTPUT_BYTES: 1006560993
OUTPUT_BYTES_DISPLAY: 959.93MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 15. row ***************************
TENANT_ID: 1002
DEST_ID: 1001
ROUND_ID: 14
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684215780904486332
START_SCN_DISPLAY: 2023-05-16 13:43:00.904486
CHECKPOINT_SCN: 1684215780904486332
CHECKPOINT_SCN_DISPLAY: 2023-05-16 13:43:00.904486
COMPATIBLE: 1
BASE_PIECE_ID: 14
USED_PIECE_ID: 14
PIECE_SWITCH_INTERVAL: 172800000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 1015534375
INPUT_BYTES_DISPLAY: 968.49MB
OUTPUT_BYTES: 1015534375
OUTPUT_BYTES_DISPLAY: 968.49MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
*************************** 16. row ***************************
TENANT_ID: 1002
DEST_ID: 1009
ROUND_ID: 15
INCARNATION: 1
DEST_NO: 0
STATUS: STOP
START_SCN: 1684216427917649198
START_SCN_DISPLAY: 2023-05-16 13:53:47.917649
CHECKPOINT_SCN: 1684216427917649198
CHECKPOINT_SCN_DISPLAY: 2023-05-16 13:53:47.917649
COMPATIBLE: 1
BASE_PIECE_ID: 15
USED_PIECE_ID: 15
PIECE_SWITCH_INTERVAL: 86400000000
UNIT_SIZE: 1
COMPRESSION: none
INPUT_BYTES: 1036515129
INPUT_BYTES_DISPLAY: 988.50MB
OUTPUT_BYTES: 1036515129
OUTPUT_BYTES_DISPLAY: 988.50MB
COMPRESSION_RATIO: 1.00
DELETED_INPUT_BYTES: 0
DELETED_INPUT_BYTES_DISPLAY: 0.00MB
DELETED_OUTPUT_BYTES: 0
DELETED_OUTPUT_BYTES_DISPLAY: 0.00MB
PATH: file:///data/nfs/backup/archive
COMMENT: log stream 1002 interrupted.
16 rows in set (0.02 sec)

MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]>
MySQL [(none)]> SELECT * FROM oceanbase.DBA_OB_ARCHIVELOG_SUMMARY\G
Empty set (0.01 sec)

MySQL [(none)]>

[孤独的狼]

这句没太懂， 因为是刚接触。搞不太懂

[渠磊]

这边看确实是触发日志归档断流了，我这边找下负责的同学看看，可能等下需要你提供下执行日志，稍等下

[孤独的狼]

好的。麻烦了。有可能我们在高可用测试导致的

[孤独的狼]

导致有啥办法解决吗

[孤独的狼]

aa.7z (2.1 MB)
cat observer.log.* |grep "INTERRUPTED"的结果

[渠磊]

群内回复

[渠磊]

结论：用户配置了nfs 目录是/data/backup 归档目录要在/data/backup 下面比如 /data/backup/archive
但是用户配置的 /data/nfs/backup/archive 没有这个目录 用户以为会自动创建一个，现在正确配置后已经正常备份了。