# dm **Repository Path**: ckorig/dm-ops ## Basic Information - **Project Name**: dm - **Description**: 达梦数据库 - **Primary Language**: Shell - **License**: MulanPSL-2.0 - **Default Branch**: master - **Homepage**: None - **GVP Project**: No ## Statistics - **Stars**: 0 - **Forks**: 0 - **Created**: 2025-06-04 - **Last Updated**: 2025-11-18 ## Categories & Tags **Categories**: Uncategorized **Tags**: None ## README # dm 8.4 #### 介绍 达梦数据库 8.4 auto_setup #### 安装教程 1. 自动化脚本使用(目录分布情况) ``` [root@dmiris dmdba]# tree -L 2 . ├── dmdata │ ├── DAMENG │ └── sqllog └── dmdbms ├── bin ├── bin2 ├── desktop ├── doc ├── drivers ├── include ├── jar ├── jdk ├── license_chs.txt ├── license_cht.txt ├── license_en.txt ├── log ├── samples ├── script ├── tool ├── uninstall └── uninstall.sh 17 directories, 4 files [root@dmiris dmdba]# pwd /home/dmdba ``` 2. 脚本及 iso 存放路径 ``` [root@dmiris dmdba]# cd /data/ [root@dmiris data]# ls -l 总用量 1176664 drwxr-xr-x 2 dmdba dinstall 4096 11月 17 17:11 AutoInit_DM8_examples -rwxrwxrwx 1 dmdba dinstall 0 11月 17 17:22 AutoInit_DM8_opt.sql -rw-r--r-- 1 dmdba dinstall 166788 11月 17 17:16 AutoInit_DM8.sh -rw-r--r-- 1 dmdba dinstall 29286 11月 17 17:27 DBCheck.sh -rwxrwxr-x 1 dmdba dinstall 1106878464 11月 17 15:44 dm8_20240621_x86_kylin10_64.iso drwxrwxr-x 2 dmdba dinstall 30 12月 30 2024 dm8-x86-linux-企业版2025.12.25 -rwxrwxr-x 1 dmdba dinstall 1254 11月 17 15:55 dm8-x86-linux-企业版2025.12.25.zip drwxr-xr-x 4 dmdba dinstall 102 11月 17 17:37 dmbak drwxr-xr-x 3 dmdba dinstall 142 11月 17 17:27 DMTMPDIR drwxr-xr-x 2 dmdba dinstall 58 11月 17 17:13 temp ``` 3. 修改 AutoInit_DM8.sh 相关配置 ``` sh AutoInit_DM8.sh -st 1 ``` 4. 检测通过后的一键安装 ``` sh AutoInit_DM8.sh -st 2 ``` ## 物理备份还原操作 ``` 数据备份路径 [root@dmiris ~]# ls -l /data/dmbak/ 总用量 4 drwxr-xr-x 4 itops itops 179 11月 17 17:36 DB_iris_FULL_2025_11_08_23_00_23 drwxr-xr-x 6 itops itops 4096 11月 17 17:38 DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30 数据还原操作 进入 dmdba 的家目录 下： [dmdba@dmiris bin]$ ./DmServiceDMSERVER stop Stopping DmServiceDMSERVER: [ OK ] [dmdba@dmiris bin]$ ps -ef | grep dmdba dmdba 39415 1 0 11月17 ? 00:00:01 /home/dmdba/dmdbms/bin/dmap root 40281 2972 0 11月17 pts/0 00:00:00 su - dmdba dmdba 40286 40281 0 11月17 pts/0 00:00:00 -bash dmdba 42256 40286 0 01:12 pts/0 00:00:00 ps -ef dmdba 42257 40286 0 01:12 pts/0 00:00:00 grep dmdba [dmdba@dmiris bin]$ **./dmrman** dmrman V8 RMAN> restore database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; restore database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL [Percent:100.00%][Speed:0.00M/s][Cost:00:02:23][Remaining:00:00:00] restore successfully. time used: 00:02:23.903 RMAN> recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/home/dmdba/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/home/dmdba/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; Database mode = 2, oguid = 0 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL EP[0]'s cur_lsn[484130252], file_lsn[484130252] # 指定路径错误 [-10001]:[错误码:-127]无效的备份集目录[/home/dmdba/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30] RMAN> recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; Database mode = 2, oguid = 0 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL EP[0]'s cur_lsn[484130252], file_lsn[484130252] # 目录无权限导致 os_file_create error! desc: Permission denied, code: 13, path: /data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30/RES2_TMP_ARCH_0x4E545AE_EP0_2025-11-18_01-18-15.log [-8363]:从备份集生成临时日志文件失败 RMAN> recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; recover database '/home/dmdba/dmdata/DAMENG/dm.ini' from backupset '/data/dmbak/DB_iris_INCREMENT_CUMULATIVE_2025_11_14_23_00_30'; Database mode = 2, oguid = 0 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL EP[0]'s cur_lsn[484130252], file_lsn[484130252] [Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00] recover successfully! time used: 00:00:02.545 RMAN> recover database '/home/dmdba/dmdata/DAMENG/dm.ini' update db_magic; recover database '/home/dmdba/dmdata/DAMENG/dm.ini' update db_magic; Database mode = 2, oguid = 0 Normal of FAST Normal of DEFAULT Normal of RECYCLE Normal of KEEP Normal of ROLL EP[0]'s cur_lsn[484130301], file_lsn[484130301] recover successfully! time used: 00:00:01.117 数据库启动与验证 RMAN> exit time used: 0.768(ms) [dmdba@dmiris bin]$ ./DmServiceDMSERVER start Starting DmServiceDMSERVER: [ OK ] [dmdba@dmiris bin]$ lsof -i:5236 COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME dmserver 42574 dmdba 5u IPv6 185811 0t0 TCP *:padl2sim (LISTEN) [dmdba@dmiris bin]$ disql disql V8 用户名: 密码: 服务器[LOCALHOST:5236]:处于普通打开状态 登录使用时间 : 9.966(ms) SQL> ``` #### 参与贡献