重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: sys_rman 备份初始化sys_backup.sh init 挂起hang [打印本页]

作者: 郑全 时间: 3 小时前
标题: sys_rman 备份初始化sys_backup.sh init 挂起hang
我们执行

/KingbaseES/V9/Server/bin/sys_backup.sh init
就挂起了，一直不动
通过 iostat 查看，没有任何IO

看日志 tail -f /KingbaseES/V9/Server/log/sys_rman_check.log

[kingbase@node1 ~]$ tail -f /KingbaseES/V9/Server/log/sys_rman_check.log
2026-06-07 17:18:35.748 P00 INFO: check command end: terminated on signal [SIGINT]
2026-06-07 17:19:27.045 P00 INFO: check command begin 2.27: --archive-timeout=600 --band-width=0 --config=/backup/rman/sys_rman.conf --exec-id=7447-90e9799a --kb1-path=/data --kb1-port=54321 --kb1-user=system --log-level-console=info --log-level-file=info --log-path=/KingbaseES/V9/Server/log --log-subprocess --process-max=4 --repo1-path=/backup/rman --stanza=kingbase
WARN: set process-max 4 is too large, auto set to CPU core count 2
2026-06-07 17:19:27.053 P00 INFO: check repo1 configuration (primary)
2026-06-07 17:19:27.066 P00 INFO: check repo1 archive for WAL (primary)
2026-06-07 17:20:24.768 P00 INFO: check command end: terminated on signal [SIGINT]
2026-06-07 17:20:52.475 P00 INFO: check command begin 2.27: --archive-timeout=600 --band-width=0 --config=/backup/rman/sys_rman.conf --exec-id=7627-81a45fa5 --kb1-path=/data --kb1-port=54321 --kb1-user=system --log-level-console=info --log-level-file=info --log-path=/KingbaseES/V9/Server/log --log-subprocess --process-max=4 --repo1-path=/backup/rman --stanza=kingbase
WARN: set process-max 4 is too large, auto set to CPU core count 2
2026-06-07 17:20:52.494 P00 INFO: check repo1 configuration (primary)
2026-06-07 17:20:52.510 P00 INFO: check repo1 archive for WAL (primary)

之后就没有消息了。

想到前面提示过没有 archive_command='sys_rman'的问题
是否是这个 archive_command='' 设置的问题，
前面是通过命令 alter system set archive_command=''设置的，参数是放置到 $KINGBASE_DATA/kingbase.auto.conf中去了，难道要放到 $KINGBASE_DATA/kingbase.conf吗

于是恢复默认设置

alter system reset all;

echo "archive_mode='on'" >> $KINGBASE_DATA/kingbase.conf
echo "archive_command=''" >> $KINGBASE_DATA/kingbase.conf

之后，再去初始化，就没有问题了

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)