GBase 8s

备份恢复

问答

回滚日志后增量数据丢失问题

阳光爱上彩虹

发表于2025-09-02 17:19:14216次浏览23个评论

【GBase版本】:GBase8sV8.8_TL_3.6.3_3X1_1_e10e03

【操作系统】: arm平台

【问题描述】*:

使用ontape按照等级0进行备份，当前逻辑日志id为A，然后插入数据，手动切换日志，当前逻辑日志id为B；

原机停库，重构chunk文件，ontape恢复数据，然后回滚逻辑日志，以上操作均无报错；

检查逻辑日志发现当前正在使用的id为B，但是插入的数据没有恢复回来。

以下是我的操作步骤：

[gbasedbt@gbase8s etc]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:12:28 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 24571 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 10 7 7 1.4 1.0
    Subsystem numrecs Log Space used
    OLDRSAM 7 316
    HA 3 132

address number flags uniqid begin size used %used
54ea2fa8 4 U-B---- 207 2:53 125000 1 0.00
562a7550 5 U-B---- 208 2:125053 125000 1 0.00
562a75b8 6 U-B---- 209 2:250053 125000 1 0.00
562a7620 7 U-B---- 210 2:375053 125000 1 0.00
562a7688 8 U-B---- 211 2:500053 125000 5 0.00
562a76f0 9 U---C-L 212 2:625053 125000 2 0.00
562a7758 10 F------ 0 2:750053 125000 0 0.00
562a77c0 11 F------ 0 2:875053 125000 0 0.00
562a7828 12 F------ 0 2:1000053 125000 0 0.00
562a7890 13 F------ 0 2:1125053 125000 0 0.00
562a78f8 14 F------ 0 2:1250053 125000 0 0.00
562a7960 15 F------ 0 2:1375053 125000 0 0.00
562a79c8 16 F------ 0 2:1500053 125000 0 0.00
562a7a30 17 F------ 0 2:1625053 125000 0 0.00
562a7a98 18 F------ 0 2:1750053 125000 0 0.00
562a7b00 19 F------ 0 2:1875053 125000 0 0.00
562a7b68 20 F------ 0 2:2000053 125000 0 0.00
562a7bd0 21 F------ 0 2:2125053 125000 0 0.00
562a7c38 22 F------ 0 2:2250053 125000 0 0.00
562a7ca0 23 F------ 0 2:2375053 125000 0 0.00
562a7d08 24 F------ 0 2:2500053 125000 0 0.00
562a7d70 25 F------ 0 2:2625053 125000 0 0.00
562a7dd8 26 F------ 0 2:2750053 125000 0 0.00
562a7e40 27 F------ 0 2:2875053 125000 0 0.00
562a7ea8 28 F------ 0 2:3000053 125000 0 0.00
562a7f10 29 F------ 0 2:3125053 125000 0 0.00
562a7f78 30 F------ 0 2:3250053 125000 0 0.00
54a01f30 31 F------ 0 2:3375053 125000 0 0.00
54a01f98 32 F------ 0 2:3500053 125000 0 0.00
54ad6f30 33 F------ 0 2:3625053 125000 0 0.00
54ad6f98 34 F------ 0 2:3750053 125000 0 0.00
563e6028 35 F------ 0 2:3875053 125000 0 0.00
563e6090 36 F------ 0 2:4000053 125000 0 0.00
563e60f8 37 F------ 0 2:4125053 125000 0 0.00
563e6160 38 F------ 0 2:4250053 125000 0 0.00
563e61c8 39 F------ 0 2:4375053 125000 0 0.00
563e6230 40 F------ 0 2:4500053 125000 0 0.00
563e6298 41 F------ 0 2:4625053 125000 0 0.00
563e6300 42 F------ 0 2:4750053 125000 0 0.00
563e6368 43 U-B---- 206 2:4875053 125000 16 0.01
40 active, 40 total

[gbasedbt@gbase8s etc]$ echo "select count(*) from employees_1;" | dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

(count(*))

400

1 row(s) retrieved.

Database closed.

[gbasedbt@gbase8s etc]$ ontape -s -L 0 -d -t STDIO > /home/backup_set/backup_0_0
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s etc]$ dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

> INSERT INTO employees_1 (id, name, salary, hire_date) VALUES
(401, '何洋', 7821.95, '2024-01-11'),
(402, '马艳', 19131.86, '2023-12-22'),
(403, '何婷', 13214.41, '2021-03-12'),
(404, '吴洋', 9372.29, '2024-03-14'),
(> 405, '马磊> > > > ', 19046.98, '2021-09-10'),
(406, '赵超', 14745.58, '2022-09-20'),
(407, '张明', 13379.49, '2022-09-28'),
(408, '黄刚', 14714.19, '2022-09-12'),
(409, '何刚', 13210.2, '2023-06-17'),
(410, '郭静', 13896.58, '2025-08-> 21');
> > > >
10 row(s) inserted.

