为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】:统信
【CPU】:8c16g
【问题描述】*:使用dmrman恢复数据到指定目录报错
径,在restore ,reocver的时候出现这些报错,然后进程也启动不了,
关闭进程备份,然后修改dm.ini,dm.ctl,最后启动报错
RMAN> backup database '/dameng/data/DAMENG/dm.ini' backupset '/dameng/bak/db_bak_for_map_01';
RMAN> dump backupset '/dameng/bak/db_bak_for_map_01' database '/dameng/data/DAMENG/dm.ini' mapped file '/dameng/bak/map_file_01.txt';
RMAN> restore database '/dameng/bak/data/DAMENG/dm.ini' from backupset '/dameng/bak/db_bak_for_map_01' mapped file '/dameng/bak/map_file_01.txt';
RMAN> recover database '/dameng/bak/data/DAMENG/dm.ini' from backupset '/dameng/bak/db_bak_for_map_01';
RMAN> recover database '/dameng/bak/data/DAMENG/dm.ini' update db_magic;
dm.ctl,dm.ini,这里面的参数路径都换成了新的路径/dameng/bak/data/DAMENG
[dmdba@dameng-test DAMENG]$ dmctlcvt type=1 src=/dameng/bak/data/DAMENG/dm.ctl dest=/dameng/bak/data/DAMENG/dm.ctltxt
[root@dameng-test DAMENG]# systemctl start DmServiceDMSERVER.service
Job for DmServiceDMSERVER.service failed because the control process exited with error code.
See "systemctl status DmServiceDMSERVER.service" and "journalctl -xe" for details.
[root@dameng-test DAMENG]# systemctl status DmServiceDMSERVER.service
● DmServiceDMSERVER.service - DM Instance Service
Loaded: loaded (/usr/lib/systemd/system/DmServiceDMSERVER.service; enabled; vendor preset: disabled)
Active: failed (Result: exit-code) since Mon 2024-12-02 16:01:06 CST; 47s ago
Process: 2797793 ExecStart=/dameng/dmdbms/bin/DmServiceDMSERVER start (code=exited, status=1/FAILURE)
Dec 02 16:00:50 dameng-test systemd[1]: Starting DM Instance Service...
Dec 02 16:01:06 dameng-test DmServiceDMSERVER[2797793]: [43B blob data]
Dec 02 16:01:06 dameng-test systemd[1]: DmServiceDMSERVER.service: Control process exited, code=exited, status=1/FAILURE
Dec 02 16:01:06 dameng-test systemd[1]: DmServiceDMSERVER.service: Failed with result 'exit-code'.
Dec 02 16:01:06 dameng-test systemd[1]: Failed to start DM Instance Service.
[root@dameng-test DAMENG]# journalctl -xe
最后在问下,将文本文件转换为控制文件中的type=1或者2这个是固定格式吗
1.你可以新创建一个实例,ini指定新的实例,备份选择你备份的目录就行
2.转换为控制文件中的type中格式是固定的
3.如果你在dm.ctl,dm.ini中修改了路径,你就无法使用服务方式启动数据库(路径已经修改,无法启动),可以前台启动数据库,或者新注册一个服务去启动