nfs搭建备份介质报错

OceanBase
#1

image
image1432×575 21.4 KB

mount.nfs4: an incorrect mount option was specified

#3

可以按照我们官方文档的配置部署nfs，配置参数建议要保持一致，否则备份恢复的时候可能出现报错

https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000000749086

#4

这命令不就是你们官方文档的吗

#5

好好看截图

#6

mount -tnfs4 -o rw,nfsvers=4.1,sync,lookupcache=positive,hard,timeo=600,wsize=1048576,rsize=1048576,namlen=255 ip:/data/nfs_server（挂载的磁盘路径） /home/lzq/back3（挂载地点）

#7

你上面的截图已经挂载成功了吧，df -h看到nfs挂上去了，你重复执行，当然报错了

#9

image
image1920×953 115 KB

mount -t nfs -o nolock,nfsvers=3,vers=3 192.168.31.130:/home/xiaowu/nfs /mnt/
不是，用官方文档的命令挂载不成功，后面用这条命令挂载上去的，但是备份还是报错

#10
#11

ob ocp 都是什么版本呢。

#12

227行的sql，执行的结果是什么

#13

select * from (SELECT incarnation, round_id AS log_archive_round, tenant_id, path AS backup_dest, IF(start_scn_display != ‘’, start_scn_display, NULL) AS min_first_time, IF(checkpoint_scn_display != ‘’, checkpoint_scn_display, NULL) AS max_next_time, status, IF(checkpoint_scn != ‘’, truncate((time_to_usec(now()) - checkpoint_scn / 1000) / 1000000, 4), NULL) AS delay, now(6) AS check_time FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = 1004 AND round_id = (SELECT MAX(round_id) FROM CDB_OB_ARCHIVELOG_SUMMARY WHERE tenant_id = 1004));

看看结果。
SELECT * FROM DBA_OB_TENANTS\G 也看下

#14

image
image1434×296 13 KB

SELECT * FROM DBA_OB_TENANTS\G
*************************** 1. row ***************************
TENANT_ID: 1
TENANT_NAME: sys
TENANT_TYPE: SYS
CREATE_TIME: 2024-04-25 18:08:03.855729
MODIFY_TIME: 2024-04-25 18:08:03.855729
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 1
COMPATIBLE: 4.2.2.1
MAX_LS_ID: 1
*************************** 2. row ***************************
TENANT_ID: 1001
TENANT_NAME: META$1002
TENANT_TYPE: META
CREATE_TIME: 2024-04-25 18:08:41.895507
MODIFY_TIME: 2024-04-25 18:09:35.924052
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 3
COMPATIBLE: 4.2.2.1
MAX_LS_ID: 1
*************************** 3. row ***************************
TENANT_ID: 1002
TENANT_NAME: ocp
TENANT_TYPE: USER
CREATE_TIME: 2024-04-25 18:08:41.901183
MODIFY_TIME: 2024-04-25 18:09:36.080774
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: 1714379283509306000
REPLAYABLE_SCN: 1714379283509306000
READABLE_SCN: 1714379283509306000
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 3
COMPATIBLE: 4.2.2.1
MAX_LS_ID: 1003
*************************** 4. row ***************************
TENANT_ID: 1003
TENANT_NAME: META$1004
TENANT_TYPE: META
CREATE_TIME: 2024-04-25 20:45:02.677314
MODIFY_TIME: 2024-04-25 20:46:05.448767
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: NULL
REPLAYABLE_SCN: NULL
READABLE_SCN: NULL
RECOVERY_UNTIL_SCN: NULL
LOG_MODE: NOARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 3
COMPATIBLE: 4.2.2.1
MAX_LS_ID: 1
*************************** 5. row ***************************
TENANT_ID: 1004
TENANT_NAME: creality_util
TENANT_TYPE: USER
CREATE_TIME: 2024-04-25 20:45:02.682442
MODIFY_TIME: 2024-04-25 20:46:05.592531
PRIMARY_ZONE: RANDOM
LOCALITY: FULL{1}@zone1
PREVIOUS_LOCALITY: NULL
COMPATIBILITY_MODE: MYSQL
STATUS: NORMAL
IN_RECYCLEBIN: NO
LOCKED: NO
TENANT_ROLE: PRIMARY
SWITCHOVER_STATUS: NORMAL
SWITCHOVER_EPOCH: 0
SYNC_SCN: 1714379283195000004
REPLAYABLE_SCN: 1714379283195000004
READABLE_SCN: 1714379283195000004
RECOVERY_UNTIL_SCN: 4611686018427387903
LOG_MODE: ARCHIVELOG
ARBITRATION_SERVICE_STATUS: DISABLED
UNIT_NUM: 3
COMPATIBLE: 4.2.2.1
MAX_LS_ID: 1003
5 rows in set (0.226 sec)

#15

当前使用的ob ocp obd都是什么版本呢。
ocp可以看下帮助下面的关于OCP
obd --version
ob可以看下集群上面的observer提示

#16

image
image750×232 9.95 KB

#17

其他的版本也需要看下呢。

#18

怎么看呀，

#19

ocp可以看下帮助下面的关于OCP
ob可以看下集群上面的observer提示