DM8读写分离搭建_redirecting to start dmservicedmservice.service-CSDN博客

本文链接：https://blog.csdn.net/weixin_39036491/article/details/131526614

IP 地址初始状态操作系统

192.168.176.121 192.168.0.141   主库 GRP1_RWW_01
192.168.176.122 192.168.0.142   备库 GRP1_RWW_02
192.168.176.123 192.168.0.143   备库 GRP1_RWW_03

1、创建相关用户组
[root@localhost opt]# groupadd dinstall
[root@localhost opt]# useradd -g dinstall -m -d /home/dmdba -s /bin/bash dmdba
[root@localhost opt]# passwd dmdba
Changing password for user dmdba.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.

2、修改配置
vi /etc/security/limits.conf
dmdba soft data unlimited
dmdba hard data unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nofile 65536
dmdba hard nofile 65536

3、创建相关目录
[root@localhost opt]# mkdir /dm8
[root@localhost opt]# chown -R dmdba:dinstall /dm8
[root@localhost opt]# chmod -R 775 /dm8

4、上传安装包并解压
[root@localhost opt]# unzip dm8_20220720_x86_rh7_64_ent.zip

5、挂载
[root@localhost opt]# mount -o loop /opt/dm8_20220720_x86_rh7_64_ent_8.1.2.114_pack11.iso /mnt
mount: /dev/loop0 is write-protected, mounting read-only

6、安装并创建数据库
[root@localhost opt]# su - dmdba
[dmdba@localhost ~]$ cd /mnt
[dmdba@localhost mnt]$ ./DMInstall.bin -i
Please select the installers language (E/e:English C/c:Chinese) [E/e]:c
解压安装程序.........
欢迎使用达梦数据库安装程序

是否输入Key文件路径? (Y/y:是 N/n:否) [Y/y]:n

是否设置时区? (Y/y:是 N/n:否) [Y/y]:y
设置时区:
[ 1]: GTM-12=日界线西
[ 2]: GTM-11=萨摩亚群岛
[ 3]: GTM-10=夏威夷
[ 4]: GTM-09=阿拉斯加
[ 5]: GTM-08=太平洋时间（美国和加拿大）
[ 6]: GTM-07=亚利桑那
[ 7]: GTM-06=中部时间（美国和加拿大）
[ 8]: GTM-05=东部部时间（美国和加拿大）
[ 9]: GTM-04=大西洋时间（美国和加拿大）
[10]: GTM-03=巴西利亚
[11]: GTM-02=中大西洋
[12]: GTM-01=亚速尔群岛
[13]: GTM=格林威治标准时间
[14]: GTM+01=萨拉热窝
[15]: GTM+02=开罗
[16]: GTM+03=莫斯科
[17]: GTM+04=阿布扎比
[18]: GTM+05=伊斯兰堡
[19]: GTM+06=达卡
[20]: GTM+07=曼谷，河内
[21]: GTM+08=中国标准时间
[22]: GTM+09=汉城
[23]: GTM+10=关岛
[24]: GTM+11=所罗门群岛
[25]: GTM+12=斐济
[26]: GTM+13=努库阿勒法
[27]: GTM+14=基里巴斯
请选择设置时区 [21]:21

安装类型:
1 典型安装
2 服务器
3 客户端
4 自定义
请选择安装类型的数字序号 [1 典型安装]:
所需空间: 1611M

请选择安装目录 [/home/dmdba/dmdbms]:/dm8
可用空间: 10G
是否确认安装路径(/dm8)? (Y/y:是 N/n:否) [Y/y]:y

安装前小结
安装位置: /dm8
所需空间: 1611M
可用空间: 10G
版本信息:
有效日期:
安装类型: 典型安装
是否确认安装? (Y/y:是 N/n:否):y
2023-07-04 02:29:08
[INFO] 安装达梦数据库...
2023-07-04 02:29:08
[INFO] 安装基础模块...
2023-07-04 02:29:18
[INFO] 安装服务器模块...
2023-07-04 02:29:20
[INFO] 安装客户端模块...
2023-07-04 02:29:34
[INFO] 安装驱动模块...
2023-07-04 02:29:43
[INFO] 安装手册模块...
2023-07-04 02:29:44
[INFO] 安装服务模块...
2023-07-04 02:29:46
[INFO] 移动日志文件。
2023-07-04 02:29:47
[INFO] 安装达梦数据库完成。

