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

2014-11-24 17:07:57 · 作者: · 浏览: 1
o 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 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\dmincord1.bak ... start restore database... start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 2 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 bak_file: C:\xcl\inc\dmincord2.bak ... start restore database... start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 2 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: 3072.867(ms) c:\dmdbms\bin>
SQL>select * from test_sch.t2; 行号 ID NAME ---------- ----------- ---- 1 0 full 2 1 inc1 3 2 inc2 已用时间: 40.276(毫秒). 执行号:3. SQL> 从测试结果来看,达梦数据库的增量备份,要基于全库备份文件进行比较来确认要增量备份哪些数据,少了这个文件就没法做后续的增量。
同时没发现关于差量相关的说明,真奇怪。