GBase 8s
备份恢复
文章
精选

PSM多实例融合onbar恢复相关

发表于2025-11-26 10:44:2162次浏览2个评论

PSM多实例融合onbar恢复测试

测试期望: 在集群环境中,发生切换后,需要在新主上也备份逻辑日志。期望能融合在两端的备份,实现连续的逻辑恢复效果。

HAR集群信息:

  • HAC主:
[gbasedbt@dbhost01 tmp]$ onstat -g dis
Server        : gbase41
Server Number : 0
Server Type   : IDS
Server Status : Up
Server Version: GBase Database Server Version 12.10.FC4G1AEE
Shared Memory : 0x44000000
GBASEDBTDIR   : /opt/gbase
ONCONFIG      : /opt/gbase/etc/onconfig.gbase41
SQLHOSTS      : /opt/gbase/etc/sqlhosts.gbase41
Host          : dbhost01
[gbasedbt@dbhost01 tmp]$
  • HAC备:
[gbasedbt@dbhost02 0]$ onstat -g dis
Server        : gbase42
Server Number : 0
Server Type   : IDS
Server Status : Up
Server Version: GBase Database Server Version 12.10.FC4G1AEE
Shared Memory : 0x44000000
GBASEDBTDIR   : /opt/gbase
ONCONFIG      : /opt/gbase/etc/onconfig.gbase42
SQLHOSTS      : /opt/gbase/etc/sqlhosts.gbase42
Host          : dbhost02
[gbasedbt@dbhost02 0]$

配置PSM备份:

# vi $GBASEDBTDIR/etc/log_full.sh  
#BACKUP_CMD="ontape -a -d"
BACKUP_CMD="onbar -b -l"
mkdir -p /home/gbasedbt/bak/DBSPOOL
mkdir -p /home/gbasedbt/bak/LOGPOOL
onmode -wf BAR_BSALIB_PATH=$GBASEDBTDIR/lib/libbsapsm.so 
onmode -wf TAPEDEV=/home/gbasedbt/bak/DBSPOOL
onmode -wf LTAPEDEV=/home/gbasedbt/bak/LOGPOOL
onmode -wf ALARMPROGRAM=$GBASEDBTDIR/etc/log_full.sh
onpsm -D list
onpsm -D add /home/gbasedbt/bak/DBSPOOL -g DBSPOOL -p HIGHEST -t FILE 
onpsm -D add /home/gbasedbt/bak/LOGPOOL -g LOGPOOL -p HIGHEST -t FILE 
onpsm -D del $GBASEDBTDIR/backups -d -g DBSPOOL -y 
onpsm -D del $GBASEDBTDIR/backups -d -g LOGPOOL -y
onpsm -D list

使用onbar进行备份

onbar -b -L 0
onmode -l ; onmode -c
sleep 5;
onmode -l ; onmode -c

查看0备

0备日志:

2025-11-26 04:24:25 1900  1898 /opt/gbase/bin/onbar_d -b -L 0
 2025-11-26 04:24:26 1900  1898 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 04:24:27 1900  1898 Archive started on rootdbs, sbspace01, datadbs01, datadbs02, llogdbs, plogdbs (Requested Level 0).
 2025-11-26 04:24:27 1900  1898 (-43078) Open or close failed on file '/opt/gbase/etc/ixbar.0', errno = 2 .
