達夢(mèng)數據庫手工恢復相關(guān)命令

#新建還原用數據庫

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

或

dm.ini手工編輯，ctl文件可以手工修改

利用dmctlcvt轉換工具，將dm.ctl文件轉換成txt類(lèi)型進(jìn)行修改

./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;

#修改端口號

修改端口號，通過(guò)修改  dm.ini 文件中的  PORT_NUM 選項實(shí)現

#注冊為系統服務(wù)

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

#啟動(dòng)數據庫

$DM_HOME/bin/DmServiceXXXX start