GBASE南大通用GBase 8s数据库- 备份与恢复（onbar）（2）

GBASE南大通用GBase 8s基于ON-Bar的备份与恢复实验

t_employee更新1条数据(t12)

> update t_employee set f_employeename = 'employee_updated' where f_employeeid = 11;

1 row(s) updated.

> 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         
          16           3 employee_16         
          21           1 employee_21         
          22           1 employee_22         
          23           2 employee_23         
          24           2 employee_24         
          25           3 employee_25         

16 row(s) retrieved.

> !date +'%F %T'
2021-07-30 16:35:08
> 

切换逻辑日志(t13)

[gbasedbt@devsvr ~]$ onstat -l
Your evaluation license will expire on 2022-07-30 00:00:00
On-Line -- Up 02:00:25 -- 597864 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-1  15       1024     1731       44         39.34
      phybegin         physize    phypos     phyused    %used   
      3:53             49700      1952       30         0.06    

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-2  0        512      82067      6335       400        13.0       15.8    
	Subsystem    numrecs    Log Space used
	OLDRSAM      81912      12130972      
	HA           50         2200          
	DDL          105        36540         

address          number   flags    uniqid   begin                size     used    %used
4713df88         4        U-B----  17       2:53                 5000       33     0.66
48309970         5        U---C-L  18       2:5053               5000        6     0.12
483099d8         6        U-B----  9        2:10053              5000       34     0.68
48309a40         7        U-B----  10       2:15053              5000       27     0.54
48309aa8         8        U-B----  11       2:20053              5000       41     0.82
48309b10         9        U-B----  12       2:25053              5000       30     0.60
48309b78         10       U-B----  13       2:30053              5000       36     0.72
48309be0         11       U-B----  14       2:35053              5000     2029    40.58
48309c48         12       U-B----  15       2:40053              5000       34     0.68
48309cb0         13       U-B----  16       2:45053              5000       26     0.52
 10 active, 10 total

[gbasedbt@devsvr ~]$ onmode -l
Your evaluation license will expire on 2022-07-30 00:00:00
[gbasedbt@devsvr ~]$ onstat -l
Your evaluation license will expire on 2022-07-30 00:00:00
On-Line -- Up 02:00:33 -- 597864 Kbytes

Physical Logging
Buffer bufused  bufsize  numpages   numwrits   pages/io
  P-1  15       1024     1731       44         39.34
      phybegin         physize    phypos     phyused    %used   
      3:53             49700      1952       30         0.06    

Logical Logging
Buffer bufused  bufsize  numrecs    numpages   numwrits   recs/pages pages/io
  L-3  0        512      82067      6335       400        13.0       15.8    
	Subsystem    numrecs    Log Space used
	OLDRSAM      81912      12130972      
	HA           50         2200          
	DDL          105        36540         

address          number   flags    uniqid   begin                size     used    %used
4713df88         4        U-B----  17       2:53                 5000       33     0.66
48309970         5        U-----L  18       2:5053               5000        7     0.14
483099d8         6        U---C--  19       2:10053              5000        0     0.00
48309a40         7        U-B----  10       2:15053              5000       27     0.54
48309aa8         8        U-B----  11       2:20053              5000       41     0.82
48309b10         9        U-B----  12       2:25053              5000       30     0.60
48309b78         10       U-B----  13       2:30053              5000       36     0.72
48309be0         11       U-B----  14       2:35053              5000     2029    40.58
48309c48         12       U-B----  15       2:40053              5000       34     0.68
48309cb0         13       U-B----  16       2:45053              5000       26     0.52
 10 active, 10 total

[gbasedbt@devsvr ~]$ 

切换逻辑日志后，当前逻辑日志唯一编号由18变为19。

t_employee删除1条数据(t14)

> delete from t_employee where f_employeeid = 14;

1 row(s) deleted.

> 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         
          16           3 employee_16         
          21           1 employee_21         
          22           1 employee_22         
          23           2 employee_23         
          24           2 employee_24         
          25           3 employee_25         

15 row(s) retrieved.

> !date +'%F %T'
2021-07-30 16:38:10
> 

删除Chunk文件(t15)

[gbasedbt@devsvr ~]$ cd /opt/gbase/gbaseserver_dbs/
[gbased