达梦数据库手工恢复相关命令

#新建还原用数据库

dminit path=/dm/dmdbms/data db_name=XX auto_overwrite=1

或

dm.ini手工编辑，ctl文件可以手工修改

利用dmctlcvt转换工具，将dm.ctl文件转换成txt类型进行修改

./dmctlcvt c2t /dm/dmdbms/data/DAMENG/dm.ctl  /dm/dmdbms/data/XXX/dmctl.txt

修改路径：

sed -i "s#/dm/dmdbms/data#/XXX#g" dmctl.txt

修改完成之后，再将dmctl.txt转换成dm.ctl格式

./dmctlcvt t2c  /dm/dmdbms/data/XXX/dmctl.txt  /dm/dmdbms/data/DAMENG/dm.ctl

#还原

RMAN> RESTORE DATABASE '/dm/dmdbms/data/XXX/dm.ini' FROM BACKUPSET' /dmback/full_test1_5236/';

#恢复

RMAN> RECOVER DATABASE '/dm/dmdbms/data/XXX/dm.ini' FROM BACKUPSET' /dmback/full_test1_5236/';

差异增量还原：

RMAN> RESTORE DATABASE '/dm/dmdbms/data/other_restore_test/dm.ini' FROM BACKUPSET '/dmback/increment_test1_5236_02' WITH BACKUPDIR '/dmback' RENAME TO 'other_restore_test';

差异增量恢复：

RMAN> RECOVER DATABASE '/dm/dmdbms/data/other_restore_test/dm.ini' FROM BACKUPSET '/dmback/increment_test1_5236_02';

累积增量还原：

RMAN> RESTORE DATABASE '/dm/dmdbms/data/other_restore_test/dm.ini' FROM BACKUPSET '/dmback/cumulative_test1_5236_01' WITH BACKUPDIR '/dmback' RENAME TO 'other_restore_test';

累积增量恢复：

RMAN> RECOVER DATABASE '/dm/dmdbms/data/other_restore_test/dm.ini' FROM BACKUPSET '/dmback/cumulative_test1_5236_01';

#更新数据库DB_MAGIC

RECOVER DATABASE '/dm/dmdbms/data/XXX/dm.in' UPDATE DB_MAGIC;

#修改端口号

修改端口号，通过修改  dm.ini 文件中的  PORT_NUM 选项实现

#注册为系统服务

$DM_HOME/scripts/root/dm_service_installer.sh -t dmserver -dm_ini /dm/dmdbms/data/XXX/dm.ini -p XXXX

#启动数据库

$DM_HOME/bin/DmServiceXXXX start