>
> ^C[gbasedbt@gbase8s etc]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:13:06 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 30 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 24571 30 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 512 19 9 9 2.1 1.0
    Subsystem numrecs Log Space used
    OLDRSAM 15 784
    HA 4 176

address number flags uniqid begin size used %used
54ea2fa8 4 U-B---- 207 2:53 125000 1 0.00
562a7550 5 U-B---- 208 2:125053 125000 1 0.00
562a75b8 6 U-B---- 209 2:250053 125000 1 0.00
562a7620 7 U-B---- 210 2:375053 125000 1 0.00
562a7688 8 U-B---- 211 2:500053 125000 5 0.00
562a76f0 9 U---C-L 212 2:625053 125000 4 0.00
562a7758 10 F------ 0 2:750053 125000 0 0.00
562a77c0 11 F------ 0 2:875053 125000 0 0.00
562a7828 12 F------ 0 2:1000053 125000 0 0.00
562a7890 13 F------ 0 2:1125053 125000 0 0.00
562a78f8 14 F------ 0 2:1250053 125000 0 0.00
562a7960 15 F------ 0 2:1375053 125000 0 0.00
562a79c8 16 F------ 0 2:1500053 125000 0 0.00
562a7a30 17 F------ 0 2:1625053 125000 0 0.00
562a7a98 18 F------ 0 2:1750053 125000 0 0.00
562a7b00 19 F------ 0 2:1875053 125000 0 0.00
562a7b68 20 F------ 0 2:2000053 125000 0 0.00
562a7bd0 21 F------ 0 2:2125053 125000 0 0.00
562a7c38 22 F------ 0 2:2250053 125000 0 0.00
562a7ca0 23 F------ 0 2:2375053 125000 0 0.00
562a7d08 24 F------ 0 2:2500053 125000 0 0.00
562a7d70 25 F------ 0 2:2625053 125000 0 0.00
562a7dd8 26 F------ 0 2:2750053 125000 0 0.00
562a7e40 27 F------ 0 2:2875053 125000 0 0.00
562a7ea8 28 F------ 0 2:3000053 125000 0 0.00
562a7f10 29 F------ 0 2:3125053 125000 0 0.00
562a7f78 30 F------ 0 2:3250053 125000 0 0.00
54a01f30 31 F------ 0 2:3375053 125000 0 0.00
54a01f98 32 F------ 0 2:3500053 125000 0 0.00
54ad6f30 33 F------ 0 2:3625053 125000 0 0.00
54ad6f98 34 F------ 0 2:3750053 125000 0 0.00
563e6028 35 F------ 0 2:3875053 125000 0 0.00
563e6090 36 F------ 0 2:4000053 125000 0 0.00
563e60f8 37 F------ 0 2:4125053 125000 0 0.00
563e6160 38 F------ 0 2:4250053 125000 0 0.00
563e61c8 39 F------ 0 2:4375053 125000 0 0.00
563e6230 40 F------ 0 2:4500053 125000 0 0.00
563e6298 41 F------ 0 2:4625053 125000 0 0.00
563e6300 42 F------ 0 2:4750053 125000 0 0.00
563e6368 43 U-B---- 206 2:4875053 125000 16 0.01
40 active, 40 total

[gbasedbt@gbase8s etc]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s etc]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s etc]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s etc]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s etc]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:13:17 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 30 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 24571 30 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 22 12 12 1.8 1.0
    Subsystem numrecs Log Space used
    OLDRSAM 18 976
    HA 4 176

