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

e file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM), pages: 1 end restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM) start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 8 end restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL) start restore file: C:\dmdbms\data\DAMENG\TEST_DATA01.DBF(TEST_DATA), pages: 3 end restore file: C:\dmdbms\data\DAMENG\TEST_DATA01.DBF(TEST_DATA) end restore database data files. restore finished, code = 0! restore successfully! restore time used: 2514.679(ms) c:\dmdbms\bin> SQL>select * from test_sch.t2; 行号 ID NAME ---------- ----------- ---- 1 0 full 2 1 inc1 3 2 inc2 4 3 inc3 已用时间: 56.357(毫秒). 执行号:3. SQL> 2. 在备份集目录，删除基备份，测试第二次增量备份的恢复
测试流程如下:
2.1 初始化库
dminit.exe PATH=C:\dmdbms\data DB_NAME=DAMENG INSTANCE_NAME=DMSERVER
2.2 移开基备份dmincord0full.bak
2.3 执行恢复命令

dmrestore ini_path=C:\xcl\inc\dm.ini file=C:\xcl\inc\dmincord2.bak
结果提示"无基备份,restore error code : -8036"
2.4 把基备份还原回去，再执行恢复命令，还原成功。

执行过程:

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:35:34

	c:\dmdbms\bin>dmrestore ini_path=C:\xcl\inc\dm.ini  file=C:\xcl\inc\dmincord2.bak
	restore V7.1.2.215-Build(2013.11.08-36626trunc)

	backup DMINCORD2 info:
	backup sig:            BA
	backup tool version:   12595
	backup db name:        DAMENG
	backup db magic:       1389776595
	backup name:           DMINCORD2
	backup type:           increment
	backup level:          online
	backup range:          database
	backup description:    测试增量备份2
	compressed level:      0
	rac node:              0
	page check:            0
	length in char:        0
	backup time:           2014-01-16 10:01:15
	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:       31272
	base name:             DMINCORD1
	backup with log:       Yes
	before backup LSN:     31278
	after backup LSN:      31278

	file_seq   file_path                                                size(KB)
	1          C:\xcl\inc\dmincord2.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 error code : -8036

	c:\dmdbms\bin>

	c:\dmdbms\bin> dmrestore ini_path=C:\xcl\inc\dm.ini  file=C:\xcl\inc\dmincord2.bak
	restore V7.1.2.215-Build(2013.11.08-36626trunc)

	backup DMINCORD2 info:
	backup sig:            BA
	backup tool version:   12595
	backup db name:        DAMENG
	backup db magic:       1389776595
	backup name:           DMINCORD2
	backup type:           increment
	backup level:          online
	backup range:          database
	backup description:    测试增量备份2
	compressed level:      0
	rac node:              0
	page check:            0
	length in char:        0
	backup time:           2014-01-16 10:01:15
	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 inf

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