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

#新建还原用数据库

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


请使用浏览器的分享功能分享到微信等