address number flags uniqid begin size used %used
54ea2fa8 4 U-B---- 207 2:53 125000 1 0.00
562a7550 5 U-B---- 208 2:125053 125000 1 0.00
562a75b8 6 U-B---- 209 2:250053 125000 1 0.00
562a7620 7 U-B---- 210 2:375053 125000 1 0.00
562a7688 8 U-B---- 211 2:500053 125000 5 0.00
562a76f0 9 U-B---L 212 2:625053 125000 5 0.00
562a7758 10 U-B---- 213 2:750053 125000 1 0.00
562a77c0 11 U-B---- 214 2:875053 125000 1 0.00
562a7828 12 U-B---- 215 2:1000053 125000 1 0.00
562a7890 13 U---C-- 216 2:1125053 125000 0 0.00
562a78f8 14 F------ 0 2:1250053 125000 0 0.00
562a7960 15 F------ 0 2:1375053 125000 0 0.00
562a79c8 16 F------ 0 2:1500053 125000 0 0.00
562a7a30 17 F------ 0 2:1625053 125000 0 0.00
562a7a98 18 F------ 0 2:1750053 125000 0 0.00
562a7b00 19 F------ 0 2:1875053 125000 0 0.00
562a7b68 20 F------ 0 2:2000053 125000 0 0.00
562a7bd0 21 F------ 0 2:2125053 125000 0 0.00
562a7c38 22 F------ 0 2:2250053 125000 0 0.00
562a7ca0 23 F------ 0 2:2375053 125000 0 0.00
562a7d08 24 F------ 0 2:2500053 125000 0 0.00
562a7d70 25 F------ 0 2:2625053 125000 0 0.00
562a7dd8 26 F------ 0 2:2750053 125000 0 0.00
562a7e40 27 F------ 0 2:2875053 125000 0 0.00
562a7ea8 28 F------ 0 2:3000053 125000 0 0.00
562a7f10 29 F------ 0 2:3125053 125000 0 0.00
562a7f78 30 F------ 0 2:3250053 125000 0 0.00
54a01f30 31 F------ 0 2:3375053 125000 0 0.00
54a01f98 32 F------ 0 2:3500053 125000 0 0.00
54ad6f30 33 F------ 0 2:3625053 125000 0 0.00
54ad6f98 34 F------ 0 2:3750053 125000 0 0.00
563e6028 35 F------ 0 2:3875053 125000 0 0.00
563e6090 36 F------ 0 2:4000053 125000 0 0.00
563e60f8 37 F------ 0 2:4125053 125000 0 0.00
563e6160 38 F------ 0 2:4250053 125000 0 0.00
563e61c8 39 F------ 0 2:4375053 125000 0 0.00
563e6230 40 F------ 0 2:4500053 125000 0 0.00
563e6298 41 F------ 0 2:4625053 125000 0 0.00
563e6300 42 F------ 0 2:4750053 125000 0 0.00
563e6368 43 U-B---- 206 2:4875053 125000 16 0.01
40 active, 40 total

[gbasedbt@gbase8s etc]$ cd /home/gbasedbt/gbaseserver_dbs
[gbasedbt@gbase8s gbaseserver_dbs]$ ls
datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
[gbasedbt@gbase8s gbaseserver_dbs]$ rm -rf *
[gbasedbt@gbase8s gbaseserver_dbs]$ ls
[gbasedbt@gbase8s gbaseserver_dbs]$ rm -rf *
[gbasedbt@gbase8s gbaseserver_dbs]$ touch datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
[gbasedbt@gbase8s gbaseserver_dbs]$ chmod 660 *
[gbasedbt@gbase8s gbaseserver_dbs]$ cat /home/backup_set/backup_0_0 | ontape -p -t STDIO
Your evaluation license will expire on 2026-08-09 12:00:00
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
Fast Recovery -- Up 00:01:06 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ ontape -l -d
Your evaluation license will expire on 2026-08-09 12:00:00

Roll forward should start with log number 212
Restore is using file /opt/gbase8s/backups/gbase8s_91_Log0000000212 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000212 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000213 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000214 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000215 ...

Program over.
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
Quiescent -- Up 00:02:33 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
Quiescent -- Up 00:02:36 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 24580 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 6 4 4 1.5 1.0
    Subsystem numrecs Log Space used
    OLDRSAM 4 168
    HA 2 88

address number flags uniqid begin size used %used
54ea2fa8 4 F------ 0 2:53 125000 0 0.00
562ac550 5 F------ 0 2:125053 125000 0 0.00
562ac5b8 6 F------ 0 2:250053 125000 0 0.00
562ac620 7 F------ 0 2:375053 125000 0 0.00
562ac688 8 F------ 0 2:500053 125000 0 0.00
562ac6f0 9 U-B---- 212 2:625053 125000 5 0.00
562ac758 10 U-B---- 213 2:750053 125000 1 0.00
562ac7c0 11 U-B---- 214 2:875053 125000 1 0.00
562ac828 12 U-B---- 215 2:1000053 125000 1 0.00
562ac890 13 U---C-L 216 2:1125053 125000 4 0.00
562ac8f8 14 F------ 0 2:1250053 125000 0 0.00
562ac960 15 F------ 0 2:1375053 125000 0 0.00
562ac9c8 16 F------ 0 2:1500053 125000 0 0.00
562aca30 17 F------ 0 2:1625053 125000 0 0.00
562aca98 18 F------ 0 2:1750053 125000 0 0.00
562acb00 19 F------ 0 2:1875053 125000 0 0.00
562acb68 20 F------ 0 2:2000053 125000 0 0.00
562acbd0 21 F------ 0 2:2125053 125000 0 0.00
562acc38 22 F------ 0 2:2250053 125000 0 0.00
562acca0 23 F------ 0 2:2375053 125000 0 0.00
562acd08 24 F------ 0 2:2500053 125000 0 0.00
562acd70 25 F------ 0 2:2625053 125000 0 0.00
562acdd8 26 F------ 0 2:2750053 125000 0 0.00
562ace40 27 F------ 0 2:2875053 125000 0 0.00
562acea8 28 F------ 0 2:3000053 125000 0 0.00
562acf10 29 F------ 0 2:3125053 125000 0 0.00
562acf78 30 F------ 0 2:3250053 125000 0 0.00
54a01f30 31 F------ 0 2:3375053 125000 0 0.00
54a01f98 32 F------ 0 2:3500053 125000 0 0.00
54ad6f30 33 F------ 0 2:3625053 125000 0 0.00
54ad6f98 34 F------ 0 2:3750053 125000 0 0.00
563f7028 35 F------ 0 2:3875053 125000 0 0.00
563f7090 36 F------ 0 2:4000053 125000 0 0.00
563f70f8 37 F------ 0 2:4125053 125000 0 0.00
563f7160 38 F------ 0 2:4250053 125000 0 0.00
563f71c8 39 F------ 0 2:4375053 125000 0 0.00
563f7230 40 F------ 0 2:4500053 125000 0 0.00
563f7298 41 F------ 0 2:4625053 125000 0 0.00
563f7300 42 F------ 0 2:4750053 125000 0 0.00
563f7368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

