SUNDB使用增量备份恢复控制文件与数据文件

使用已备份的控制文件和数据文件完成恢复即可，已提交的数据不会丢失。
Step 1：备份前加载测试表及数据

gSQL> CREATE TABLE INC_TEST ( C1 INT, C2 DATE, C3 VARCHAR(50) );
gSQL> INSERT INTO INC_TEST VALUES (1, sysdate, 'INCREMENTAL BACKUP TEST');
gSQL> COMMIT;

Step 2：执行增量备份

gSQL> ALTER DATABASE BACKUP INCREMENTAL LEVEL 0;

Database altered.
gSQL> !ls /home/sunje/product/Sundb_data/backup
controlD20200203T144136L0S2.inc  databaseD20200203T144136L0S2.inc  README

Step 3：切换6次联机日志（redofile）产生归档文件，模拟生产环境（该步骤可选）

gSQL> ALTER SYSTEM SWITCH LOGFILE; 
--执行6次或多次

Step 4：再向测试表中插入2条数据

gSQL> INSERT INTO INC_TEST VALUES (2, sysdate, 'INCREMENTAL BACKUP TEST');
gSQL> COMMIT;
gSQL> INSERT INTO INC_TEST VALUES (3, sysdate, 'INCREMENTAL BACKUP TEST');

Step 5：模拟服务异常终止

gSQL> shutdown abort

Step 6：删除控制文件与数据文件

[sunje@gs01 Sundb_data]$ pwd
/home/sunje/product/Sundb_data
[sunje@gs01 Sundb_data]$ rm -f wal/*.ctl
[sunje@gs01 Sundb_data]$ rm -f db/*.dbf

Step 7：恢复控制文件（NOMOUNT）

[sunje@gs01 backup]$ gs
gSQL> startup nomount
gSQL> ALTER DATABASE RESTORE CONTROLFILE FROM '/home/sunje/product/Sundb_data/backup/controlD20200203T144136L0S2.inc';

Step 8：启动并恢复实例

gSQL> ALTER SYSTEM MOUNT DATABASE;

System altered.

gSQL> ALTER DATABASE RESTORE;

Database altered.

gSQL> ALTER DATABASE BEGIN INCOMPLETE RECOVERY;

ERR-01000(14104): Warning: suggestion '/home/sunje/product/Sundb_data/archive_log/archive_0.log'
ERR-01000(14103): Warning: media recovery needs a logfile including log (Lsn 179151)
Database altered.

gSQL> ALTER DATABASE RECOVER AUTOMATICALLY;

ERR-01000(14104): Warning: suggestion '/home/sunje/product/Sundb_data/archive_log/archive_3.log'
ERR-01000(14103): Warning: media recovery needs a logfile including log (Lsn 179161)
Database altered.

gSQL> ALTER DATABASE END INCOMPLETE RECOVERY;

Database altered.

gSQL> ALTER SYSTEM OPEN DATABASE RESETLOGS;

System altered.

Step 9：查看INC_TEST表的数据

gSQL> SELECT * FROM INC_TEST;

C1 C2         C3                     
-- ---------- -----------------------
 1 2020-02-03 INCREMENTAL BACKUP TEST
 2 2020-02-03 INCREMENTAL BACKUP TEST

2 rows selected.

已提交数据为2条，当前查询所得数据为2条，测试结果与预期一致，完成恢复。