No such file or directory
 2025-11-26 04:24:27 1900  1898 Begin level 0 backup rootdbs.
 2025-11-26 04:24:27 1900  1898 The PSM is ready.
 2025-11-26 04:24:27 1900  1898 __PSM__ session 9 opened.
 2025-11-26 04:24:27 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:27 1900  1898 Completed level 0 backup rootdbs (Storage Manager copy ID: 0 1).
 2025-11-26 04:24:28 1900  1898 __PSM__ session 9 closed
 2025-11-26 04:24:28 1903  1900 Process 1903  1900 successfully forked.
 2025-11-26 04:24:28 1905  1900 Process 1905  1900 successfully forked.
 2025-11-26 04:24:28 1904  1900 Process 1904  1900 successfully forked.
 2025-11-26 04:24:28 1906  1900 Process 1906  1900 successfully forked.
 2025-11-26 04:24:28 1907  1900 Process 1907  1900 successfully forked.
 2025-11-26 04:24:29 1907  1900 Begin level 0 backup plogdbs.
 2025-11-26 04:24:29 1907  1900 The PSM is ready.
 2025-11-26 04:24:29 1907  1900 __PSM__ session 10 opened.
 2025-11-26 04:24:29 1907  1900 Successfully connected to Storage Manager.
 2025-11-26 04:24:29 1905  1900 Begin level 0 backup datadbs02.
 2025-11-26 04:24:29 1906  1900 Begin level 0 backup llogdbs.
 2025-11-26 04:24:29 1905  1900 The PSM is ready.
 2025-11-26 04:24:29 1906  1900 The PSM is ready.
 2025-11-26 04:24:29 1905  1900 __PSM__ session 11 opened.
 2025-11-26 04:24:29 1905  1900 Successfully connected to Storage Manager.
 2025-11-26 04:24:29 1906  1900 __PSM__ session 12 opened.
 2025-11-26 04:24:29 1906  1900 Successfully connected to Storage Manager.
 2025-11-26 04:24:29 1903  1900 Begin level 0 backup sbspace01.
 2025-11-26 04:24:29 1903  1900 The PSM is ready.
 2025-11-26 04:24:29 1903  1900 __PSM__ session 13 opened.
 2025-11-26 04:24:29 1903  1900 Successfully connected to Storage Manager.
 2025-11-26 04:24:29 1904  1900 Begin level 0 backup datadbs01.
 2025-11-26 04:24:29 1904  1900 The PSM is ready.
 2025-11-26 04:24:29 1904  1900 __PSM__ session 14 opened.
 2025-11-26 04:24:29 1904  1900 Successfully connected to Storage Manager.
 2025-11-26 04:24:29 1905  1900 Completed level 0 backup datadbs02 (Storage Manager copy ID: 0 3).
 2025-11-26 04:24:29 1906  1900 Completed level 0 backup llogdbs (Storage Manager copy ID: 0 4).
 2025-11-26 04:24:29 1907  1900 Completed level 0 backup plogdbs (Storage Manager copy ID: 0 2).
 2025-11-26 04:24:29 1903  1900 Completed level 0 backup sbspace01 (Storage Manager copy ID: 0 5).
 2025-11-26 04:24:30 1904  1900 Completed level 0 backup datadbs01 (Storage Manager copy ID: 0 6).
 2025-11-26 04:24:30 1903  1900 __PSM__ session 13 closed
 2025-11-26 04:24:30 1903  1900 Process 1903  1900 completed.
 2025-11-26 04:24:31 1904  1900 __PSM__ session 14 closed
 2025-11-26 04:24:31 1904  1900 Process 1904  1900 completed.
 2025-11-26 04:24:31 1907  1900 __PSM__ session 10 closed
 2025-11-26 04:24:31 1907  1900 Process 1907  1900 completed.
 2025-11-26 04:24:31 1906  1900 __PSM__ session 12 closed
 2025-11-26 04:24:31 1906  1900 Process 1906  1900 completed.
 2025-11-26 04:24:31 1905  1900 __PSM__ session 11 closed
 2025-11-26 04:24:31 1905  1900 Process 1905  1900 completed.
 2025-11-26 04:24:31 1900  1898 Archive on rootdbs, sbspace01, datadbs01, datadbs02, llogdbs, plogdbs Completed (Requested Level 0).
 2025-11-26 04:24:31 1900  1898 Begin backup logical log 27.
 2025-11-26 04:24:31 1900  1898 The PSM is ready.
 2025-11-26 04:24:31 1900  1898 __PSM__ session 15 opened.
 2025-11-26 04:24:31 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:31 1900  1898 Completed backup logical log 27 (Storage Manager copy ID: 0 7).
 2025-11-26 04:24:31 1900  1898 __PSM__ session 15 closed
 2025-11-26 04:24:31 1900  1898 Begin backup of critical file '/opt/gbase/etc/ixbar.0'.
 2025-11-26 04:24:31 1900  1898 The PSM is ready.
 2025-11-26 04:24:31 1900  1898 __PSM__ session 16 opened.
 2025-11-26 04:24:31 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:31 1900  1898 Completed backup of critical file '/opt/gbase/etc/ixbar.0' (Storage Manager copy ID: 0 8).
 2025-11-26 04:24:31 1900  1898 __PSM__ session 16 closed
 2025-11-26 04:24:31 1900  1898 Begin backup of critical file '/opt/gbase/etc/oncfg_gbase41.0'.
 2025-11-26 04:24:31 1900  1898 The PSM is ready.
 2025-11-26 04:24:31 1900  1898 __PSM__ session 17 opened.
 2025-11-26 04:24:31 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:31 1900  1898 Completed backup of critical file '/opt/gbase/etc/oncfg_gbase41.0' (Storage Manager copy ID: 0 9).
 2025-11-26 04:24:31 1900  1898 __PSM__ session 17 closed
 2025-11-26 04:24:31 1900  1898 Begin backup of critical file '/opt/gbase/etc/onconfig.gbase41'.
 2025-11-26 04:24:31 1900  1898 The PSM is ready.
 2025-11-26 04:24:31 1900  1898 __PSM__ session 18 opened.
 2025-11-26 04:24:31 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:31 1900  1898 Completed backup of critical file '/opt/gbase/etc/onconfig.gbase41' (Storage Manager copy ID: 0 10).
 2025-11-26 04:24:31 1900  1898 __PSM__ session 18 closed
 2025-11-26 04:24:31 1900  1898 Begin backup of critical file '/opt/gbase/etc/sqlhosts.gbase41'.
 2025-11-26 04:24:31 1900  1898 The PSM is ready.
 2025-11-26 04:24:31 1900  1898 __PSM__ session 19 opened.
 2025-11-26 04:24:31 1900  1898 Successfully connected to Storage Manager.
 2025-11-26 04:24:31 1900  1898 Completed backup of critical file '/opt/gbase/etc/sqlhosts.gbase41' (Storage Manager copy ID: 0 11).
 2025-11-26 04:24:31 1900  1898 __PSM__ session 19 closed
 2025-11-26 04:24:31 1900  1898 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)

0备结果:

[gbasedbt@dbhost01 bak]$ tree DBSPOOL/
DBSPOOL/
└── gbase41
    ├── critical_files
    │   ├── ixbar
    │   │   └── gbase41.1.1
    │   ├── oncfg
    │   │   └── gbase41.1.1
    │   ├── onconfig
    │   │   └── gbase41.1.1
    │   └── sqlhosts
    │       └── gbase41.1.1
    ├── datadbs01
    │   └── 0
    │       └── gbase41.1.1
    ├── datadbs02
    │   └── 0
    │       └── gbase41.1.1
    ├── llogdbs
    │   └── 0
    │       └── gbase41.1.1
    ├── plogdbs
    │   └── 0
    │       └── gbase41.1.1
    ├── rootdbs
    │   └── 0
    │       └── gbase41.1.1
    └── sbspace01
        └── 0
            └── gbase41.1.1

19 directories, 10 files
[gbasedbt@dbhost01 bak]$
[gbasedbt@dbhost01 bak]$ tree LOGPOOL/
LOGPOOL/
└── gbase41
    └── 0
        └── 27
            └── gbase41.1.1

4 directories, 1 file
[gbasedbt@dbhost01 bak]$

查看逻辑日志备份