请以root系统用户执行命令:
/dm8/script/root/root_installer.sh

安装结束

[dmdba@localhost mnt]$ exit
logout
[root@localhost opt]# /dm8/script/root/root_installer.sh
移动 /dm8/bin/dm_svc.conf 到/etc目录
修改服务器权限
创建DmAPService服务
Created symlink from /etc/systemd/system/multi-user.target.wants/DmAPService.service to /usr/lib/systemd/system/DmAPService.service.
创建服务(DmAPService)完成
启动DmAPService服务

7、初始化库目录
DW_P 机器上初始化库至目录/dm8/data：
[dmdba@localhost bin]$ ./dminit PATH=/dm8/data/
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire in 16 day(s) on 2023-07-20
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL

log file path: /dm8/data/DAMENG/DAMENG01.log

log file path: /dm8/data/DAMENG/DAMENG02.log

write to dir [/dm8/data/DAMENG].
create dm database success. 2023-07-04 02:40:34

8、调整主库参数并开启归档
[dmdba@localhost DAMENG]$ cd /dm8/data/DAMENG
[dmdba@localhost DAMENG]$ vi dm.ini

ARCH_INI = 1 ##打开归档配置

[dmdba@localhost DAMENG]$ vi dmarch.ini
[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL ##本地归档类型

ARCH_DEST = /dm8/data/DAMENG/arch ##本地归档文件存放路径

ARCH_FILE_SIZE = 128 ##单位Mb，本地单个归档文件最大值

ARCH_SPACE_LIMIT = 0 ##单位Mb，0表示无限制，范围1024~2147483647M

9、注册主库服务
[root@localhost opt]# /dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DAMENG/dm.ini -p DMSERVER
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service to /usr/lib/systemd/system/DmServiceDMSERVER.service.
创建服务(DmServiceDMSERVER)完成

10、开启主库并备份
[root@localhost opt]# service DmServiceDMSERVER start
Redirecting to /bin/systemctl start DmServiceDMSERVER.service

[root@localhost opt]# su - dmdba
[dmdba@localhost dm8]$ cd bin
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA
服务器[LOCALHOST:5236]:处于普通打开状态
登录使用时间 : 24.518(ms)
disql V8
SQL> BACKUP DATABASE BACKUPSET '/dm8/data/DAMENG/BACKUP_FILE_01';
操作已执行
已用时间: 00:00:03.313. 执行号:55300.

11、传输备份到备库
[dmdba@localhost DAMENG]$ scp -r BACKUP_FILE_01/ dmdba@192.168.176.122:/dm8
The authenticity of host '192.168.176.122 (192.168.176.122)' can't be established.
ECDSA key fingerprint is SHA256:i/LUcpVJT0Bff5H3LWupQeV7r2Sd2D7vitdiBlVSzXU.
ECDSA key fingerprint is MD5:c7:f1:5e:9a:70:ab:77:9d:eb:8a:da:ae:4a:da:dc:5a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.176.122' (ECDSA) to the list of known hosts.
dmdba@192.168.176.122's password:
BACKUP_FILE_01.bak 100% 16MB 85.5MB/s 00:00
BACKUP_FILE_01_1.bak 100% 44KB 5.3MB/s 00:00
BACKUP_FILE_01.meta 100% 89KB 9.6MB/s 00:00
[dmdba@localhost DAMENG]$

[dmdba@localhost DAMENG]$ scp -r BACKUP_FILE_01/ dmdba@192.168.176.123:/dm8
The authenticity of host '192.168.176.123 (192.168.176.123)' can't be established.
ECDSA key fingerprint is SHA256:i/LUcpVJT0Bff5H3LWupQeV7r2Sd2D7vitdiBlVSzXU.
ECDSA key fingerprint is MD5:c7:f1:5e:9a:70:ab:77:9d:eb:8a:da:ae:4a:da:dc:5a.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '192.168.176.123' (ECDSA) to the list of known hosts.
dmdba@192.168.176.123's password:
BACKUP_FILE_01.bak 100% 16MB 111.4MB/s 00:00
BACKUP_FILE_01_1.bak 100% 44KB 5.2MB/s 00:00
BACKUP_FILE_01.meta 100% 89KB 13.4MB/s 00:00
[dmdba@localhost DAMENG]$

12、关闭主库
[dmdba@localhost bin]$ service DmServiceDMSERVER stop
Redirecting to /bin/systemctl stop DmServiceDMSERVER.service
==== AUTHENTICATING FOR org.freedesktop.systemd1.manage-units ===
Authentication is required to manage system services or units.
Authenticating as: root
Password:
==== AUTHENTICATION COMPLETE ===
[dmdba@localhost bin]$

[root@localhost ~]# service DmServiceDMSERVER stop
Redirecting to /bin/systemctl stop DmServiceDMSERVER.service

13、初始化备库
[root@localhost bin]# ./dminit path=/dm8/data
initdb V8
db version: 0x7000c
file dm.key not found, use default license!
License will expire in 16 day(s) on 2023-07-20
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL

log file path: /dm8/data/DAMENG/DAMENG01.log

log file path: /dm8/data/DAMENG/DAMENG02.log

write to dir [/dm8/data/DAMENG].
create dm database success. 2023-07-04 03:05:10

14、恢复备库
[dmdba@localhost bin]$ ./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/BACKUP_FILE_01'"
dmrman V8
RESTORE DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/BACKUP_FILE_01'
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
[Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.668

[dmdba@localhost bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/BACKUP_FILE_01'"
dmrman V8
RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' FROM BACKUPSET '/dm8/BACKUP_FILE_01'
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]s cur_lsn[36310], file_lsn[36310]
[Percent:100.00%][Speed:0.00PKG/s][Cost:00:00:00][Remaining:00:00:00]
recover successfully!
time used: 00:00:02.475

[dmdba@localhost bin]$ ./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' UPDATE DB_MAGIC"
dmrman V8
RECOVER DATABASE '/dm8/data/DAMENG/dm.ini' UPDATE DB_MAGIC
file dm.key not found, use default license!
Database mode = 0, oguid = 0
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]s cur_lsn[36393], file_lsn[36393]
recover successfully!
time used: 00:00:01.039
[dmdba@localhost bin]$

15、注册备库服务
[root@localhost root]# /dm8/script/root/dm_service_installer.sh -t dmserver -dm_ini /dm8/data/DAMENG/dm.ini -p DMSERVER
Created symlink from /etc/systemd/system/multi-user.target.wants/DmServiceDMSERVER.service to /usr/lib/systemd/system/DmServiceDMSERVER.service.
创建服务(DmServiceDMSERVER)完成

16、配置主库 GRP1_RWW_01
dm.ini参数

INSTANCE_NAME = GRP1_RWW_01
PORT_NUM = 5236 #数据库实例监听端口
DW_INACTIVE_INTERVAL = 60 #接收守护进程消息超时时间
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID
ENABLE_OFFLINE_TS = 2 #不允许备库OFFLINE表空间
MAL_INI = 1 #打开MAL系统
ARCH_INI = 1 #打开归档配置
RLOG_SEND_APPLY_MON = 64 #统计最近64次的日志发送信息

配置dmmal.ini
[dmdba@localhost DAMENG]$ vi dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = GRP1_RWW_01
MAL_HOST = 192.168.0.141
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.121
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237
[MAL_INST2]
MAL_INST_NAME = GRP1_RWW_02
MAL_HOST = 192.168.0.142
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.122
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237
[MAL_INST3]
MAL_INST_NAME = GRP1_RWW_03
MAL_HOST = 192.168.0.143
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.123
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237

配置dmarch.ini
[dmdba@localhost DAMENG]$ vi dmarch.ini
[ARCHIVE_TIMELY1]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RWW_02
[ARCHIVE_TIMELY2]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RWW_03
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/data/DAMENG/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

[dmdba@localhost DAMENG]$ vi dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL                    ##全局守护类型
DW_MODE = AUTO                       ##自动切换模式
DW_ERROR_TIME = 10                    ##远程守护进程故障认定时间
INST_RECOVER_TIME = 60                ##主库守护进程启动恢复的间隔时间
INST_ERROR_TIME = 10                ##本地实例故障认定时间
INST_OGUID = 453332                   ##守护系统唯一OGUID值
INST_INI = /dm8/data/DAMENG/dm.ini    ##dm.ini配置文件路径
INST_AUTO_RESTART = 1                ##打开实例的自动启动功能
INST_STARTUP_CMD = /dm8/bin/dmserver ##命令行方式启动
RLOG_SEND_THRESHOLD = 0            ##指定主库发送日志到备库的时间阈值，默认关闭
RLOG_APPLY_THRESHOLD = 0            ##指定备库重演日志的时间阈值，默认关闭

17、主库启动到mount状态
[dmdba@localhost bin]$ ./dmserver /dm8/data/DAMENG/dm.ini mount
file dm.key not found, use default license!
version info: develop
DM Database Server 64 V8 03134283890-20220720-165295-10045 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire in 16 day(s) on 2023-07-20
file lsn: 36775
ndct db load finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
SYSTEM IS READY.

18、设置 OGUID
[dmdba@localhost bin]$ ./disql
disql V8
用户名:SYSDBA
密码:
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
DMSQL 过程已成功完成
已用时间: 9.779(毫秒). 执行号:0.
SQL> sp_set_oguid(453332);
DMSQL 过程已成功完成
已用时间: 34.028(毫秒). 执行号:1.
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DMSQL 过程已成功完成
已用时间: 2.962(毫秒). 执行号:2.
SQL> alter database primary;
操作已执行
已用时间: 3.771(毫秒). 执行号:0.

19、配置备库 GRP1_RWW_02
配置 dm.ini
[dmdba@dw_s1 DAMENG]$ vi /dm/data/DAMENG/dm.ini
INSTANCE_NAME = GRP1_RWW_02
PORT_NUM = 5236 #数据库实例监听端口
DW_INACTIVE_INTERVAL = 60 #接收守护进程消息超时时间
ALTER_MODE_STATUS = 0 #不允许手工方式修改实例模式/状态/OGUID
ENABLE_OFFLINE_TS = 2 #不允许备库OFFLINE表空间
MAL_INI = 1 #打开MAL系统
ARCH_INI = 1 #打开归档配置
RLOG_SEND_APPLY_MON = 64 #统计最近64次的日志发送信息

配置dmarch.ini
[ARCHIVE_TIMELY1]

ARCH_TYPE = TIMELY ##即时归档类型

ARCH_DEST = GRP1_RWW_01 ##即时归档目标实例名

[ARCHIVE_TIMELY2]

ARCH_TYPE = TIMELY ##即时归档类型

ARCH_DEST = GRP1_RWW_03 ##即时归档目标实例名

[ARCHIVE_LOCAL1]

ARCH_TYPE = LOCAL ##本地归档类型

ARCH_DEST = /dm8/data/DAMENG/arch ##本地归档文件存放路径

ARCH_FILE_SIZE = 128 ##单位Mb，本地单个归档文件最大值

ARCH_SPACE_LIMIT = 0 ##单位Mb，0表示无限制，范围1024~2147483647M

20、备库启动到mount状态
[dmdba@localhost bin]$ ./dmserver /dm8/data/DAMENG/dm.ini mount
file dm.key not found, use default license!
version info: develop
DM Database Server 64 V8 03134283890-20220720-165295-10045 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire in 16 day(s) on 2023-07-20
file lsn: 36393
ndct db load finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
os_file_open_normal_rw error! path: '/dm8/data/DAMENG/ctl_bak/dm_20230704031046_951157.ctl', code: 13, desc: Permission denied
SYSTEM IS READY.

21、备库设置OGUID，修改数据库模式
[dmdba@localhost bin]$ ./disql
disql V8
用户名:SYSDBA
密码:

服务器[LOCALHOST:5236]:处于普通配置状态
登录使用时间 : 20.859(ms)
SQL>
SQL>
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
DMSQL 过程已成功完成
已用时间: 46.896(毫秒). 执行号:0.
SQL> sp_set_oguid(453332);
DMSQL 过程已成功完成
已用时间: 5.222(毫秒). 执行号:1.
SQL> alter database standby;
操作已执行
已用时间: 5.743(毫秒). 执行号:0.
SQL> SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DMSQL 过程已成功完成
已用时间: 3.324(毫秒). 执行号:2.

22、配置备库 GRP1_RWW_03

配置dm.ini参数
root@localhost DAMENG]# vi dm.ini
INSTANCE_NAME = GRP1_RWW_03