[gbasedbt@gbase8s gbaseserver_dbs]$ onmode -m
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:03:13 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:03:16 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 24580 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 6 4 4 1.5 1.0
    Subsystem numrecs Log Space used
    OLDRSAM 4 168
    HA 2 88

[gbasedbt@gbase8s gbaseserver_dbs]$ echo "select count(*) from employees_1;" | dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

(count(*))

400

1 row(s) retrieved.

Database closed.

登录后才可以发表评论

路路路发表于 11个月前

稍等

阳光爱上彩虹发表于 11个月前

@路路路：好的，辛苦老师

南大通用Gbase_罗文才发表于 11个月前

本机的话，使用 ontape -r 恢复数据库：
恢复数据库过程
[gbasedbt@gbasehost01 ~]$ ontape -r
Restore will use level 0 archive file /opt/gbase/backup/gbasehost01_0_L0. Press Return to
continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1AEE
Archive date: Tue Jul 28 10:04:40 2020
User id: gbasedbt
Terminal id: /dev/pts/1
Archive level: 0
Tape device: /opt/gbase/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Spaces to restore:1 [rootdbs ]
2 [plogdbs ]
3 [llogdbs ]
4 [datadbs01 ]
5 [sbspace01 ]
Archive Information
GBase Database Server Copyright 2001, 2018 General Data Corporation
Initialization Time 07/27/2020 14:57:35
System Page Size 2048
Version 30
Index Page Logging OFF
Archive CheckPoint Time 07/28/2020 10:04:40
Dbspaces
number flags fchunk nchunks flags owner name
1 60001 1 1 N BA gbasedbt rootdbs
2 40001 2 1 N BA gbasedbt plogdbs
3 40001 3 1 N BA gbasedbt llogdbs
4 42001 4 1 N TBA gbasedbt tempdbs01
5 68001 5 1 N SBA gbasedbt sbspace01
6 60001 6 1 N BA gbasedbt datadbs01
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 512000 498315 PO-B- /data/gbase/rootchk
2 2 0 512000 11947 PO-B- /data/gbase/plogchk
3 3 0 512000 11947 PO-B- /data/gbase/llogchk
4 4 0 512000 511512 PO-B- /data/gbase/tempchk01
5 5 0 512000 25659 POSB- /data/gbase/sbspace01
6 6 0 512000 511576 PO-B- /data/gbase/datachk01
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
Would you like to back up log 7? (y/n) y
Read/Write End Of Medium enabled: blocks = 2
Please label this tape as number 1 in the log tape sequence.
This tape contains the following logical logs:
7
Log salvage is complete, continuing restore of archive.
Restore a level 1 archive (y/n) n
Do you want to restore log tapes? (y/n)n
/opt/gbase/bin/onmode -sy
Program over.
[gbasedbt@node2 ~]$ onmode -m

阳光爱上彩虹发表于 11个月前

@南大通用Gbase_罗文才：我试了ontape -r，还是不对，而且只有level 0备份时的数据，没有之后插入的10条数据。

曾阿牛发表于 11个月前

你这恢复前后都是400条，怎么是丢数据了？

阳光爱上彩虹发表于 11个月前

@曾阿牛：400条是level 0时的备份，在之后我又插入了10条数据，所以任务id为B时应该是410条才对

阳光爱上彩虹发表于 11个月前

看了两位老师的回复，我觉得我有必要再次说明一下：
1. 我的操作步骤很详细，哪个阶段做了什么事情都有，所以麻烦老师仔细看一下。
2. 我的疑问如下：
我的逻辑日志都存在：无论是备份level 0时的日志还是之后插入数据的日志都是存在的，回滚日志后onstat -l也能看到当前日志id就是我插入数据后的id，而不是备份level 0时的id，但是却没有插入的数据，这是为什么？

bobomi发表于 11个月前

@阳光爱上彩虹：逻辑日志备份是自动备份吗？onmode -l 切换后看看备份目录生成自动备份日志没？
1、ontape全备份 400条
2、插入数据10条
3、切换日志，并备份日志
4、删除chunk
5、物理恢复chunk 300条，逻辑恢复日志10条
检查下这个过程中10条数据是否有备份逻辑日志落地，恢复时候是否从这几个备份逻辑日志文件恢复的

