LSN 还原到指定的LSN
LOG 还原的日志输出文件
HELP 打印帮助信息
然后，发现要保留下面文件，然后运行恢复命令才能恢复出来，否则老是提示少文件，这个和Oracle之类还真不一样。
就是说能删的只有 BOOKSHOP.DBF DAMENG目录 trace目录 arch目录
这有啥用？
删得只剩下这些文件，少一个恢复时都会报错，文档没解释，真不解
C:\dmdbms\data\DAMENG>dir
驱动器 C 中的卷是 OS
卷的序列号是 C8C0-48C4
C:\dmdbms\data\DAMENG 的目录
2014/01/07 16:43 .
2014/01/07 16:43 ..
2014/01/07 16:01 67,108,864 DAMENG01.log
2014/01/07 16:01 67,108,864 DAMENG02.log
2014/01/03 10:51 5,632 dm.ctl
2014/01/03 15:02 22,214 dm.ini
2014/01/04 10:48 127 dmarch.ini
2014/01/03 10:50 633 dm_service.prikey
2014/01/07 16:01 10,485,760 SYSTEM.DBF
7 个文件 144,732,094 字节
2 个目录 65,555,996,672 可用字节
执行恢复
C:\dmdbms\data\DAMENG>C:\dmdbms\bin\dmrestore.exe INI_PATH=C:\dmdbms\data\DAMENG\dm.ini file=C:\dmtest\dmcold.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 DMSERVER10 info:
backup sig: BA
backup tool version: 12595
backup db name: DAMENG
backup db magic: 1388717456
backup name: DMSERVER10
backup type: full
backup level: offline
backup range: database
backup description:
compressed level: 0
rac node: 0
page check: 0
length in char: 0
backup time: 2014-01-07 14:34:20
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: 4
archive flag: 1
after backup LSN: 25337
file_seq file_path size(KB)
1 C:\dmtest\dmcold.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
Continue [Y/N]:y
restore bak_file: C:\dmtest\dmcold.bak ...
start restore database...
start restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM), pages: 278
end restore file: C:\dmdbms\data\DAMENG\SYSTEM.DBF(SYSTEM)
start restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL), pages: 617
end restore file: C:\dmdbms\data\DAMENG\ROLL.DBF(ROLL)
start restore file: C:\dmdbms\data\DAMENG\MAIN.DBF(MAIN), pages: 4
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)
end restore database data files.
restore finished, code = 0!
restore successfully!
restore time used: 3654.514(ms)
恢复成功后
C:\dmdbms\data\DAMENG>dir
驱动器 C 中的卷是 OS
卷的序列号是 C8C0-48C4
C:\dmdbms\data\DAMENG 的目录
2014/01/07 16:44 .
2014/01/07 16:44 ..
2014/01/07 16:44 157,286,400 BOOKSHOP.DBF
2014/01/07 16:44 67,108,864 DAMENG01.log
2014/01/07 16:44 67,108,864 DAMENG02.log
2014/01/07 16:44 5,632 dm.ctl
2014/01/07 16:44 22,214 dm.ini
2014/01/04 10:48 127 dmarch.ini
2014/01/07 16:44 156 dminst.sys
2014/01/07 16:44 2,131 dmrestore.log
2014/01/07 16:44 633 dm_service.prikey
2014/01/07 16:44 134,217,728 MAIN.DBF
2014/01/07 16:44 134,217,728 ROLL.DBF
2014/01/07 16:44 10,485,760 SYSTEM.DBF
2014/01/07 16:44 10,485,760 TEMP.DBF
13 个文件 580,941,997 字节
2 个目录 65,117,458,432 可用字节