PORT_NUM = 5236 ##数据库实例监听端口

DW_INACTIVE_INTERVAL = 60 ##接收守护进程消息超时时间

ALTER_MODE_STATUS = 0 ##不允许手工方式修改实例模式/状态/OGUID

ENABLE_OFFLINE_TS = 2 ##不允许备库OFFLINE表空间

MAL_INI = 1 ##打开MAL系统

ARCH_INI = 1 ##打开归档配置

RLOG_SEND_APPLY_MON = 64 ##统计最近64次的日志重演信息

配置dmmal.ini
[root@localhost DAMENG]# vi dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = GRP1_RWW_01
MAL_HOST = 192.168.0.141
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.121
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237
[MAL_INST2]
MAL_INST_NAME = GRP1_RWW_02
MAL_HOST = 192.168.0.142
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.122
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237
[MAL_INST3]
MAL_INST_NAME = GRP1_RWW_03
MAL_HOST = 192.168.0.143
MAL_PORT = 5238
MAL_INST_PORT = 5236
MAL_INST_HOST = 192.168.176.123
MAL_DW_PORT = 5239
MAL_INST_DW_PORT = 5237

配置dmarch.ini
[root@localhost DAMENG]# vi dmarch.ini
[ARCHIVE_TIMELY1]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RWW_01
[ARCHIVE_TIMELY2]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RWW_02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/data/DAMENG/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