逻辑日志备份日志:

 2025-11-26 04:51:41 2072  2070 /opt/gbase/bin/onbar_d -b -l
 2025-11-26 04:51:41 2072  2070 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 04:51:41 2072  2070 Begin backup logical log 28.
 2025-11-26 04:51:41 2072  2070 The PSM is ready.
 2025-11-26 04:51:41 2072  2070 __PSM__ session 20 opened.
 2025-11-26 04:51:41 2072  2070 Successfully connected to Storage Manager.
 2025-11-26 04:51:41 2072  2070 Completed backup logical log 28 (Storage Manager copy ID: 0 12).
 2025-11-26 04:51:41 2072  2070 Begin backup logical log 29.
 2025-11-26 04:51:41 2072  2070 Completed backup logical log 29 (Storage Manager copy ID: 0 13).
 2025-11-26 04:51:41 2072  2070 __PSM__ session 20 closed
 2025-11-26 04:51:41 2072  2070 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)
 2025-11-26 04:52:32 2089  2087 /opt/gbase/bin/onbar_d -b -l
 2025-11-26 04:52:32 2089  2087 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 04:52:32 2089  2087 Begin backup logical log 30.
 2025-11-26 04:52:32 2089  2087 The PSM is ready.
 2025-11-26 04:52:32 2089  2087 __PSM__ session 21 opened.
 2025-11-26 04:52:32 2089  2087 Successfully connected to Storage Manager.
 2025-11-26 04:52:33 2089  2087 Completed backup logical log 30 (Storage Manager copy ID: 0 14).
 2025-11-26 04:52:33 2089  2087 __PSM__ session 21 closed
 2025-11-26 04:52:33 2089  2087 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)
 2025-11-26 04:52:40 2103  2101 /opt/gbase/bin/onbar_d -b -l
 2025-11-26 04:52:40 2103  2101 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 04:52:40 2103  2101 Begin backup logical log 31.
 2025-11-26 04:52:40 2103  2101 The PSM is ready.
 2025-11-26 04:52:40 2103  2101 __PSM__ session 22 opened.
 2025-11-26 04:52:40 2103  2101 Successfully connected to Storage Manager.
 2025-11-26 04:52:40 2103  2101 Completed backup logical log 31 (Storage Manager copy ID: 0 15).
 2025-11-26 04:52:40 2103  2101 __PSM__ session 22 closed
 2025-11-26 04:52:40 2103  2101 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)

逻辑日志备份结果:

[gbasedbt@dbhost01 bak]$ tree LOGPOOL/
LOGPOOL/
└── gbase41
    └── 0
        ├── 27
        │   └── gbase41.1.1
        ├── 28
        │   └── gbase41.1.1
        ├── 29
        │   └── gbase41.1.1
        ├── 30
        │   └── gbase41.1.1
        └── 31
            └── gbase41.1.1

8 directories, 5 files
[gbasedbt@dbhost01 bak]$

查看此时的ixbar文件:

[gbasedbt@dbhost01 bak]$ cat -A DBSPOOL/gbase41/critical_files/ixbar/gbase41.1.1
CAGO^B^@^@^@^H^@^@^@^@^@^@^@CF^@^@^A^@^@^@^A^@^@^@M-^?M-^?M-^?M-^?M-^_^D^@^@^@^@^@^@^A^@^@^@DBSPOOL^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^B^@^@^@^?^P&i2 0 8 1:^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^I^@^@^@^^^@^@^@/gbase41^@/gbase41/critical_files/ixbar^@gbase41            rootdbs            R  0 1     0 0          1          2025-11-26 04:24:26 1     27    537083      1     0     - - 27    1764102266  1764099160  1    $
gbase41            sbspace01          ND 0 4     0 0          5          2025-11-26 04:24:28 1     27    537281      4     0     - - 27    1764102268  1764099160  5    $
gbase41            datadbs01          ND 0 6     0 0          6          2025-11-26 04:24:28 1     27    537281      6     0     - - 27    1764102268  1764099160  6    $
gbase41            plogdbs            CD 0 5     0 0          2          2025-11-26 04:24:28 1     27    537281      5     0     - - 27    1764102268  1764099160  2    $
gbase41            llogdbs            CD 0 3     0 0          4          2025-11-26 04:24:28 1     27    537281      3     0     - - 27    1764102268  1764099160  4    $
gbase41            datadbs02          ND 0 2     0 0          3          2025-11-26 04:24:28 1     27    537281      2     0     - - 27    1764102268  1764099160  3    $
gbase41            27                 L  0 7     0 0          7          2025-11-26 04:24:31 1     0     0           7     0     - - 27    1764102271  0           0    $
[gbasedbt@dbhost01 bak]$
[gbasedbt@dbhost01 bak]$ cat /opt/gbase/etc/ixbar.0
gbase41            rootdbs            R  0 1     0 0          1          2025-11-26 04:24:26 1     27    537083      1     0     - - 27    1764102266  1764099160  1
gbase41            sbspace01          ND 0 4     0 0          5          2025-11-26 04:24:28 1     27    537281      4     0     - - 27    1764102268  1764099160  5
gbase41            datadbs01          ND 0 6     0 0          6          2025-11-26 04:24:28 1     27    537281      6     0     - - 27    1764102268  1764099160  6
gbase41            plogdbs            CD 0 5     0 0          2          2025-11-26 04:24:28 1     27    537281      5     0     - - 27    1764102268  1764099160  2
gbase41            llogdbs            CD 0 3     0 0          4          2025-11-26 04:24:28 1     27    537281      3     0     - - 27    1764102268  1764099160  4
gbase41            datadbs02          ND 0 2     0 0          3          2025-11-26 04:24:28 1     27    537281      2     0     - - 27    1764102268  1764099160  3
gbase41            27                 L  0 7     0 0          7          2025-11-26 04:24:31 1     0     0           7     0     - - 27    1764102271  0           0
gbase41            28                 L  0 8     0 0          12         2025-11-26 04:51:41 1     0     0           8     0     - - 28    1764102427  1764102271  0
gbase41            29                 L  0 9     0 0          13         2025-11-26 04:51:41 1     0     0           9     0     - - 29    1764102435  1764102427  0
gbase41            30                 L  0 10    0 0          14         2025-11-26 04:52:32 1     0     0           10    0     - - 30    1764103951  1764102435  0
gbase41            31                 L  0 11    0 0          15         2025-11-26 04:52:40 1     0     0           11    0     - - 31    1764103959  1764103951  0
[gbasedbt@dbhost01 bak]$

此时关闭HA主机,把备机升为主,并切换两个逻辑日志:

[gbasedbt@dbhost02 ~]$ onmode -d make primary gbase42
onmode -l ; onmode -c
sleep 5;
onmode -l ; onmode -c
 2025-11-26 05:23:02 1991  1989 /opt/gbase/bin/onbar_d -b -l
 2025-11-26 05:23:02 1991  1989 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 05:23:02 1991  1989 Begin backup logical log 32.
 2025-11-26 05:23:02 1991  1989 The PSM is ready.
 2025-11-26 05:23:02 1991  1989 __PSM__ session 17 opened.
 2025-11-26 05:23:02 1991  1989 Successfully connected to Storage Manager.
 2025-11-26 05:23:03 1991  1989 Completed backup logical log 32 (Storage Manager copy ID: 0 1).
 2025-11-26 05:23:03 1991  1989 __PSM__ session 17 closed
 2025-11-26 05:23:03 1991  1989 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)
 2025-11-26 05:23:10 2005  2003 /opt/gbase/bin/onbar_d -b -l
 2025-11-26 05:23:10 2005  2003 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 05:23:10 2005  2003 Begin backup logical log 33.
 2025-11-26 05:23:10 2005  2003 The PSM is ready.
 2025-11-26 05:23:10 2005  2003 __PSM__ session 18 opened.
 2025-11-26 05:23:10 2005  2003 Successfully connected to Storage Manager.
 2025-11-26 05:23:10 2005  2003 Completed backup logical log 33 (Storage Manager copy ID: 0 2).
 2025-11-26 05:23:10 2005  2003 __PSM__ session 18 closed
 2025-11-26 05:23:10 2005  2003 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)