阳光爱上彩虹发表于 11个月前

@bobomi：是自动备份的，且逻辑日志已经生成，全量备份是的日志id为212，随后插入10条数据，此时日志id还是212，然后切换了4次日志，此时日志id是216，onstat -l可以看到标志位为B，且日志文件存在。
在恢复的时候也可以看到回滚了 212-215的逻辑日志的记录
恢复完成后onstat -l也能看到当前日志id是216，
以上三点可以确定逻辑日志已生成且恢复时也使用到了。

阳光爱上彩虹发表于 11个月前

@bobomi：是自动备份的，切换后也生成了相应的日志
1. 全量备份是日志id是212，随后插入10条数据，此时日志id还是212.，然后切换了四次日志，此时日志id是216，onstat -l可以看到212-215都是B标志，
2. 恢复时可以看到使用到了212-215这几个日志的记录，且恢复完成后onstat -l可以看到当前日志id确实是216
以上两点可以确定插入10条记录的逻辑日志已经备份且恢复时使用到了

阳光爱上彩虹发表于 11个月前

@bobomi：是自动备份的，且相应日志文件已经生成
1. 全量备份时日志id为212，插入10条数据，此时日志id还是212，切换四次日志后，日志id为216，onstat -l命令可以看到212-215标志位有B，
2. 恢复时可以看到Rollforward log file 212-215日志的记录。
3. 恢复后onstat -l命令可以看到当前日志id时216
综合以上三点可以确定插入10条数据的日志已经生成且恢复时使用到了

bobomi发表于 11个月前

@阳光爱上彩虹：onconfig文件中TAPEDEV, LTAPEDEV，ALARMPROGRAM看下配置，onmode -l切换后看下TAPEDEV配置目录下是否生成日志文件，我实验了下我上面写的5个步骤，是没问题的。

bobomi发表于 11个月前

@bobomi：1、配置
onconfig:
TAPEDEV /opt/gbase20/tmp/logbak
LTAPEDEV /opt/gbase20/tmp/logbak
ALARMPROGRAM $GBASEDBTDIR/etc/alarmprogram.sh

cat $GBASEDBTDIR/etc/alarmprogram.sh|more
#!/bin/bash
BACKUPLOGS=Y
BACKUP_CMD="ontape -a -d"
2、步骤
-bash-4.2$ dbaccess test -

Database selected.

> select count(*) from t1;

(count(*))

3

1 row(s) retrieved.

> ^C-bash-4.2$

-bash-4.2$ ontape -s -L 0 -d
100 percent done.
File created: /opt/gbase20/tmp/logbak/localhost.localdomain_239_L0

Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:

9

Program over.
-bash-4.2$ ls -l /opt/gbase20/tmp/logbak
总用量 103968
-rw-rw----. 1 gbasedbt gbasedbt 35389440 9月 4 14:57 localhost.localdomain_239_20250904_145723_L0
-rw-rw----. 1 gbasedbt gbasedbt 35389440 9月 4 15:06 localhost.localdomain_239_20250904_150628_L0
-rw-rw----. 1 gbasedbt gbasedbt 27852800 9月 4 16:21 localhost.localdomain_239_L0
-rw-rw----. 1 gbasedbt gbasedbt 7634944 9月 4 15:09 localhost.localdomain_239_Log0000000006
-rw-rw----. 1 gbasedbt gbasedbt 98304 9月 4 15:09 localhost.localdomain_239_Log0000000007
-rw-rw----. 1 gbasedbt gbasedbt 98304 9月 4 15:09 localhost.localdomain_239_Log0000000008

-bash-4.2$ onstat -l|more

GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 01:08:49 -- 2186764 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 59 6 9.83
phybegin physize phypos phyused %used
3:53 508928 1422 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 512 27 14 14 1.9 1.0
Subsystem numrecs Log Space used
OLDRSAM 20 972
HA 7 308

address number flags uniqid begin size used %used
48cfcf88 4 F------ 0 2:53 12500 0 0.00
4b67c970 5 F------ 0 2:12553 12500 0 0.00
4b67c9d8 6 U-B---- 6 2:25053 12500 3694 29.55
4b67ca40 7 U-B---- 7 2:37553 12500 1 0.01
4b67caa8 8 U-B---- 8 2:50053 12500 3 0.02
4b67cb10 9 U---C-L 9 2:62553 12500 14 0.11
4b67cb78 10 A------ 0 2:75053 12500 0 0.00
4b67cbe0 11 A------ 0 2:87553 12500 0 0.00

-bash-4.2$ dbaccess test -

Database selected.

> insert into t1 values(4);

1 row(s) inserted.

> select count(*) from t1;

(count(*))

4

1 row(s) retrieved.