配置dmwatcher.ini
[GRP1]
   DW_TYPE =GLOBAL                    ##全局守护类型
   DW_MODE = AUTO                        ##自动切换模式
   DW_ERROR_TIME = 10                    ##远程守护进程故障认定时间
   INST_RECOVER_TIME = 60                ##主库守护进程启动恢复的间隔时间
   INST_ERROR_TIME = 10                ##本地实例故障认定时间
   INST_OGUID = 453332                ##守护系统唯一OGUID值
   INST_INI = /dm8/data/DAMENG/dm.ini    ##dm.ini配置文件路径
   INST_AUTO_RESTART = 1                ##打开实例的自动启动功能
   INST_STARTUP_CMD = /dm8/bin/dmserver ##命令行方式启动
   RLOG_SEND_THRESHOLD = 0            ##指定主库发送日志到备库的时间阈值，默认关闭
   RLOG_APPLY_THRESHOLD = 0            ##指定备库重演日志的时间阈值，默认关闭


23、启动备库到mount状态
[dmdba@localhost bin]$ ./dmserver /dm8/data/DAMENG/dm.ini mount
file dm.key not found, use default license!
version info: develop
DM Database Server 64 V8 03134283890-20220720-165295-10045 startup...
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
Database mode = 0, oguid = 0
License will expire in 16 day(s) on 2023-07-20
file lsn: 36393
ndct db load finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct second level fill fast pool finished
ndct third level fill fast pool finished
ndct fill fast pool finished
nsvr_startup end.
aud sys init success.
aud rt sys init success.
systables desc init success.
ndct_db_load_info success.
SYSTEM IS READY.

24、设置 OGUID并修改数据库模式
SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
DMSQL 过程已成功完成
已用时间: 33.127(毫秒). 执行号:0.
SQL> sp_set_oguid(453332);
DMSQL 过程已成功完成
已用时间: 7.242(毫秒). 执行号:1.
SQL> alter database standby;
操作已执行
已用时间: 16.313(毫秒). 执行号:0.
SQL> SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0);
DMSQL 过程已成功完成
已用时间: 4.863(毫秒). 执行号:2.

25、配置监视器
vi /dm8/data/DAMENG/dmmonitor.ini
MON_DW_Confirm = 1
MON_LOG_PATH = /dm8/data/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453332
MON_DW_IP = 192.168.0.141:5239
MON_DW_IP = 192.168.0.142:5239
MON_DW_IP = 192.168.0.143:5239

26、启动各个主备的守护进程
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DAMENG/dmwatcher.ini
DMWATCHER[4.0] V8
DMWATCHER[4.0] IS READY
show