[gbasedbt@dbhost02 ~]$
[gbasedbt@dbhost02 bak]$ tree LOGPOOL/gbase42/0/3
LOGPOOL/gbase42/0/3  [error opening dir]

0 directories, 0 files
[gbasedbt@dbhost02 bak]$ tree LOGPOOL/*/*/*
LOGPOOL/gbase42/0/32
└── gbase42.1.1
LOGPOOL/gbase42/0/33
└── gbase42.1.1

2 directories, 2 files
[gbasedbt@dbhost02 bak]$
[gbasedbt@dbhost02 bak]$ cat /opt/gbase/etc/ixbar.0
gbase42            32                 L  0 12    0 0          1          2025-11-26 05:23:02 1     0     0           12    0     - - 32    1764105781  1764103959  0
gbase42            33                 L  0 13    0 0          2          2025-11-26 05:23:10 1     0     0           13    0     - - 33    1764105789  1764105781  0
[gbasedbt@dbhost02 bak]$
onmode -ky

现在我们看看怎么把这两个逻辑日拷贝到主机去融合:

复制添加了两行并修改了,第1列和第8列:

[gbasedbt@dbhost01 etc]$ cp ixbar.0 ixbar.0_end31
[gbasedbt@dbhost01 etc]$ vi ixbar.0
[gbasedbt@dbhost01 etc]$ cat ixbar.0
gbase41            rootdbs            R  0 1     0 0          1          2025-11-26 04:24:26 1     27    537083      1     0     - - 27    1764102266  1764099160  1
gbase41            sbspace01          ND 0 4     0 0          5          2025-11-26 04:24:28 1     27    537281      4     0     - - 27    1764102268  1764099160  5
gbase41            datadbs01          ND 0 6     0 0          6          2025-11-26 04:24:28 1     27    537281      6     0     - - 27    1764102268  1764099160  6
gbase41            plogdbs            CD 0 5     0 0          2          2025-11-26 04:24:28 1     27    537281      5     0     - - 27    1764102268  1764099160  2
gbase41            llogdbs            CD 0 3     0 0          4          2025-11-26 04:24:28 1     27    537281      3     0     - - 27    1764102268  1764099160  4
gbase41            datadbs02          ND 0 2     0 0          3          2025-11-26 04:24:28 1     27    537281      2     0     - - 27    1764102268  1764099160  3
gbase41            27                 L  0 7     0 0          7          2025-11-26 04:24:31 1     0     0           7     0     - - 27    1764102271  0           0
gbase41            28                 L  0 8     0 0          12         2025-11-26 04:51:41 1     0     0           8     0     - - 28    1764102427  1764102271  0
gbase41            29                 L  0 9     0 0          13         2025-11-26 04:51:41 1     0     0           9     0     - - 29    1764102435  1764102427  0
gbase41            30                 L  0 10    0 0          14         2025-11-26 04:52:32 1     0     0           10    0     - - 30    1764103951  1764102435  0
gbase41            31                 L  0 11    0 0          15         2025-11-26 04:52:40 1     0     0           11    0     - - 31    1764103959  1764103951  0
gbase41            32                 L  0 12    0 0          16         2025-11-26 05:23:02 1     0     0           12    0     - - 32    1764105781  1764103959  0
gbase41            33                 L  0 13    0 0          17         2025-11-26 05:23:10 1     0     0           13    0     - - 33    1764105789  1764105781  0
[gbasedbt@dbhost01 etc]$

复制两个日志文件:

[gbasedbt@dbhost02 0]$ pwd
/home/gbasedbt/bak/LOGPOOL/gbase42/0
[gbasedbt@dbhost02 0]$ scp -rp 32/ dbhost01:/home/gbasedbt/bak/LOGPOOL/gbase41/0/
[gbasedbt@dbhost02 0]$ scp -rp 33/ dbhost01:/home/gbasedbt/bak/LOGPOOL/gbase41/0/

dbhosts01上重命名两个文件

[gbasedbt@dbhost01 0]$ mv 32/gbase42.1.1 32/gbase41.1.1
[gbasedbt@dbhost01 0]$ mv 33/gbase42.1.1 33/gbase41.1.1
[gbasedbt@dbhost01 0]$

dbhosts01上执行恢复