-bash-4.2$ onmode -l
-bash-4.2$ onmode -l
-bash-4.2$ onstat -l|more

GBase Database Server Version 12.10.FC4G1AEE -- On-Line -- Up 01:10:28 -- 2186764 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 81 7 11.57
phybegin physize phypos phyused %used
3:53 508928 1444 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 35 19 19 1.8 1.0
Subsystem numrecs Log Space used
OLDRSAM 27 1364
HA 8 352

address number flags uniqid begin size used %used
48cfcf88 4 F------ 0 2:53 12500 0 0.00
4b67c970 5 F------ 0 2:12553 12500 0 0.00
4b67c9d8 6 U-B---- 6 2:25053 12500 3694 29.55
4b67ca40 7 U-B---- 7 2:37553 12500 1 0.01
4b67caa8 8 U-B---- 8 2:50053 12500 3 0.02
4b67cb10 9 U-B---L 9 2:62553 12500 18 0.14
4b67cb78 10 U-B---- 10 2:75053 12500 1 0.01
4b67cbe0 11 U---C-- 11 2:87553 12500 0 0.00
4b67cc48 12 A------ 0 2:100053 12500 0 0.00

-bash-4.2$ ls -l /opt/gbase20/tmp/logbak
总用量 104192
-rw-rw----. 1 gbasedbt gbasedbt 35389440 9月 4 14:57 localhost.localdomain_239_20250904_145723_L0
-rw-rw----. 1 gbasedbt gbasedbt 35389440 9月 4 15:06 localhost.localdomain_239_20250904_150628_L0
-rw-rw----. 1 gbasedbt gbasedbt 27852800 9月 4 16:21 localhost.localdomain_239_L0
-rw-rw----. 1 gbasedbt gbasedbt 7634944 9月 4 15:09 localhost.localdomain_239_Log0000000006
-rw-rw----. 1 gbasedbt gbasedbt 98304 9月 4 15:09 localhost.localdomain_239_Log0000000007
-rw-rw----. 1 gbasedbt gbasedbt 98304 9月 4 15:09 localhost.localdomain_239_Log0000000008
-rw-rw----. 1 gbasedbt gbasedbt 131072 9月 4 16:24 localhost.localdomain_239_Log0000000009
-rw-rw----. 1 gbasedbt gbasedbt 98304 9月 4 16:24 localhost.localdomain_239_Log0000000010

-bash-4.2$ ls
datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
-bash-4.2$ onmode -ky
-bash-4.2$ rm -rf datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
-bash-4.2$ touch datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
-bash-4.2$ chmod 660 *

-bash-4.2$ ontape -p -d

Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 92437 PO-B- /opt/gbase20/gbase01_dbs/rootdbs
2 2 0 524288 24235 PO-B- /opt/gbase20/gbase01_dbs/llogdbs
3 3 0 524288 15307 PO-B- /opt/gbase20/gbase01_dbs/plogdbs
4 4 0 152576 7657 POSB- /opt/gbase20/gbase01_dbs/sbspace1
5 5 0 152576 152088 PO-B- /opt/gbase20/gbase01_dbs/tmpdbs1
6 6 0 51200 41960 PO-BE /opt/gbase20/gbase01_dbs/datadbs1_1

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n

-bash-4.2$ onstat -

GBase Database Server Version 12.10.FC4G1AEE -- Fast Recovery -- Up 00:00:46 -- 1649164 Kbytes

-bash-4.2$ ontape -l -d
-bash-4.2$ onstat -

GBase Database Server Version 12.10.FC4G1AEE -- Quiescent -- Up 00:01:06 -- 2186764 Kbytes

-bash-4.2$ onmode -m
-bash-4.2$
-bash-4.2$ dbaccess test -

Database selected.

> select count(*) from t1;

(count(*))

4

1 row(s) retrieved.

bobomi发表于 11个月前

@bobomi：onmode -l后你可以再执行下onmode -c，然后再试一遍。

阳光爱上彩虹发表于 11个月前

@bobomi：好的我试试，谢谢老师

阳光爱上彩虹发表于 11个月前

@bobomi：还是没有增加的那10条数据：我按照老师的第一个方法一步一步进行的，还是不行，之后在切换日志时使用了onmode -c，也是没有增量的数据，
以下是我的步骤：
# 查看配置信息
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -c | grep -E 'TAPEDEV|ALARMPROGRAM' | grep -v '#'
Your evaluation license will expire on 2026-08-09 12:00:00
TAPEDEV /home/gbasedbt/archive/logical
LTAPEDEV /opt/gbase8s/backups
ALARMPROGRAM /opt/gbase8s/etc/alarmprogram.sh
SYSALARMPROGRAM $GBASEDBTDIR/etc/evidence.sh

[gbasedbt@gbase8s gbaseserver_dbs]$ cat /opt/gbase8s/etc/alarmprogram.sh|more
#!/bin/bash
BACKUPLOGS=Y
BACKUP_CMD="ontape -a -d"

