1.环境描述
服务器系统:CentOS Linux 7.6
达梦数据库:DM V8.1
远程工具:CRT
2.备份数据准备
还原数据的前提是有备份数据,我的第一篇文章就写过如何备份,请移步查看备份步骤去备份流程页面。
找到备份数据,放到你喜欢的地方,我喜欢放到/home下。
备份数据:DB_DAMENG_FULL_2022_05_11_14_51_26
3.流程
首先,新建文件夹,并赋予权限
[root@localhost home]# mkdir dmbak
[root@localhost home]# chmod 777 /home/dmbak/
[root@localhost home]# chown dmdba:dinstall -R /home/dmbak/
进入达梦数据库的bin目录下
[root@localhost home]# cd /home/dmdba/dmdbms/bin
查看数据库服务是否启动, 如果启动了,需要停止
[dmdba@localhost bin]$ ./DmServiceDMSERVER02 status
查看状态
[dmdba@localhost bin]$ ./DmServiceDMSERVER02 stop
停止服务后初始化实例
[root@localhost bin]# ./dminit path=/home/dmbak page_size=32 extent_size=32 charset=1 case_sensitive=0 port_num=5276
出现下面内容创建实例成功
db version: 0x7000c
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
log file path: /home/dmbak/DAMENG/DAMENG01.log
log file path: /home/dmbak/DAMENG/DAMENG02.log
write to dir [/home/dmbak/DAMENG].
create dm database success. 2022-06-14 11:25:53
此处初始化了一个5276端口的数据库实例,然后开始三条代码的备份
[root@localhost bin]# ./dmrman CTLSTMT="RESTORE DATABASE '/home/dmbak/DAMENG/dm.ini' FROM BACKUPSET '/home/DB_DAMENG_FULL_2022_05_11_14_51_26'"
出现下面内容表示备份第一步成功
dmrman V8
RESTORE DATABASE '/home/dmbak/DAMENG/dm.ini' FROM BACKUPSET '/home/DB_DAMENG_FULL_2022_05_11_14_51_26'
os_file_open_normal_rw error! path: '/home/dmbak/DAMENG/ctl_bak/dm_20220614112803_433315.ctl', code: 13, desc: Permission denied
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
os_file_open_low_real at (/home/test/xzq/trunk8_rel_2109/bak2/res2.c: 1940) error! desc: Permission denied, path: /home/dmbak/DAMENG/DAMENG01.log, code: 13
os_file_open_low_real at (/home/test/xzq/trunk8_rel_2109/bak2/res2.c: 1940) error! desc: Permission denied, path: /home/dmbak/DAMENG/DAMENG02.log, code: 13
[Percent:99.83%][Speed:0.00M/s][Cost:00:00:04][Remaining:00:00:00]os_file_open_normal_rw error! path: '/home/dmbak/DAMENG/ctl_bak/d