[gbasedbt@dbhost01 0]$ cd /opt/gbase/tmp/
[gbasedbt@dbhost01 tmp]$ onbar -r -p
attn: Ignoring unknown or deprecated config parameter (STARTHASH_TEMP_OPT)
(-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
[gbasedbt@dbhost01 tmp]$
[gbasedbt@dbhost01 tmp]$ onbar -r -l
[gbasedbt@dbhost01 tmp]$
[gbasedbt@dbhost01 ~]$ tail -f /opt/gbase/tmp/bar_act.log
 2025-11-26 05:31:33 2595  2444 Completed cold level 0 restore llogdbs.
 2025-11-26 05:31:33 2597  2444 __PSM__ session 29 closed
 2025-11-26 05:31:33 2597  2444 Process 2597  2444 completed.
 2025-11-26 05:31:34 2595  2444 __PSM__ session 25 closed
 2025-11-26 05:31:34 2595  2444 Process 2595  2444 completed.
 2025-11-26 05:31:34 2444  2442 (-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
 2025-11-26 05:31:34 2444  2442 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)


 2025-11-26 05:32:27 2669  2667 /opt/gbase/bin/onbar_d -r -l
 2025-11-26 05:32:27 2669  2667 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 05:32:27 2669  2667 The PSM is ready.
 2025-11-26 05:32:27 2669  2667 __PSM__ session 30 opened.
 2025-11-26 05:32:27 2669  2667 Successfully connected to Storage Manager.
 2025-11-26 05:32:27 2669  2667 Begin restore logical log 27 (Storage Manager copy ID: 0 7).
 2025-11-26 05:32:27 2669  2667 Completed restore logical log 27.
 2025-11-26 05:32:27 2669  2667 Begin restore logical log 28 (Storage Manager copy ID: 0 12).
 2025-11-26 05:32:27 2669  2667 Completed restore logical log 28.
 2025-11-26 05:32:27 2669  2667 Begin restore logical log 29 (Storage Manager copy ID: 0 13).
 2025-11-26 05:32:27 2669  2667 Completed restore logical log 29.
 2025-11-26 05:32:27 2669  2667 Begin restore logical log 30 (Storage Manager copy ID: 0 14).
 2025-11-26 05:32:27 2669  2667 Completed restore logical log 30.
 2025-11-26 05:32:27 2669  2667 Begin restore logical log 31 (Storage Manager copy ID: 0 15).
 2025-11-26 05:32:27 2669  2667 Completed restore logical log 31.
 2025-11-26 05:32:27 2669  2667 XBSA Error: (BSAGetObject) Backup object does not exist in Storage Manager.
 2025-11-26 05:32:27 2669  2667 Object information: bar_objdesc
     obj_id 0 obj_name '32' obj_type 'L' act_id 0 act_type 2 act_status 0
     act_start '2025-11-26 05:32:27'  act_end '2025-11-26 05:23:02'
     ins_time 0 rsam_time 0 seal_time 1764105781 prev_seal_time 1764103959 level 0 copyid hi:lo 0:16 req_act_id 12
     logstream 0 est_pages hi:lo 0:0 first_log 0 chpt_log 32 last_log 0
     partial_flag 0 do_query 0 ins_sm_id 0 ins_sm_name ''
     ins_verify 0 ins_verify_date '' restore order 0:0
     objInfo ''
     retry 0 in_catalog 1 in_bootfile 0 child_pid 0 child_state 0
     bkup_host '' backup_order 0
 2025-11-26 05:32:27 2669  2667 (-43258) ON-Bar could not get logical log 32 from the storage manager.
 2025-11-26 05:32:31 2669  2667 (-43168) ON-Bar suspended the logical restore on log 32 (expected to
restore to 2147483647).
 2025-11-26 05:32:31 2669  2667 __PSM__ session 30 closed
 2025-11-26 05:32:36 2669  2667 /opt/gbase/bin/onbar_d complete, returning 100 (0x64)
  • 注明1: 新拷贝过来的两个日志,不能恢复,还需要看看哪里漏改了。。[捂脸]
[gbasedbt@dbhost01 tmp]$ onpsm -O list

__PSM__ Object List

Object ID            Date Created         Size (MB) Logical path (name.version)
1                    2025-11-26 04:24:27       24.3 /gbase41/rootdbs/0/gbase41.1
2                    2025-11-26 04:24:29        0.1 /gbase41/plogdbs/0/gbase41.1
3                    2025-11-26 04:24:29        0.1 /gbase41/datadbs02/0/gbase41.1
4                    2025-11-26 04:24:29        0.1 /gbase41/llogdbs/0/gbase41.1
5                    2025-11-26 04:24:29        0.1 /gbase41/sbspace01/0/gbase41.1
6                    2025-11-26 04:24:29        9.0 /gbase41/datadbs01/0/gbase41.1
7                    2025-11-26 04:24:31        0.8 /gbase41/0/27/gbase41.1
8                    2025-11-26 04:24:31        0.0 /gbase41/critical_files/ixbar/gbase41.1
9                    2025-11-26 04:24:31        0.0 /gbase41/critical_files/oncfg/gbase41.1
10                   2025-11-26 04:24:31        0.1 /gbase41/critical_files/onconfig/gbase41.1
11                   2025-11-26 04:24:31        0.0 /gbase41/critical_files/sqlhosts/gbase41.1
12                   2025-11-26 04:51:41        0.0 /gbase41/0/28/gbase41.1
13                   2025-11-26 04:51:41        0.0 /gbase41/0/29/gbase41.1
14                   2025-11-26 04:52:32        0.1 /gbase41/0/30/gbase41.1
15                   2025-11-26 04:52:40        0.0 /gbase41/0/31/gbase41.1
[gbasedbt@dbhost01 tmp]$
  • 注明2: 这里是有问题的,后面两个拷贝过来的日32和33在psm里面认不到。。[捂脸]
[gbasedbt@dbhost02 0]$  onpsm -O list

__PSM__ Object List

Object ID            Date Created         Size (MB) Logical path (name.version)
1                    2025-11-26 05:23:02        0.2 /gbase42/0/32/gbase42.1
2                    2025-11-26 05:23:10        0.0 /gbase42/0/33/gbase42.1
[gbasedbt@dbhost02 0]$
  • 注明3:这是在备机(新主机)上备份的2个逻辑日志的PSM注册记录。

查阅文档:

测试: Example 4: Exporting a backup from one server and importing it into another server

添加 EXTPOOL

[gbasedbt@dbhost02 ~]$ mkdir -p /home/gbasedbt/bak/psm_exportdir
[gbasedbt@dbhost02 ~]$ onpsm -D add /home/gbasedbt/bak/psm_exportdir -g EXTPOOL -t FILE
[gbasedbt@dbhost02 ~]$ onpsm -D list
__PSM__ Device List
Type   Prio     Block/Size (MB)  Pool Name     Device Name
FILE   HIGHEST      --/--        DBSPOOL       /home/gbasedbt/bak/DBSPOOL
FILE   HIGHEST      --/--        LOGPOOL       /home/gbasedbt/bak/LOGPOOL
FILE   HIGH         --/--        EXTPOOL       /home/gbasedbt/bak/psm_exportdir
[gbasedbt@dbhost02 ~]$

执行0备,和切换几个逻辑日志,后可以看到结果:

[gbasedbt@dbhost02 ~]$ onpsm -O list

__PSM__ Object List

Object ID            Date Created         Size (MB) Logical path (name.version)
1                    2025-11-26 05:23:02        0.2 /gbase42/0/32/gbase42.1
2                    2025-11-26 05:23:10        0.0 /gbase42/0/33/gbase42.1
3                    2025-11-26 07:51:12       24.4 /gbase42/rootdbs/0/gbase42.1
4                    2025-11-26 07:51:15        9.0 /gbase42/datadbs01/0/gbase42.1
5                    2025-11-26 07:51:15        0.1 /gbase42/datadbs02/0/gbase42.1
6                    2025-11-26 07:51:16        0.1 /gbase42/plogdbs/0/gbase42.1
7                    2025-11-26 07:51:16        0.1 /gbase42/sbspace01/0/gbase42.1
8                    2025-11-26 07:51:17        0.1 /gbase42/llogdbs/0/gbase42.1
9                    2025-11-26 07:51:17        0.4 /gbase42/0/34/gbase42.1
10                   2025-11-26 07:51:17        0.0 /gbase42/critical_files/ixbar/gbase42.1
11                   2025-11-26 07:51:17        0.0 /gbase42/critical_files/oncfg/gbase42.1
12                   2025-11-26 07:51:17        0.1 /gbase42/critical_files/onconfig/gbase42.1
13                   2025-11-26 07:51:17        0.0 /gbase42/critical_files/sqlhosts/gbase42.1
14                   2025-11-26 07:53:27        0.0 /gbase42/0/35/gbase42.1
15                   2025-11-26 08:00:24        0.0 /gbase42/0/36/gbase42.1
16                   2025-11-26 08:18:00        0.0 /gbase42/0/37/gbase42.1
[gbasedbt@dbhost02 ~]$

把这些备份导出到 EXTPOOL

[gbasedbt@dbhost02 ~]$ onsmsync -E -p host02_37 -l 37
[gbasedbt@dbhost02 ~]$ tree /home/gbasedbt/bak/psm_exportdir/host02_37/
/home/gbasedbt/bak/psm_exportdir/host02_37/
├── export.bom
└── gbase42
    ├── 0
    │   ├── 34
    │   ├── 35
    │   ├── 36
    │   └── 37
    ├── critical_files
    │   ├── ixbar
    │   ├── oncfg
    │   ├── onconfig
    │   └── sqlhosts
    ├── datadbs01
    │   └── 0
    ├── datadbs02
    │   └── 0
    ├── llogdbs
    │   └── 0
    ├── plogdbs
    │   └── 0
    ├── rootdbs
    │   └── 0
    └── sbspace01
        └── 0

10 directories, 15 files
[gbasedbt@dbhost02 ~]$

复制 /home/gbasedbt/bak/psm_exportdir/host02_37/ 目录到hosts01主机

[gbasedbt@dbhost02 ~]$ scp -rp /home/gbasedbt/bak/psm_exportdir/host02_37/ dbhost01:/home/gbasedbt/bak/psm_exportdir/

查看hosts01当前的PSM备份记录

[gbasedbt@dbhost01 ~]$ onpsm -O list

__PSM__ Object List

Object ID            Date Created         Size (MB) Logical path (name.version)
1                    2025-11-26 04:24:27       24.3 /gbase41/rootdbs/0/gbase41.1
2                    2025-11-26 04:24:29        0.1 /gbase41/plogdbs/0/gbase41.1
3                    2025-11-26 04:24:29        0.1 /gbase41/datadbs02/0/gbase41.1
4                    2025-11-26 04:24:29        0.1 /gbase41/llogdbs/0/gbase41.1
5                    2025-11-26 04:24:29        0.1 /gbase41/sbspace01/0/gbase41.1
6                    2025-11-26 04:24:29        9.0 /gbase41/datadbs01/0/gbase41.1
7                    2025-11-26 04:24:31        0.8 /gbase41/0/27/gbase41.1
8                    2025-11-26 04:24:31        0.0 /gbase41/critical_files/ixbar/gbase41.1
9                    2025-11-26 04:24:31        0.0 /gbase41/critical_files/oncfg/gbase41.1
10                   2025-11-26 04:24:31        0.1 /gbase41/critical_files/onconfig/gbase41.1
11                   2025-11-26 04:24:31        0.0 /gbase41/critical_files/sqlhosts/gbase41.1
12                   2025-11-26 04:51:41        0.0 /gbase41/0/28/gbase41.1
13                   2025-11-26 04:51:41        0.0 /gbase41/0/29/gbase41.1
14                   2025-11-26 04:52:32        0.1 /gbase41/0/30/gbase41.1
15                   2025-11-26 04:52:40        0.0 /gbase41/0/31/gbase41.1
[gbasedbt@dbhost01 ~]$

hosts01也要添加 EXTPOOL

[gbasedbt@dbhost01 ~]$ onpsm -D add /home/gbasedbt/bak/psm_exportdir -g EXTPOOL -t FILE
[gbasedbt@dbhost01 ~]$ onpsm -D list

__PSM__ Device List

Type   Prio     Block/Size (MB)  Pool Name     Device Name
FILE   HIGHEST      --/--        DBSPOOL       /home/gbasedbt/bak/DBSPOOL

FILE   HIGHEST      --/--        LOGPOOL       /home/gbasedbt/bak/LOGPOOL

FILE   HIGH         --/--        EXTPOOL       /home/gbasedbt/bak/psm_exportdir


[gbasedbt@dbhost01 ~]$ onstat -
shared memory not initialized for GBASEDBTSERVER 'gbase41'
[gbasedbt@dbhost01 ~]$

hosts01还需要要删除原先的备份对象

  • 不删会报错
 2025-11-26 08:12:10 3387  3067 onsmsync -I -p host02_37
 2025-11-26 08:12:10 3387  3067 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 08:12:10 3387  3067 The PSM is ready.
 2025-11-26 08:12:10 3387  3067 __PSM__ session 60 opened.
 2025-11-26 08:12:10 3387  3067 Successfully connected to Storage Manager.
 2025-11-26 08:12:10 3387  3067 (-43050) Copy of old emergency bootfile saved in /opt/gbase/etc/ixbar.0.20251126.081210 .
 2025-11-26 08:12:10 3387  3067 Importing PSM object rootdbs:/home/gbasedbt/bak/psm_exportdir/host02_37/gbase42/rootdbs/0
 2025-11-26 08:12:10 3387  3067 XBSA Error: (BSACreateObject) That object already exists.
 2025-11-26 08:12:10 3387  3067 __PSM__ session 60 closed
 2025-11-26 08:12:10 3387  3067 onsmsync complete, returning 13 (0x0d)
  • 删除hosts01上原有的对象
[gbasedbt@dbhost01 ~]$ for i in {1..15} ; do echo onpsm -O del -o $i -y |sh; done
[gbasedbt@dbhost01 ~]$ onpsm -O list
[gbasedbt@dbhost01 ~]$

导入hosts02的备份记录:

[gbasedbt@dbhost01 ~]$ onsmsync -I -p host02_37
#可以看到,onsmsync -I 自动导入了新hosts02的备份对象
[gbasedbt@dbhost01 ~]$ onpsm -O list

__PSM__ Object List

Object ID            Date Created         Size (MB) Logical path (name.version)
3                    2025-11-26 08:36:32       24.4 /gbase42/rootdbs/0/gbase42.1
4                    2025-11-26 08:36:33        9.0 /gbase42/datadbs01/0/gbase42.1
5                    2025-11-26 08:36:33        0.1 /gbase42/datadbs02/0/gbase42.1
6                    2025-11-26 08:36:33        0.1 /gbase42/plogdbs/0/gbase42.1
7                    2025-11-26 08:36:33        0.1 /gbase42/sbspace01/0/gbase42.1
8                    2025-11-26 08:36:33        0.1 /gbase42/llogdbs/0/gbase42.1
9                    2025-11-26 08:36:33        0.4 /gbase42/0/34/gbase42.1
14                   2025-11-26 08:36:33        0.0 /gbase42/0/35/gbase42.1
15                   2025-11-26 08:36:33        0.0 /gbase42/0/36/gbase42.1
16                   2025-11-26 08:36:33        0.0 /gbase42/0/37/gbase42.1
17                   2025-11-26 08:36:33        0.1 /gbase42/critical_files/onconfig/gbase42.1
18                   2025-11-26 08:36:33        0.0 /gbase42/critical_files/sqlhosts/gbase42.1
19                   2025-11-26 08:36:33        0.0 /gbase42/critical_files/oncfg/gbase42.1
20                   2025-11-26 08:36:33        0.0 /gbase42/critical_files/ixbar/gbase42.1
[gbasedbt@dbhost01 ~]$
#可以看到,onsmsync -I 自动修改了好了ixbar文件
[gbasedbt@dbhost01 ~]$ ls -lrt /opt/gbase/etc/ixbar.0*
-rw-r----- 1 gbasedbt gbasedbt 1859 Nov 26 05:18 /opt/gbase/etc/ixbar.0_end31
-rw-r----- 1 gbasedbt gbasedbt 2197 Nov 26 08:12 /opt/gbase/etc/ixbar.0.20251126.081210
-rw-r----- 1 gbasedbt gbasedbt    0 Nov 26 08:30 /opt/gbase/etc/ixbar.0.20251126.083044
-rw-r----- 1 gbasedbt gbasedbt    0 Nov 26 08:36 /opt/gbase/etc/ixbar.0.20251126.083632
-rw-r----- 1 gbasedbt gbasedbt 1690 Nov 26 08:36 /opt/gbase/etc/ixbar.0
[gbasedbt@dbhost01 ~]$
[gbasedbt@dbhost01 ~]$ cat /opt/gbase/etc/ixbar.0
gbase41            rootdbs            R  0 14    0 0          3          2025-11-26 07:51:11 1     34    551258      14    0     - - 34    1764114671  1764105789  21
gbase41            plogdbs            CD 0 16    0 0          6          2025-11-26 07:51:14 1     34    551543      16    0     - - 34    1764114674  1764105789  22
gbase41            datadbs01          ND 0 18    0 0          4          2025-11-26 07:51:14 1     34    551526      18    0     - - 34    1764114674  1764105789  23
gbase41            datadbs02          ND 0 15    0 0          5          2025-11-26 07:51:14 1     34    551543      15    0     - - 34    1764114674  1764105789  24
gbase41            sbspace01          ND 0 17    0 0          7          2025-11-26 07:51:14 1     34    551543      17    0     - - 34    1764114674  1764105789  25
gbase41            llogdbs            CD 0 19    0 0          8          2025-11-26 07:51:14 1     34    551543      19    0     - - 34    1764114674  1764105789  26
gbase41            34                 L  0 20    0 0          9          2025-11-26 07:51:17 1     0     0           20    0     - - 34    1764114676  1764105789  0
gbase41            35                 L  0 21    0 0          14         2025-11-26 07:53:27 1     0     0           21    0     - - 35    1764114806  1764114676  0
gbase41            36                 L  0 22    0 0          15         2025-11-26 08:00:24 1     0     0           22    0     - - 36    1764115222  1764114806  0
gbase41            37                 L  0 23    0 0          16         2025-11-26 08:18:00 1     0     0           23    0     - - 37    1764116278  1764115222  0
[gbasedbt@dbhost01 ~]$

使用onbar恢复hosts02的备份记录:

[gbasedbt@dbhost01 ~]$ onbar -r -p
attn: Ignoring unknown or deprecated config parameter (STARTHASH_TEMP_OPT)

(-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
[gbasedbt@dbhost01 ~]$
[gbasedbt@dbhost01 ~]$ onbar -r -l
[gbasedbt@dbhost01 ~]$
 #物理恢复正常
 2025-11-26 08:40:20 3563  3561 /opt/gbase/bin/onbar_d -r -p
 2025-11-26 08:40:20 3563  3561 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 08:40:20 3563  3561 The PSM is ready.
 2025-11-26 08:40:20 3563  3561 __PSM__ session 133 opened.
 2025-11-26 08:40:20 3563  3561 Successfully connected to Storage Manager.
 2025-11-26 08:40:20 3563  3561 Begin reserved pages read (level 0 of rootdbs, Storage Manager copy ID: 0 3).
 2025-11-26 08:40:20 3563  3561 Completed reserved pages read (level 0 of rootdbs).
 2025-11-26 08:40:20 3563  3561 __PSM__ session 133 closed
 2025-11-26 08:40:20 3563  3561 The PSM is ready.
 2025-11-26 08:40:20 3563  3561 __PSM__ session 134 opened.
 2025-11-26 08:40:20 3563  3561 Successfully connected to Storage Manager.
 2025-11-26 08:40:20 3563  3561 Begin cold level 0 restore rootdbs (Storage Manager copy ID: 0 3).
 2025-11-26 08:40:33 3563  3561 Completed cold level 0 restore rootdbs.
 2025-11-26 08:40:33 3563  3561 __PSM__ session 134 closed
 2025-11-26 08:40:33 3587  3563 Process 3587  3563 successfully forked.
 2025-11-26 08:40:33 3587  3563 The PSM is ready.
 2025-11-26 08:40:33 3587  3563 __PSM__ session 135 opened.
 2025-11-26 08:40:33 3587  3563 Successfully connected to Storage Manager.
 2025-11-26 08:40:33 3590  3563 Process 3590  3563 successfully forked.
 2025-11-26 08:40:33 3587  3563 Begin cold level 0 restore datadbs01 (Storage Manager copy ID: 0 4).
 2025-11-26 08:40:33 3586  3563 Process 3586  3563 successfully forked.
 2025-11-26 08:40:33 3590  3563 The PSM is ready.
 2025-11-26 08:40:33 3590  3563 __PSM__ session 136 opened.
 2025-11-26 08:40:33 3590  3563 Successfully connected to Storage Manager.
 2025-11-26 08:40:33 3590  3563 Begin cold level 0 restore llogdbs (Storage Manager copy ID: 0 8).
 2025-11-26 08:40:33 3586  3563 The PSM is ready.
 2025-11-26 08:40:33 3586  3563 __PSM__ session 137 opened.
 2025-11-26 08:40:33 3586  3563 Successfully connected to Storage Manager.
 2025-11-26 08:40:33 3586  3563 Begin cold level 0 restore plogdbs (Storage Manager copy ID: 0 6).
 2025-11-26 08:40:33 3589  3563 Process 3589  3563 successfully forked.
 2025-11-26 08:40:33 3588  3563 Process 3588  3563 successfully forked.
 2025-11-26 08:40:33 3589  3563 The PSM is ready.
 2025-11-26 08:40:33 3589  3563 __PSM__ session 138 opened.
 2025-11-26 08:40:33 3589  3563 Successfully connected to Storage Manager.
 2025-11-26 08:40:33 3589  3563 Begin cold level 0 restore sbspace01 (Storage Manager copy ID: 0 7).
 2025-11-26 08:40:33 3588  3563 The PSM is ready.
 2025-11-26 08:40:33 3588  3563 __PSM__ session 139 opened.
 2025-11-26 08:40:33 3588  3563 Successfully connected to Storage Manager.
 2025-11-26 08:40:33 3588  3563 Begin cold level 0 restore datadbs02 (Storage Manager copy ID: 0 5).
 2025-11-26 08:40:34 3589  3563 Completed cold level 0 restore sbspace01.
 2025-11-26 08:40:34 3587  3563 Completed cold level 0 restore datadbs01.
 2025-11-26 08:40:34 3589  3563 __PSM__ session 138 closed
 2025-11-26 08:40:34 3589  3563 Process 3589  3563 completed.
 2025-11-26 08:40:34 3590  3563 Completed cold level 0 restore llogdbs.
 2025-11-26 08:40:34 3590  3563 __PSM__ session 136 closed
 2025-11-26 08:40:34 3590  3563 Process 3590  3563 completed.
 2025-11-26 08:40:35 3587  3563 __PSM__ session 135 closed
 2025-11-26 08:40:35 3587  3563 Process 3587  3563 completed.
 2025-11-26 08:40:35 3586  3563 Completed cold level 0 restore plogdbs.
 2025-11-26 08:40:35 3586  3563 __PSM__ session 137 closed
 2025-11-26 08:40:35 3586  3563 Process 3586  3563 completed.
 2025-11-26 08:40:36 3588  3563 Completed cold level 0 restore datadbs02.
 2025-11-26 08:40:36 3588  3563 __PSM__ session 139 closed
 2025-11-26 08:40:36 3588  3563 Process 3588  3563 completed.
 2025-11-26 08:40:36 3563  3561 (-43177) Physical restore complete. Logical restore required before work can
continue. Use 'onbar -r -l' to do logical restore.
If the physical restore is from a whole-system backup that was not
performed on an RSS server, then a logical restore is not required.
 2025-11-26 08:40:36 3563  3561 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)
#逻辑恢复正常,到37号日志了。
 2025-11-26 08:42:59 3604  3602 /opt/gbase/bin/onbar_d -r -l
 2025-11-26 08:43:00 3604  3602 Using GBASE's PSM version 12.10.FC4G1 as the Storage Manager. XBSA API version is 1.0.3.
 2025-11-26 08:43:00 3604  3602 The PSM is ready.
 2025-11-26 08:43:00 3604  3602 __PSM__ session 140 opened.
 2025-11-26 08:43:00 3604  3602 Successfully connected to Storage Manager.
 2025-11-26 08:43:00 3604  3602 Begin restore logical log 34 (Storage Manager copy ID: 0 9).
 2025-11-26 08:43:00 3604  3602 Completed restore logical log 34.
 2025-11-26 08:43:00 3604  3602 Begin restore logical log 35 (Storage Manager copy ID: 0 14).
 2025-11-26 08:43:00 3604  3602 Completed restore logical log 35.
 2025-11-26 08:43:00 3604  3602 Begin restore logical log 36 (Storage Manager copy ID: 0 15).
 2025-11-26 08:43:00 3604  3602 Completed restore logical log 36.
 2025-11-26 08:43:00 3604  3602 Begin restore logical log 37 (Storage Manager copy ID: 0 16).
 2025-11-26 08:43:00 3604  3602 Completed restore logical log 37.
 2025-11-26 08:43:06 3604  3602 Completed logical restore.
 2025-11-26 08:43:06 3604  3602 __PSM__ session 140 closed
 2025-11-26 08:43:06 3604  3602 /opt/gbase/bin/onbar_d complete, returning 0 (0x00)

--- 测试通过: Example 4: Exporting a backup from one server and importing it into another server

总结:

- 数据库厂商提供的onbar命令就是个接口(你想备日志还是备数据库调用命令就行)给备份软件吐备份数据,备份的结果(具体的备份对象)是由“备份存储管理”厂商实现的管理编目和调度的。

- 想把两个PSM存储管理软件的里面信息合并,PSM厂商并没有給出方案。走野路子把两个节点备份融合有点难,后期使用维护也麻烦。

- 鼎甲的“存储管理软件”如何把备份集群中的两个实例合并?可以找鼎甲要一下技术支持。

- 多实例融合PSM厂商没有做。面对这种需要两边备份,合并恢复的需求,推荐使用ontape来实现。

评论

登录后才可以发表评论
用户头像
GBase用户28017发表于 5个月前
学习。
流泪猫猫头发表于 6小时前
学习了