# 查看数据信息
[gbasedbt@gbase8s ~]$ dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

> select count(*) from employees_1;

(count(*))

410

1 row(s) retrieved.

# 查看日志信息
[gbasedbt@gbase8s ~]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:12:37 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 25794 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 512 3 2 2 1.5 1.0
Subsystem numrecs Log Space used
OLDRSAM 2 84
HA 1 44

address number flags uniqid begin size used %used
...
562acca0 23 F------ 0 2:2375053 125000 0 0.00
562acd08 24 U-B---L 227 2:2500053 125000 2991 2.39
562acd70 25 U---C-- 228 2:2625053 125000 0 0.00
562acdd8 26 F------ 0 2:2750053 125000 0 0.00
...
563e6368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

[gbasedbt@gbase8s backup_set]$ ll /opt/gbase8s/backups
total 6080
-rw-rw---- 1 gbasedbt gbasedbt 6225920 Sep 4 17:47 gbase8s_91_Log0000000227

# 全量备份
[gbasedbt@gbase8s backup_set]$ ontape -s -L 0 -d -t STDIO > /home/backup_set/backup_0_0
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s backup_set]$ ll
total 73216
-rw-rw-r-- 1 gbasedbt gbasedbt 74973184 Sep 4 17:49 backup_0_0
[gbasedbt@gbase8s backup_set]$ pwd
/home/backup_set

# 插入数据
[gbasedbt@gbase8s gbaseserver_dbs]$ dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

> INSERT INTO employees_1 (id, name, salary, hire_date) VALUES
(411, '王芳', 9746.16, '2022-06-01'),
(412, '郭静', 11814.03, '2025-08-19'),
(413, '周娜', 6882.32, '2021-05-24'),
(414, '刘洋', 16614.63, '2023-06-02'),
(> 415, '赵强', 13026.8, '2024-01-22'),
(416, '朱勇', 17196.88, '2022-08-09'),
(417, '賾 µ娜', 12740.26, '2024-09-15'),
(418, '胡伟', 19313.9> 9, '2022-02-11'),
(419, '杨秀英', 182> 60.66, '2022-05-02'),
(420, '杨勇', 12991.2> 1, '2024-11-25');
> > > > >
10 row(s) inserted.

> select count(*) from employees_1;

(count(*))

420

1 row(s) retrieved.

>

[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:19:15 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 53 3 17.67
phybegin physize phypos phyused %used
3:53 4970000 25838 14 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-3 0 512 28 11 11 2.5 1.0
Subsystem numrecs Log Space used
OLDRSAM 23 1252
HA 5 220

address number flags uniqid begin size used %used
54ea2fa8 4 F------ 0 2:53 125000 0 0.00
...
562acca0 23 F------ 0 2:2375053 125000 0 0.00
562acd08 24 U-B---- 227 2:2500053 125000 2991 2.39
562acd70 25 U---C-L 228 2:2625053 125000 6 0.00
562acdd8 26 F------ 0 2:2750053 125000 0 0.00
...
563e6368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

# 切换日志
[gbasedbt@gbase8s gbaseserver_dbs]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onmode -l
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:19:23 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 53 3 17.67
phybegin physize phypos phyused %used
3:53 4970000 25838 14 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 29 12 12 2.4 1.0
Subsystem numrecs Log Space used
OLDRSAM 24 1316
HA 5 220

address number flags uniqid begin size used %used
54ea2fa8 4 F------ 0 2:53 125000 0 0.00
...
562acca0 23 F------ 0 2:2375053 125000 0 0.00
562acd08 24 U-B---- 227 2:2500053 125000 2991 2.39
562acd70 25 U-B---L 228 2:2625053 125000 7 0.01
562acdd8 26 U-B---- 229 2:2750053 125000 1 0.00
562ace40 27 U---C-- 230 2:2875053 125000 0 0.00
...
563e6368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

[gbasedbt@gbase8s gbaseserver_dbs]$ ll /opt/gbase8s/backups
total 6272
-rw-rw---- 1 gbasedbt gbasedbt 6225920 Sep 4 17:47 gbase8s_91_Log0000000227
-rw-rw---- 1 gbasedbt gbasedbt 98304 Sep 4 17:51 gbase8s_91_Log0000000228
-rw-rw---- 1 gbasedbt gbasedbt 98304 Sep 4 17:51 gbase8s_91_Log0000000229
[gbasedbt@gbase8s gbaseserver_dbs]$

# 关库
[gbasedbt@gbase8s backup_set]$ onmode -ky
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s backup_set]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
shared memory not initialized for GBASEDBTSERVER 'gbaseserver'

# 重建chunk文件
[gbasedbt@gbase8s gbaseserver_dbs]$ pwd
/home/gbasedbt/gbaseserver_dbs
[gbasedbt@gbase8s gbaseserver_dbs]$ ls
datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
[gbasedbt@gbase8s gbaseserver_dbs]$ rm -rf *
[gbasedbt@gbase8s gbaseserver_dbs]$ touch datadbs1_1 llogdbs plogdbs rootdbs sbspace1 tmpdbs1
[gbasedbt@gbase8s gbaseserver_dbs]$ chmod 660 *

