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

标题: 金仓备份如何实现 sys_rman 不输入 --config 也能执行 [打印本页]

作者: 郑全 时间: 6 天前
标题: 金仓备份如何实现 sys_rman 不输入 --config 也能执行

我们知道，如果想执行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 ，就可以了

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