ontape简介
使用ontape，可以进行GBase 8s数据库的备份与恢复。
- ontape 支持L0，L1，L2三级备份与恢复。
- ontape 支持逻辑日志的备份与恢复。
- ontape 本身不支持基于时间点的恢复，但可通过其它工具，将 ontape 备份的单个表中数据，恢复到指定的时间点（暂不讨论）。基于时间点的数据库备份与恢复，建议使用 onbar 实现。
备份命令：
| 命令 | 说明 |
|---|---|
| ontape -s -L 0 | 进行L0级备份 |
| ontape -s -L 1 | 进行L1级备份 |
| ontape -s -L 2 | 进行L2级备份 |
| ontape -a | 进行自动逻辑日志备份 |
| ontape -c | 启动连续逻辑日志备份 |
| ontape -S | 抢救逻辑日志 |
恢复命令
| 命令 | 说明 |
|---|---|
| ontape -r | 完成恢复 |
| ontape -p | 进行物理恢复 |
| ontape -l | 进行逻辑恢复 |
| ontape -C | 连续逻辑日志恢复 |
| ontape -X | 停止连续逻辑日志恢复 |
备份/恢复操作演示
ontape 环境参数设置
使用ontape进行数据库的备份与恢复时，需要设置ontape默认使用的存储设备。
可通过修改参数文件，或使用 onmode -wf 命令，设置GBase 8s的参数。可通过 onstat -c 命令，查看GBase 8s的参数设置。
检查 GBase 8s 备份的存储设备参数，发现未指定备份存储设备。
[gbasedbt@gbase ~]$ onstat -c | grep TAPEDEV | grep -v '#'
Your evaluation license will expire on 2024-02-04 00:00:00
TAPEDEV /dev/null
LTAPEDEV /dev/null
创建一个目录，并设置物理备份和逻辑备份的存储设备为新创建的目录。
[gbasedbt@gbase ~]$ mkdir backup
[gbasedbt@gbase ~]$ onmode -wf "TAPEDEV=/home/gbasedbt/backup"
Your evaluation license will expire on 2024-02-04 00:00:00
Value of TAPEDEV has been changed to /home/gbasedbt/backup.
[gbasedbt@gbase ~]$ onmode -wf "LTAPEDEV=/home/gbasedbt/backup"
Your evaluation license will expire on 2024-02-04 00:00:00
Value of LTAPEDEV has been changed to /home/gbasedbt/backup.
查看备份设备参数，已经指向新创建的目录。
[gbasedbt@gbase ~]$ onstat -c | grep TAPEDEV | grep -v '#'
Your evaluation license will expire on 2024-02-04 00:00:00
TAPEDEV /home/gbasedbt/backup
LTAPEDEV /home/gbasedbt/backup
创建测试数据
[gbasedbt@gbase ~]$ dbaccess - -
drop database mydb;
create database mydb in datadbs1 with log;
create table t_dept(f_deptid int, f_deptname varchar(20));
create table t_employee(f_employeeid int, f_deptid int, f_employeename varchar(20));
insert into t_dept values (1, 'dept_1');
insert into t_dept values (2, 'dept_2');
insert into t_dept values (3, 'dept_3');
insert into t_employee values (1, 1, 'employee_01');
insert into t_employee values (2, 1, 'employee_02');
insert into t_employee values (3, 2, 'employee_03');
insert into t_employee values (4, 2, 'employee_04');
insert into t_employee values (5, 3, 'employee_05');
> select * from t_dept;
f_deptid f_deptname
1 dept_1
2 dept_2
3 dept_3
3 row(s) retrieved.
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
5 row(s) retrieved.
L0备份
[gbasedbt@gbase backup]$ ontape -s -L 0
Your evaluation license will expire on 2024-02-04 00:00:00
100 percent done.
File created: /home/gbasedbt/backup/gbase_232_L0
Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:
8
Program over.
[gbasedbt@gbase backup]$ ls -lrt
total 35520
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
创建增量数据
insert into t_employee values (11, 1, 'employee_11');
insert into t_employee values (12, 1, 'employee_12');
insert into t_employee values (13, 2, 'employee_13');
insert into t_employee values (14, 2, 'employee_14');
insert into t_employee values (15, 3, 'employee_15');
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_11
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
10 row(s) retrieved.
L1备份
[gbasedbt@gbase backup]$ ontape -s -L 1
\Your evaluation license will expire on 2024-02-04 00:00:00
100 percent done.
File created: /home/gbasedbt/backup/gbase_232_L1
Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:
8
Program over.
[gbasedbt@gbase backup]$ ls -lrt
total 41120
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_L1
再次执行L1备份
[gbasedbt@gbase backup]$ ontape -s -L 1
Your evaluation license will expire on 2024-02-04 00:00:00
100 percent done.
File created: /home/gbasedbt/backup/gbase_232_L1
Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:
8
Program over.
[gbasedbt@gbase backup]$ ls -lrt
total 46720
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_20230216_094943_L1
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:52 gbase_232_L1
GBase 8s最后一次的备份文件名为
再次创建增量数据
insert into t_employee values (21, 1, 'employee_21');
insert into t_employee values (22, 1, 'employee_22');
insert into t_employee values (23, 2, 'employee_23');
insert into t_employee values (24, 2, 'employee_24');
insert into t_employee values (25, 3, 'employee_25');
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_11
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
15 row(s) retrieved.
L2备份
[gbasedbt@gbase backup]$ ontape -s -L 2
Your evaluation license will expire on 2024-02-04 00:00:00
100 percent done.
File created: /home/gbasedbt/backup/gbase_232_L2
Please label this tape as number 1 in the arc tape sequence.
This tape contains the following logical logs:
8
Program over.
[gbasedbt@gbase backup]$ ls -lrt
total 52352
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_20230216_094943_L1
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:52 gbase_232_L1
-rw-rw---- 1 gbasedbt gbasedbt 5767168 Feb 16 09:54 gbase_232_L2
切换逻辑日志前的数据准备
insert into t_dept values (4, 'dept_4');
update t_employee set f_employeename = 'employee_updated' where f_employeeid = 11;
> select * from t_dept;
f_deptid f_deptname
1 dept_1
2 dept_2
3 dept_3
4 dept_4
4 row(s) retrieved.
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_updated
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
15 row(s) retrieved.
切换逻辑日志
- 当前的逻辑日志文件是5，唯一编号为8。
[gbasedbt@gbase backup]$ onstat -l Your evaluation license will expire on 2024-02-04 00:00:00 On-Line -- Up 6 days 17:33:00 -- 2171620 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 22 1024 4843 654 7.41 phybegin physize phypos phyused %used 3:53 99400 6033 36 0.04 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 512 29035 3337 1354 8.7 2.5 Subsystem numrecs Log Space used OLDRSAM 28342 4068364 HA 658 28952 DDL 35 12180 address number flags uniqid begin size used %used 49ad1f88 4 U-B---- 7 2:53 5000 5000 100.00 4adea970 5 U---C-L 8 2:5053 5000 2567 51.34 4adea9d8 6 A------ 0 2:10053 5000 0 0.00 4adeaa40 7 A------ 0 2:15053 5000 0 0.00 4adeaaa8 8 A------ 0 2:20053 5000 0 0.00 4adeab10 9 A------ 0 2:25053 5000 0 0.00 4adeab78 10 A------ 0 2:30053 5000 0 0.00 4adeabe0 11 A------ 0 2:35053 5000 0 0.00 4adeac48 12 A------ 0 2:40053 5000 0 0.00 4adeacb0 13 A------ 0 2:45053 5000 0 0.00 4adead18 14 A------ 0 2:50053 5000 0 0.00 4adead80 15 A------ 0 2:55053 5000 0 0.00 4adeade8 16 A------ 0 2:60053 5000 0 0.00 4adeae50 17 A------ 0 2:65053 5000 0 0.00 4adeaeb8 18 A------ 0 2:70053 5000 0 0.00 4adeaf20 19 A------ 0 2:75053 5000 0 0.00 4adeaf88 20 A------ 0 2:80053 5000 0 0.00 4983af30 21 A------ 0 2:85053 5000 0 0.00 4983af98 22 A------ 0 2:90053 5000 0 0.00 49909f30 23 A------ 0 2:95053 5000 0 0.00 20 active, 20 total
- 执行逻辑日志切换命令
[gbasedbt@gbase backup]$ onmode -l Your evaluation license will expire on 2024-02-04 00:00:00
- 切换后，当前逻辑日志文件为6，唯一编号为9。
[gbasedbt@gbase backup]$ onstat -l Your evaluation license will expire on 2024-02-04 00:00:00 On-Line -- Up 6 days 17:35:51 -- 2171620 Kbytes Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 1024 4865 655 7.43 phybegin physize phypos phyused %used 3:53 99400 6055 0 0.00 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-2 0 512 29038 3340 1357 8.7 2.5 Subsystem numrecs Log Space used OLDRSAM 28344 4068448 HA 659 28996 DDL 35 12180 address number flags uniqid begin size used %used 49ad1f88 4 U-B---- 7 2:53 5000 5000 100.00 4adea970 5 U-----L 8 2:5053 5000 2570 51.40 4adea9d8 6 U---C-- 9 2:10053 5000 0 0.00 4adeaa40 7 A------ 0 2:15053 5000 0 0.00 4adeaaa8 8 A------ 0 2:20053 5000 0 0.00 4adeab10 9 A------ 0 2:25053 5000 0 0.00 4adeab78 10 A------ 0 2:30053 5000 0 0.00 4adeabe0 11 A------ 0 2:35053 5000 0 0.00 4adeac48 12 A------ 0 2:40053 5000 0 0.00 4adeacb0 13 A------ 0 2:45053 5000 0 0.00 4adead18 14 A------ 0 2:50053 5000 0 0.00 4adead80 15 A------ 0 2:55053 5000 0 0.00 4adeade8 16 A------ 0 2:60053 5000 0 0.00 4adeae50 17 A------ 0 2:65053 5000 0 0.00 4adeaeb8 18 A------ 0 2:70053 5000 0 0.00 4adeaf20 19 A------ 0 2:75053 5000 0 0.00 4adeaf88 20 A------ 0 2:80053 5000 0 0.00 4983af30 21 A------ 0 2:85053 5000 0 0.00 4983af98 22 A------ 0 2:90053 5000 0 0.00 49909f30 23 A------ 0 2:95053 5000 0 0.00 20 active, 20 total
灾难前的最后一次数据变更
> delete from t_employee where f_employeeid = 14;
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_updated
12 1 employee_12
13 2 employee_13
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
14 row(s) retrieved.
> select * from t_dept;
f_deptid f_deptname
1 dept_1
2 dept_2
3 dept_3
4 dept_4
4 row(s) retrieved.
模拟灾难发生
[gbasedbt@gbase backup]$ cd /opt/gbase/gbs_dbs/
[gbasedbt@gbase gbs_dbs]$ ls -lrt
total 1536000
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 9 16:27 sbspace1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 9 16:27 datadbs4_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 9 16:27 datadbs3_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 9 16:27 datadbs2_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 9 16:27 datadbs5_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 09:54 tmpdbs3
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 09:56 tmpdbs1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 09:56 tmpdbs2
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:06 rootdbs
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:06 plogdbs
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:06 datadbs1_1
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:06 llogdbs
[gbasedbt@gbase gbs_dbs]$ rm -rf datadbs1_1
- 在数据库空间文件被删除后，对t_dept表的INSERT操作可以成功
> insert into t_dept values(5, 'dept_5');
> select * from t_dept;
f_deptid f_deptname
1 dept_1
2 dept_2
3 dept_3
4 dept_4
5 dept_5
5 row(s) retrieved.
重启数据库
- 数据库报错，找不到数据文件/opt/gbase/gbs_dbs/datadbs1_1
[gbasedbt@gbase gbs_dbs]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase gbs_dbs]$ oninit -vy
Your evaluation license will expire on 2024-02-04 00:00:00
Reading configuration file '/opt/gbase/etc/onconfig.gbs'...succeeded
Creating /GBASEDBTTMP/.infxdirs...succeeded
Allocating and attaching to shared memory...succeeded
Creating resident pool 76314 kbytes...succeeded
Creating infos file "/opt/gbase/etc/.infos.gbs"...succeeded
Linking conf file "/opt/gbase/etc/.conf.gbs"...succeeded
Initializing rhead structure...rhlock_t 65536 (2048K)... rlock_t (66406K)... Writing to infos file...succeeded
Initialization of Encryption...succeeded
Initializing ASF...succeeded
Initializing Dictionary Cache and SPL Routine Cache...succeeded
Bringing up ADM VP...succeeded
Creating VP classes...succeeded
Forking main_loop thread...succeeded
Initializing DR structures...succeeded
Forking 1 'soctcp' listener threads...succeeded
Starting tracing...succeeded
Initializing 32 flushers...succeeded
Initializing SDS Server network connections...succeeded
Initializing log/checkpoint information...succeeded
Initializing dbspaces...succeeded
Opening primary chunks...oninit: Cannot open chunk '/opt/gbase/gbs_dbs/datadbs1_1'. errno = 2
succeeded
Validating chunks...succeeded
Initialize Async Log Flusher...succeeded
Starting B-tree Scanner...succeeded
Init ReadAhead Daemon...succeeded
Init DB Util Daemon...succeeded
Initializing DBSPACETEMP list...succeeded
Init Auto Tuning Daemon...succeeded
Checking database partition index...succeeded
Initializing dataskip structure...succeeded
Checking for temporary tables to drop...succeeded
Updating Global Row Counter...succeeded
Forking onmode_mon thread...succeeded
Creating periodic thread...succeeded
Creating periodic thread...succeeded
Starting scheduling system...succeeded
Verbose output complete: mode = 5
备份逻辑日志
[gbasedbt@gbase backup]$ ontape -a
Your evaluation license will expire on 2024-02-04 00:00:00
Performing automatic backup of logical logs.
File created: /home/gbasedbt/backup/gbase_232_Log0000000008
Do you want to back up the current logical log? (y/n) y
File created: /home/gbasedbt/backup/gbase_232_Log0000000009
Program over.
[gbasedbt@gbase backup]$ ls -lrt
total 57664
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_20230216_094943_L1
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:52 gbase_232_L1
-rw-rw---- 1 gbasedbt gbasedbt 5767168 Feb 16 09:54 gbase_232_L2
-rw-rw---- 1 gbasedbt gbasedbt 5341184 Feb 16 10:14 gbase_232_Log0000000008
-rw-rw---- 1 gbasedbt gbasedbt 98304 Feb 16 10:14 gbase_232_Log0000000009
- 进行逻辑日志备份时，会产生逻辑日志切换。当前的逻辑日志文件变为7，唯一编号为10。
[gbasedbt@gbase backup]$ onstat -l Your evaluation license will expire on 2024-02-04 00:00:00 On-Line (CKPT INP) -- Up 00:03:01 -- 2171620 Kbytes Blocked:OVERRIDE_DOWN_SPACE Physical Logging Buffer bufused bufsize numpages numwrits pages/io P-1 0 1024 43 1 43.00 phybegin physize phypos phyused %used 3:53 99400 6142 43 0.04 Logical Logging Buffer bufused bufsize numrecs numpages numwrits recs/pages pages/io L-3 0 512 6 2 2 3.0 1.0 Subsystem numrecs Log Space used OLDRSAM 6 340 address number flags uniqid begin size used %used 49ad1f88 4 U-B---- 7 2:53 5000 5000 100.00 4adea970 5 U-B---- 8 2:5053 5000 2570 51.40 4adea9d8 6 U-B---L 9 2:10053 5000 12 0.24 4adeaa40 7 U---C-- 10 2:15053 5000 0 0.00 4adeaaa8 8 A------ 0 2:20053 5000 0 0.00 4adeab10 9 A------ 0 2:25053 5000 0 0.00 4adeab78 10 A------ 0 2:30053 5000 0 0.00 4adeabe0 11 A------ 0 2:35053 5000 0 0.00 4adeac48 12 A------ 0 2:40053 5000 0 0.00 4adeacb0 13 A------ 0 2:45053 5000 0 0.00 4adead18 14 A------ 0 2:50053 5000 0 0.00 4adead80 15 A------ 0 2:55053 5000 0 0.00 4adeade8 16 A------ 0 2:60053 5000 0 0.00 4adeae50 17 A------ 0 2:65053 5000 0 0.00 4adeaeb8 18 A------ 0 2:70053 5000 0 0.00 4adeaf20 19 A------ 0 2:75053 5000 0 0.00 4adeaf88 20 A------ 0 2:80053 5000 0 0.00 4983af30 21 A------ 0 2:85053 5000 0 0.00 4983af98 22 A------ 0 2:90053 5000 0 0.00 49909f30 23 A------ 0 2:95053 5000 0 0.00 20 active, 20 total
恢复数据库
- 为丢失的数据库空间文件，创建一个同名的空文件，并设置好相应的权限
[gbasedbt@gbase ~]$ cd /opt/gbase/gbs_dbs/
[gbasedbt@gbase gbs_dbs]$ touch datadbs1_1
[gbasedbt@gbase gbs_dbs]$ chmod o-r datadbs1_1
[gbasedbt@gbase gbs_dbs]$ ls -lrt
total 1433600
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 sbspace1
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:12 rootdbs
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 tmpdbs3
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 tmpdbs1
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:12 plogdbs
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 datadbs5_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 datadbs4_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 datadbs3_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 datadbs2_1
-rw-rw----. 1 gbasedbt gbasedbt 104857600 Feb 16 10:12 tmpdbs2
-rw-rw----. 1 gbasedbt gbasedbt 209715200 Feb 16 10:14 llogdbs
-rw-rw---- 1 gbasedbt gbasedbt 0 Feb 16 10:18 datadbs1_1
- 关闭GBase 8s数据库实例，并进行完全恢复。
[gbasedbt@gbase gbs_dbs]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase gbs_dbs]$ ontape -r
Your evaluation license will expire on 2024-02-04 00:00:00
Restore will use level 0 archive file /home/gbasedbt/backup/gbase_232_L0. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:46:47 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 0
Tape device: /home/gbasedbt/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 [llogdbs ]
3 [plogdbs ]
4 [datadbs1 ]
5 [datadbs2 ]
6 [datadbs3 ]
7 [datadbs4 ]
8 [datadbs5 ]
9 [sbspace1 ]
Archive Information
GBase Database Server Copyright 2001, 2021 General Data Corporation
Initialization Time 02/04/2023 11:14:37
System Page Size 2048
Version 32
Index Page Logging OFF
Archive CheckPoint Time 02/16/2023 09:46:47
Dbspaces
number flags fchunk nchunks flags owner name
1 70001 1 1 N BA gbasedbt rootdbs
2 60001 2 1 N BA gbasedbt llogdbs
3 70001 3 1 N BA gbasedbt plogdbs
4 68001 4 1 N SBA gbasedbt sbspace1
5 42001 5 1 N TBA gbasedbt tmpdbs1
6 42001 6 1 N TBA gbasedbt tmpdbs2
7 42001 7 1 N TBA gbasedbt tmpdbs3
8 60001 8 1 N BA gbasedbt datadbs1
9 60001 9 1 N BA gbasedbt datadbs2
10 60001 10 1 N BA gbasedbt datadbs3
11 60001 11 1 N BA gbasedbt datadbs4
12 60001 12 1 N BA gbasedbt datadbs5
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 91506 PO-B- /opt/gbase/gbs_dbs/rootdbs
2 2 0 102400 2347 PO-B- /opt/gbase/gbs_dbs/llogdbs
3 3 0 102400 2947 PO-B- /opt/gbase/gbs_dbs/plogdbs
4 4 0 51200 2581 POSB- /opt/gbase/gbs_dbs/sbspace1
5 5 0 51200 50712 PO-B- /opt/gbase/gbs_dbs/tmpdbs1
6 6 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs2
7 7 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs3
8 8 0 51200 41832 PO-BE /opt/gbase/gbs_dbs/datadbs1_1
9 9 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs2_1
10 10 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs3_1
11 11 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs4_1
12 12 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs5_1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
File created: /home/gbasedbt/backup/gbase_232_Log0000000007
File created: /home/gbasedbt/backup/gbase_232_Log0000000008
File created: /home/gbasedbt/backup/gbase_232_Log0000000009
Log salvage is complete, continuing restore of archive.
Your evaluation license will expire on 2024-02-04 00:00:00
Restore a level 1 archive (y/n) y
Ready for level 1 tape
Restore will use level 1 archive file /home/gbasedbt/backup/gbase_232_L1. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:52:03 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 1
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Restore a level 2 archive (y/n) y
Ready for level 2 tape
Restore will use level 2 archive file /home/gbasedbt/backup/gbase_232_L2. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:54:30 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 2
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Do you want to restore log tapes? (y/n)y
Roll forward should start with log number 8
Restore will use log backup file /home/gbasedbt/backup/gbase_232_Log0000000008. Press Return to continue ...
Rollforward log file /home/gbasedbt/backup/gbase_232_Log0000000008 ...
Rollforward log file /home/gbasedbt/backup/gbase_232_Log0000000009 ...
Program over.
查看表数据
- 完全恢复后，在数据空间文件删除前的数据验证通过。即使在数据空间文件被删除后的操作成功的事务数据，也可以被完全恢复。
[gbasedbt@gbase ~]$ onstat - Your evaluation license will expire on 2024-02-04 00:00:00 Quiescent -- Up 00:02:40 -- 2632420 Kbytes [gbasedbt@gbase ~]$ onmode -m Your evaluation license will expire on 2024-02-04 00:00:00 [gbasedbt@gbase ~]$ dbaccess mydb - Your evaluation license will expire on 2024-02-04 00:00:00 Database selected. > select * from t_dept; f_deptid f_deptname 1 dept_1 2 dept_2 3 dept_3 4 dept_4 5 dept_5 5 row(s) retrieved. > select * from t_employee; f_employeeid f_deptid f_employeename 1 1 employee_01 2 1 employee_02 3 2 employee_03 4 2 employee_04 5 3 employee_05 11 1 employee_updated 12 1 employee_12 13 2 employee_13 15 3 employee_15 21 1 employee_21 22 1 employee_22 23 2 employee_23 24 2 employee_24 25 3 employee_25 14 row(s) retrieved.
检查结果：数据表完全恢复到数据库空间被删除前的状态，且在数据库空间文件被删除后新增的记录，也被正确恢复。
删除表之前的数据准备
insert into t_employee values(101, 1, 'employee_101');
insert into t_employee values(102, 1, 'employee_102');
insert into t_employee values(103, 2, 'employee_103');
insert into t_employee values(104, 2, 'employee_104');
insert into t_employee values(105, 3, 'employee_105');
> select * from t_employee;
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_updated
12 1 employee_12
13 2 employee_13
101 1 employee_101
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
102 1 employee_102
103 2 employee_103
104 2 employee_104
105 3 employee_105
19 row(s) retrieved.
此处构造的5条测试数据，由于没有基于时间点的恢复，可能在数据表被删除时，无法正确恢复。
删除t_employee数据表
drop table t_employee;
L0级物理恢复
[gbasedbt@gbase ~]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ ontape -p
Your evaluation license will expire on 2024-02-04 00:00:00
Restore will use level 0 archive file /home/gbasedbt/backup/gbase_232_L0. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:46:47 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 0
Tape device: /home/gbasedbt/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 [llogdbs ]
3 [plogdbs ]
4 [datadbs1 ]
5 [datadbs2 ]
6 [datadbs3 ]
7 [datadbs4 ]
8 [datadbs5 ]
9 [sbspace1 ]
Archive Information
GBase Database Server Copyright 2001, 2021 General Data Corporation
Initialization Time 02/04/2023 11:14:37
System Page Size 2048
Version 32
Index Page Logging OFF
Archive CheckPoint Time 02/16/2023 09:46:47
Dbspaces
number flags fchunk nchunks flags owner name
1 70001 1 1 N BA gbasedbt rootdbs
2 60001 2 1 N BA gbasedbt llogdbs
3 70001 3 1 N BA gbasedbt plogdbs
4 68001 4 1 N SBA gbasedbt sbspace1
5 42001 5 1 N TBA gbasedbt tmpdbs1
6 42001 6 1 N TBA gbasedbt tmpdbs2
7 42001 7 1 N TBA gbasedbt tmpdbs3
8 60001 8 1 N BA gbasedbt datadbs1
9 60001 9 1 N BA gbasedbt datadbs2
10 60001 10 1 N BA gbasedbt datadbs3
11 60001 11 1 N BA gbasedbt datadbs4
12 60001 12 1 N BA gbasedbt datadbs5
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 91506 PO-B- /opt/gbase/gbs_dbs/rootdbs
2 2 0 102400 2347 PO-B- /opt/gbase/gbs_dbs/llogdbs
3 3 0 102400 2947 PO-B- /opt/gbase/gbs_dbs/plogdbs
4 4 0 51200 2581 POSB- /opt/gbase/gbs_dbs/sbspace1
5 5 0 51200 50712 PO-B- /opt/gbase/gbs_dbs/tmpdbs1
6 6 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs2
7 7 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs3
8 8 0 51200 41832 PO-BE /opt/gbase/gbs_dbs/datadbs1_1
9 9 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs2_1
10 10 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs3_1
11 11 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs4_1
12 12 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs5_1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
File created: /home/gbasedbt/backup/gbase_232_Log0000000010
Log salvage is complete, continuing restore of archive.
Your evaluation license will expire on 2024-02-04 00:00:00
Restore a level 1 archive (y/n) n
Program over.
- 查看L0级物理恢复后，被删除表的恢复情况
[gbasedbt@gbase ~]$ onstat -
Your evaluation license will expire on 2024-02-04 00:00:00
Fast Recovery -- Up 00:00:48 -- 2171620 Kbytes
[gbasedbt@gbase ~]$ onmode -m
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ echo "select * from t_employee" | dbaccess mydb
Your evaluation license will expire on 2024-02-04 00:00:00
Database selected.
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
5 row(s) retrieved.
Database closed.
L1级物理恢复
[gbasedbt@gbase ~]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ ontape -p
Your evaluation license will expire on 2024-02-04 00:00:00
Restore will use level 0 archive file /home/gbasedbt/backup/gbase_232_L0. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:46:47 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 0
Tape device: /home/gbasedbt/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 [llogdbs ]
3 [plogdbs ]
4 [datadbs1 ]
5 [datadbs2 ]
6 [datadbs3 ]
7 [datadbs4 ]
8 [datadbs5 ]
9 [sbspace1 ]
Archive Information
GBase Database Server Copyright 2001, 2021 General Data Corporation
Initialization Time 02/04/2023 11:14:37
System Page Size 2048
Version 32
Index Page Logging OFF
Archive CheckPoint Time 02/16/2023 09:46:47
Dbspaces
number flags fchunk nchunks flags owner name
1 70001 1 1 N BA gbasedbt rootdbs
2 60001 2 1 N BA gbasedbt llogdbs
3 70001 3 1 N BA gbasedbt plogdbs
4 68001 4 1 N SBA gbasedbt sbspace1
5 42001 5 1 N TBA gbasedbt tmpdbs1
6 42001 6 1 N TBA gbasedbt tmpdbs2
7 42001 7 1 N TBA gbasedbt tmpdbs3
8 60001 8 1 N BA gbasedbt datadbs1
9 60001 9 1 N BA gbasedbt datadbs2
10 60001 10 1 N BA gbasedbt datadbs3
11 60001 11 1 N BA gbasedbt datadbs4
12 60001 12 1 N BA gbasedbt datadbs5
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 91506 PO-B- /opt/gbase/gbs_dbs/rootdbs
2 2 0 102400 2347 PO-B- /opt/gbase/gbs_dbs/llogdbs
3 3 0 102400 2947 PO-B- /opt/gbase/gbs_dbs/plogdbs
4 4 0 51200 2581 POSB- /opt/gbase/gbs_dbs/sbspace1
5 5 0 51200 50712 PO-B- /opt/gbase/gbs_dbs/tmpdbs1
6 6 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs2
7 7 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs3
8 8 0 51200 41832 PO-BE /opt/gbase/gbs_dbs/datadbs1_1
9 9 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs2_1
10 10 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs3_1
11 11 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs4_1
12 12 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs5_1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
No log files to salvage. Logs 8 - 8 already exists in directory /home/gbasedbt/backup/
Log salvage is complete, continuing restore of archive.
Your evaluation license will expire on 2024-02-04 00:00:00
Restore a level 1 archive (y/n) y
Ready for level 1 tape
Restore will use level 1 archive file /home/gbasedbt/backup/gbase_232_L1. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:52:03 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 1
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Restore a level 2 archive (y/n) n
Program over.
- 查看L1级物理恢复后，被删除表的恢复情况
[gbasedbt@gbase ~]$ onstat -
Your evaluation license will expire on 2024-02-04 00:00:00
Fast Recovery -- Up 00:01:00 -- 2171620 Kbytes
[gbasedbt@gbase ~]$ onmode -m
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ echo "select * from t_employee" | dbaccess mydb
Your evaluation license will expire on 2024-02-04 00:00:00
Database selected.
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_11
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
10 row(s) retrieved.
Database closed.
L2级物理恢复
[gbasedbt@gbase ~]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ ontape -p
Your evaluation license will expire on 2024-02-04 00:00:00
Restore will use level 0 archive file /home/gbasedbt/backup/gbase_232_L0. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:46:47 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 0
Tape device: /home/gbasedbt/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 [llogdbs ]
3 [plogdbs ]
4 [datadbs1 ]
5 [datadbs2 ]
6 [datadbs3 ]
7 [datadbs4 ]
8 [datadbs5 ]
9 [sbspace1 ]
Archive Information
GBase Database Server Copyright 2001, 2021 General Data Corporation
Initialization Time 02/04/2023 11:14:37
System Page Size 2048
Version 32
Index Page Logging OFF
Archive CheckPoint Time 02/16/2023 09:46:47
Dbspaces
number flags fchunk nchunks flags owner name
1 70001 1 1 N BA gbasedbt rootdbs
2 60001 2 1 N BA gbasedbt llogdbs
3 70001 3 1 N BA gbasedbt plogdbs
4 68001 4 1 N SBA gbasedbt sbspace1
5 42001 5 1 N TBA gbasedbt tmpdbs1
6 42001 6 1 N TBA gbasedbt tmpdbs2
7 42001 7 1 N TBA gbasedbt tmpdbs3
8 60001 8 1 N BA gbasedbt datadbs1
9 60001 9 1 N BA gbasedbt datadbs2
10 60001 10 1 N BA gbasedbt datadbs3
11 60001 11 1 N BA gbasedbt datadbs4
12 60001 12 1 N BA gbasedbt datadbs5
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 91506 PO-B- /opt/gbase/gbs_dbs/rootdbs
2 2 0 102400 2347 PO-B- /opt/gbase/gbs_dbs/llogdbs
3 3 0 102400 2947 PO-B- /opt/gbase/gbs_dbs/plogdbs
4 4 0 51200 2581 POSB- /opt/gbase/gbs_dbs/sbspace1
5 5 0 51200 50712 PO-B- /opt/gbase/gbs_dbs/tmpdbs1
6 6 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs2
7 7 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs3
8 8 0 51200 41832 PO-BE /opt/gbase/gbs_dbs/datadbs1_1
9 9 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs2_1
10 10 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs3_1
11 11 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs4_1
12 12 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs5_1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)y
No log files to salvage. Logs 8 - 8 already exists in directory /home/gbasedbt/backup/
Log salvage is complete, continuing restore of archive.
Your evaluation license will expire on 2024-02-04 00:00:00
Restore a level 1 archive (y/n) y
Ready for level 1 tape
Restore will use level 1 archive file /home/gbasedbt/backup/gbase_232_L1. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:52:03 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 1
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Restore a level 2 archive (y/n) y
Ready for level 2 tape
Restore will use level 2 archive file /home/gbasedbt/backup/gbase_232_L2. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:54:30 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 2
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Program over.
- 查看L2级物理恢复后，被删除表的恢复情况
[gbasedbt@gbase ~]$ onstat -
Your evaluation license will expire on 2024-02-04 00:00:00
Fast Recovery -- Up 00:01:11 -- 2171620 Kbytes
[gbasedbt@gbase ~]$ onmode -m
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase ~]$ echo "select * from t_employee" | dbaccess mydb
Your evaluation license will expire on 2024-02-04 00:00:00
Database selected.
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_11
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
15 row(s) retrieved.
Database closed.
L2级物理恢复+部分逻辑恢复
查看备份设备中的逻辑日志情况，根据实际情况，尝试移除最近的几个逻辑日志。本次演示，移除了最后2个逻辑日志。
[gbasedbt@gbase ~]$ cd backup/
[gbasedbt@gbase backup]$ ls -lrt
total 73184
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_20230216_094943_L1
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:52 gbase_232_L1
-rw-rw---- 1 gbasedbt gbasedbt 5767168 Feb 16 09:54 gbase_232_L2
-rw-rw---- 1 gbasedbt gbasedbt 5341184 Feb 16 10:14 gbase_232_20230216_101412_Log0000000008
-rw-rw---- 1 gbasedbt gbasedbt 98304 Feb 16 10:14 gbase_232_20230216_101417_Log0000000009
-rw-rw-r-- 1 gbasedbt gbasedbt 0 Feb 16 10:17 datadbs1_1
-rw-rw---- 1 gbasedbt gbasedbt 10321920 Feb 16 10:22 gbase_232_Log0000000007
-rw-rw---- 1 gbasedbt gbasedbt 5341184 Feb 16 10:22 gbase_232_Log0000000008
-rw-rw---- 1 gbasedbt gbasedbt 98304 Feb 16 10:22 gbase_232_Log0000000009
-rw-rw---- 1 gbasedbt gbasedbt 131072 Feb 16 10:32 gbase_232_Log0000000010
[gbasedbt@gbase backup]$ mkdir tmp
[gbasedbt@gbase backup]$ mv gbase_232_Log0000000009 gbase_232_Log0000000010 tmp
[gbasedbt@gbase backup]$ ls -lrt
total 72960
-rw-rw---- 1 gbasedbt gbasedbt 36372480 Feb 16 09:46 gbase_232_L0
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:49 gbase_232_20230216_094943_L1
-rw-rw---- 1 gbasedbt gbasedbt 5734400 Feb 16 09:52 gbase_232_L1
-rw-rw---- 1 gbasedbt gbasedbt 5767168 Feb 16 09:54 gbase_232_L2
-rw-rw---- 1 gbasedbt gbasedbt 5341184 Feb 16 10:14 gbase_232_20230216_101412_Log0000000008
-rw-rw---- 1 gbasedbt gbasedbt 98304 Feb 16 10:14 gbase_232_20230216_101417_Log0000000009
-rw-rw-r-- 1 gbasedbt gbasedbt 0 Feb 16 10:17 datadbs1_1
-rw-rw---- 1 gbasedbt gbasedbt 10321920 Feb 16 10:22 gbase_232_Log0000000007
-rw-rw---- 1 gbasedbt gbasedbt 5341184 Feb 16 10:22 gbase_232_Log0000000008
drwxrwxr-x 2 gbasedbt gbasedbt 68 Feb 16 10:42 tmp
进行完全恢复。
说明：虽然操作的是完全恢复，但因我们移除了部分最新的逻辑日志，实际上执行的结果是不完全恢复。
[gbasedbt@gbase backup]$ onmode -ky
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase backup]$ ontape -r
Your evaluation license will expire on 2024-02-04 00:00:00
Restore will use level 0 archive file /home/gbasedbt/backup/gbase_232_L0. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:46:47 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 0
Tape device: /home/gbasedbt/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 [llogdbs ]
3 [plogdbs ]
4 [datadbs1 ]
5 [datadbs2 ]
6 [datadbs3 ]
7 [datadbs4 ]
8 [datadbs5 ]
9 [sbspace1 ]
Archive Information
GBase Database Server Copyright 2001, 2021 General Data Corporation
Initialization Time 02/04/2023 11:14:37
System Page Size 2048
Version 32
Index Page Logging OFF
Archive CheckPoint Time 02/16/2023 09:46:47
Dbspaces
number flags fchunk nchunks flags owner name
1 70001 1 1 N BA gbasedbt rootdbs
2 60001 2 1 N BA gbasedbt llogdbs
3 70001 3 1 N BA gbasedbt plogdbs
4 68001 4 1 N SBA gbasedbt sbspace1
5 42001 5 1 N TBA gbasedbt tmpdbs1
6 42001 6 1 N TBA gbasedbt tmpdbs2
7 42001 7 1 N TBA gbasedbt tmpdbs3
8 60001 8 1 N BA gbasedbt datadbs1
9 60001 9 1 N BA gbasedbt datadbs2
10 60001 10 1 N BA gbasedbt datadbs3
11 60001 11 1 N BA gbasedbt datadbs4
12 60001 12 1 N BA gbasedbt datadbs5
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 102400 91506 PO-B- /opt/gbase/gbs_dbs/rootdbs
2 2 0 102400 2347 PO-B- /opt/gbase/gbs_dbs/llogdbs
3 3 0 102400 2947 PO-B- /opt/gbase/gbs_dbs/plogdbs
4 4 0 51200 2581 POSB- /opt/gbase/gbs_dbs/sbspace1
5 5 0 51200 50712 PO-B- /opt/gbase/gbs_dbs/tmpdbs1
6 6 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs2
7 7 0 51200 50776 PO-B- /opt/gbase/gbs_dbs/tmpdbs3
8 8 0 51200 41832 PO-BE /opt/gbase/gbs_dbs/datadbs1_1
9 9 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs2_1
10 10 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs3_1
11 11 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs4_1
12 12 0 51200 50776 PO-BE /opt/gbase/gbs_dbs/datadbs5_1
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Your evaluation license will expire on 2024-02-04 00:00:00
Restore a level 1 archive (y/n) y
Ready for level 1 tape
Restore will use level 1 archive file /home/gbasedbt/backup/gbase_232_L1. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:52:03 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 1
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Restore a level 2 archive (y/n) y
Ready for level 2 tape
Restore will use level 2 archive file /home/gbasedbt/backup/gbase_232_L2. Press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: GBase Database Server Version 12.10.FC4G1TL
Archive date: Thu Feb 16 09:54:30 2023
User id: gbasedbt
Terminal id: /dev/pts/2
Archive level: 2
Tape device: /home/gbasedbt/backup/
Tape blocksize (in k): 32
Tape size (in k): system defined for directory
Tape number in series: 1
Do you want to restore log tapes? (y/n)y
Roll forward should start with log number 8
Restore will use log backup file /home/gbasedbt/backup/gbase_232_Log0000000008. Press Return to continue ...
Rollforward log file /home/gbasedbt/backup/gbase_232_Log0000000008 ...
Program over.
- 查看L2级物理恢复+部分逻辑恢复后，被删除表的恢复情况
[gbasedbt@gbase backup]$ onstat -
Your evaluation license will expire on 2024-02-04 00:00:00
Quiescent -- Up 00:01:18 -- 2632420 Kbytes
[gbasedbt@gbase backup]$ onmode -m
Your evaluation license will expire on 2024-02-04 00:00:00
[gbasedbt@gbase backup]$ echo "select * from t_employee" | dbaccess mydb
Your evaluation license will expire on 2024-02-04 00:00:00
Database selected.
f_employeeid f_deptid f_employeename
1 1 employee_01
2 1 employee_02
3 2 employee_03
4 2 employee_04
5 3 employee_05
11 1 employee_updated
12 1 employee_12
13 2 employee_13
14 2 employee_14
15 3 employee_15
21 1 employee_21
22 1 employee_22
23 2 employee_23
24 2 employee_24
25 3 employee_25
15 row(s) retrieved.
Database closed.
虽然此处恢复的数据仍然是11行，但L2备份后，被更新的记录被恢复成功。
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