# 恢复全量数据
[gbasedbt@gbase8s gbaseserver_dbs]$ cat /home/backup_set/backup_0_0 | ontape -p -t STDIO
Your evaluation license will expire on 2026-08-09 12:00:00
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
Fast Recovery -- Up 00:02:13 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
Fast Recovery -- Up 00:02:17 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 0 0 0.00
phybegin physize phypos phyused %used
3:53 4970000 25794 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-1 0 512 0 0 0 0.0 0.0
Subsystem numrecs Log Space used

address number flags uniqid begin size used %used
54ea2fa8 4 F------ 0 2:53 125000 0 0.00
...
562a7d08 24 F------ 0 2:2500053 125000 0 0.00
562a7d70 25 U---C-L 228 2:2625053 125000 4 0.00
562a7dd8 26 F------ 0 2:2750053 125000 0 0.00
...
563e6368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

# 回滚日志
[gbasedbt@gbase8s gbaseserver_dbs]$ ontape -l -d
Your evaluation license will expire on 2026-08-09 12:00:00

Roll forward should start with log number 228
Restore is using file /opt/gbase8s/backups/gbase8s_91_Log0000000228 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000228 ...
Rollforward log file /opt/gbase8s/backups/gbase8s_91_Log0000000229 ...

Program over.
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
Quiescent -- Up 00:04:13 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -l
Your evaluation license will expire on 2026-08-09 12:00:00
Quiescent -- Up 00:04:16 -- 9001920 Kbytes

Physical Logging
Buffer bufused bufsize numpages numwrits pages/io
P-2 0 1024 9 1 9.00
phybegin physize phypos phyused %used
3:53 4970000 25803 0 0.00

Logical Logging
Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io
L-2 0 512 6 4 4 1.5 1.0
Subsystem numrecs Log Space used
OLDRSAM 4 168
HA 2 88

address number flags uniqid begin size used %used
54ea2fa8 4 F------ 0 2:53 125000 0 0.00
...
562a7d08 24 F------ 0 2:2500053 125000 0 0.00
562a7d70 25 U-B---- 228 2:2625053 125000 7 0.01
562a7dd8 26 U-B---- 229 2:2750053 125000 1 0.00
562a7e40 27 U---C-L 230 2:2875053 125000 4 0.00
562a7ea8 28 F------ 0 2:3000053 125000 0 0.00
...
563e6368 43 F------ 0 2:4875053 125000 0 0.00
40 active, 40 total

# 查看数据
[gbasedbt@gbase8s gbaseserver_dbs]$ onmode -m
Your evaluation license will expire on 2026-08-09 12:00:00
[gbasedbt@gbase8s gbaseserver_dbs]$ onstat -
Your evaluation license will expire on 2026-08-09 12:00:00
On-Line -- Up 00:05:10 -- 9001920 Kbytes

[gbasedbt@gbase8s gbaseserver_dbs]$ dbaccess test_database -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

> select count(*) from employees_1;

(count(*))

410

1 row(s) retrieved.

>

bobomi发表于 11个月前

@阳光爱上彩虹：select * from sysmaster:sysdatabases where name='数据库名‘；数据库模式我看下，是带归档日志的没？

阳光爱上彩虹发表于 10个月前

@bobomi：好的，这是结果：
[gbasedbt@gbase8s ~]$ dbaccess sysmaster -
Your evaluation license will expire on 2026-08-09 12:00:00

Database selected.

>
select * from sysmaster:sysdatabases where name='test_database';>

name test_database
partnum 6291538
owner gbasedbt
created 2025-08-12
is_logging 0
is_buff_log 0
is_ansi 0
is_nls 0
is_case_insens 0
flags -12288

1 row(s) retrieved.

>

阳光爱上彩虹发表于 10个月前

@bobomi：老师，请问这个问题还需要我提供哪些信息吗？

bobomi发表于 10个月前

@阳光爱上彩虹：从上面信息看，数据库是无日志模式，不记录归档日志，故无法恢复归档日志内容；ontape -s -L 0 -U testdb -t /dev/null 改为unbuffer日志模式，testdb是数据库名。请参阅更改日志的文章：https://www.gbase.cn/community/post/2931

崔哥发表于 7个月前

春色欲来时，先散满天风雪。坐使七闽松竹，变珠幢玉节。中原佳气郁葱葱，河山壮宫阙。丞相功成千载，映黄流清澈。

崔哥发表于 3个月前

古木阴中系短篷，杖藜扶我过桥东。沾衣欲湿杏花雨，吹面不寒杨柳风。

青菇凉发表于 2个月前

学习中，还不清楚。

回滚日志后增量数据丢失问题

评论

热门帖子