达梦(7)增量备份恢复测试 - 数据库编程

ert into test_sch.t2 values(4,'inc4'); 影响行数 1 已用时间: 0.761(毫秒). 执行号:126. SQL>select * from test_sch.t2; 行号 ID NAME ---------- ----------- ---- 1 0 full 2 1 inc1 3 2 inc2 4 3 inc3 5 4 inc4 已用时间: 0.229(毫秒). 执行号:127. SQL> 第四次增量备份:
注意:
尝试仅保留基备份全库备份文件，将其它增量备份文件移开，再去执行增量备份看看效果：

发现只剩下基备份的情况下，新的增量还是可以执行成功。

SQL>backup database increment with backupdir 'C:\xcl\inc' to dmincord4  bakfile 'C:\xcl\inc\dmincord4.bak' backupinfo '测试增量备份4' ;
	操作已执行
	已用时间: 00:00:01.768. 执行号:130.
	SQL>
	SQL>     insert into test_sch.t2 values(4,'inc5');
	影响行数 1

	已用时间: 0.470(毫秒). 执行号:131.
	SQL>    select * from test_sch.t2;

	行号       ID          NAME
	---------- ----------- ----
	1          0           full
	2          1           inc1
	3          2           inc2
	4          3           inc3
	5          4           inc5

	已用时间: 0.175(毫秒). 执行号:132.

四。删除数据库后进行恢复测试
1. 测试最后一次增量备份的恢复

c:\dmdbms\bin>dminit.exe  PATH=C:\dmdbms\data  DB_NAME=DAMENG  INSTANCE_NAME=DMSERVER
	initdb V7.1.2.215-Build(2013.11.08-36626trunc)
	db version: 0X70008
	file dm.key not found, use default license!
	create dm database success. 2014-01-16 10:31:54

	c:\dmdbms\bin>dmrestore ini_path=C:\xcl\inc\dm.ini  file=C:\xcl\inc\dmincord4.bak
	restore V7.1.2.215-Build(2013.11.08-36626trunc)
	Global parameter value of HA_OTHER_INST_PORT is illegal, use max value!

	backup DMINCORD4 info:
	backup sig:            BA
	backup tool version:   12595
	backup db name:        DAMENG
	backup db magic:       1389776595
	backup name:           DMINCORD4
	backup type:           increment
	backup level:          online
	backup range:          database
	backup description:    测试增量备份4
	compressed level:      0
	rac node:              0
	page check:            0
	length in char:        0
	backup time:           2014-01-16 10:24:34
	page size:             8 KB
	extent size:           16
	case sensitive:        1
	log page size:         512 B
	unicode flag:          0
	data version:          0x70008
	sys version:           V7.1.2.215-Build(2013.11.08-36626trunc)
	enable policy:         0
	parallel type:         0
	parallel info len:     0
	backup db fil num:     6
	archive flag:          1
	base backup LSN:       31266
	base name:             DMINCORD0FULL
	backup with log:       Yes
	before backup LSN:     31369
	after backup LSN:      31369

	file_seq   file_path                                                size(KB)
	1          C:\xcl\inc\dmincord4.bak                             16384

	file_seq   file_path                         mirror_path
	1          C:\dmdbms\data\DAMENG\SYSTEM.DBF
	2          C:\dmdbms\data\DAMENG\ROLL.DBF
	3          C:\dmdbms\data\DAMENG\MAIN.DBF
	4          C:\dmdbms\data\DAMENG\BOOKSHOP.DBF
	5          C:\dmdbms\data\DAMENG\TEST_DATA01.DBF

	Continue [Y/N]:y
	restore bak_file: C:\xcl\inc\dmincord0full.bak ...
	start restore database...
	start restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM), pages: 281
	end restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM)
	start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 366
	end restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL)
	start restore file: C:\dmdbms\data\DAMENG\MAIN.DBF(MAIN), pages: 24
	end restore file: C:\dmdbms\data\DAMENG\MAIN.DBF(MAIN)
	start restore file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBF(BOOKSHOP), pages: 133
	end restore file: C:\dmdbms\data\DAMENG\BOOKSHOP.DBF(BOOKSHOP)
	start restore file: C:\dmdbms\data\DAMENG\TEST_DATA01.DBF(TEST_DATA), pages: 10
	end restore file: C:\dmdbms\data\DAMENG\TEST_DATA01.DBF(TEST_DATA)
	end restore database data files.

	restore bak_file: C:\xcl\inc\dmincord4.bak ...
	start restore database...
	start restor

达梦(7)增量备份恢复测试(二)