我们知道,如果想执行sys_rman执行备份,恢复,需要相关的配置信息,该配置信息是在 sys_rman.conf文件中。
比如,我们想看一下备份情况:
sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase info
WARN: set process-max 4 is too large, auto set to CPU core count 2
stanza: kingbase
status: ok
cipher: none
db (current)
wal archive min/max (V009R001C001B0025): 000000010000000300000025/000000030000000300000028
full backup: 20260628-160652F
timestamp start/stop: 2026-06-28 16:06:52 / 2026-06-28 16:06:54
wal start/stop: 000000010000000300000025 / 000000010000000300000025
database size: 113.2MB, database backup size: 113.2MB
repo1: backup set size: 113.2MB, backup size: 113.2MB
想执行备份:
[kingbase@node1 ~]$ sys_rman --config=/backup/rman/sys_rman.conf --stanza=kingbase --type=incr backup
。。。
026-07-04 08:24:05.123 P00 INFO: backup stop archive = 00000003000000030000002A, lsn = 3/2A000128
2026-07-04 08:24:05.125 P00 INFO: check archive for segment(s) 00000003000000030000002A:00000003000000030000002A
2026-07-04 08:24:05.242 P00 INFO: new backup label = 20260628-160652F_20260704-082403I
2026-07-04 08:24:05.272 P00 INFO: incr backup size = 39.1MB, file total = 3230
2026-07-04 08:24:05.272 P00 INFO: backup command end: completed successfully (2205ms)
2026-07-04 08:24:05.272 P00 INFO: expire command begin 2.27: --no-archive-statistics --band-width=0 --config=/backup/rman/sys_rman.conf --exec-id=2640-a8ab3ae4 --log-level-console=info --log-level-file=info --log-path=/KingbaseES/V9/Server/log --process-max=2 --repo1-path=/backup/rman --repo1-retention-full=5 --stanza=kingbase
2026-07-04 08:24:05.274 P00 INFO: expire command end: completed successfully (2ms)
但每次执行,都要带上 --config=,感觉太长了,能否执行时,不带该参数,自动去读配置文件呢?
答案是可以的,通过 创建 /etc/sys_rman.conf文件实现。
在 root用户下创建连接文件:
[root@node1 ~]# ln -s /backup/rman/sys_rman.conf /etc/sys_rman.conf
[root@node1 ~]# ls -ltr /etc/sys_rman.conf
lrwxrwxrwx 1 root root 26 7月 4 08:19 /etc/sys_rman.conf -> /backup/rman/sys_rman.conf
再切换到 kingbase用户下,执行备份,恢复,查看备份
[kingbase@node1 ~]$ sys_rman --stanza=kingbase info
WARN: set process-max 4 is too large, auto set to CPU core count 2
stanza: kingbase
status: ok
cipher: none
db (current)
wal archive min/max (V009R001C001B0025): 000000010000000300000025/00000003000000030000002A
full backup: 20260628-160652F
timestamp start/stop: 2026-06-28 16:06:52 / 2026-06-28 16:06:54
wal start/stop: 000000010000000300000025 / 000000010000000300000025
database size: 113.2MB, database backup size: 113.2MB
repo1: backup set size: 113.2MB, backup size: 113.2MB
incr backup: 20260628-160652F_20260704-082403I
timestamp start/stop: 2026-07-04 08:24:03 / 2026-07-04 08:24:05
wal start/stop: 00000003000000030000002A / 00000003000000030000002A
database size: 97.3MB, database backup size: 39.1MB
repo1: backup set size: 97.3MB, backup size: 39.1MB
backup reference list: 20260628-160652F
已经不需要输入 --config=...sys_rman.conf ,就可以了
|