部署实时主备集群

 

---主库第一次启动可以为非mount 备库从部署开始就只能以mount方式启动

1.在两台机器上分别安装数据库，并初始化实例(主库GRP1_RT_01 备库GRP1_RT_02)
2.在主库上做脱机全量备份，并把备份集scp到备库上的机器
dmrman

backup database '/database/dm8/myinst/DAMENG/dm.ini' full to backup_full backupset '/home/dmdba/test_dw/full_bak';

scp -r full_bak dmdba@sdb0:/home/dmdba/test_dw/

3.备库上的机器进行脱机还原
dmrman

restore database '/database/dm8/myinst/DAMENG/dm.ini' from backupset '/home/dmdba/test_dw/full_bak' ;

recover database '/database/dm8/myinst/DAMENG/dm.ini' from backupset '/home/dmdba/test_dw/full_bak' ;

recover database '/database/dm8/myinst/DAMENG/dm.ini' update db_magic ;

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

配置mal系统，各主备库的dmmal.ini配置必须完全一致
vi dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = GRP1_RT_01
MAL_HOST = 192.168.43.128
MAL_PORT = 61141
MAL_INST_HOST = 192.168.43.128
MAL_INST_PORT = 5236
MAL_DW_PORT = 52141
MAL_INST_DW_PORT = 33141
[MAL_INST2]
MAL_INST_NAME = GRP1_RT_02
MAL_HOST = 192.168.43.127
MAL_PORT = 61142
MAL_INST_HOST = 192.168.43.127
MAL_INST_PORT = 5236
MAL_DW_PORT = 52142
MAL_INST_DW_PORT = 33142

配置本地归档和实时归档
vi dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /database/dm8/myinst/DAMENG/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024

配置守护进程
vi dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /database/dm8/myinst/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /database/dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

用mount方式启动主库
dmsever /database/dm8/myinst/DAMENG/dm.ini mount

连接至客户端，设置oguid，修改数据库模式
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
SP_SET_OGUID(453331);
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0);
alter database primary ;

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

配置mal系统，主备库的dmmal.ini配置必须一致，直接拷贝即可

 

配置本地归档和实时归档 一般来说 改归档目标实例名即可
vi dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_RT_01
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /database/dm8/myinst/DAMENG/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 1024

配置守护进程
--几乎一样

[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /database/dm8/myinst/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /database/dm8/bin/dmserver
RLOG_APPLY_THRESHOLD = 0

以mount方式启动备库
dmsever /database/dm8/myinst/DAMENG/dm.ini mount

连接至客户端，设置oguid
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
SP_SET_OGUID(453331);

修改数据库模式
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',1);
alter database standby ;
SP_SET_PARA_VALUE(1,'ALTER_MODE_STATUS',0);

6.配置单实例监视器 --路径不作要求 为了方便我直接配在实例目录下
vi dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /database/dm8/myinst/DAMENG/mymonitor/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 453331
MON_DW_IP = 192.168.43.128:52141
MON_DW_IP = 192.168.43.127:52142

 

7.
mount 方式启动数据库实例
主备都启
dmserver /database/dm8/myinst/DAMENG/dm.ini
启动所有主备上的守护进程
dmwatcher /database/dm8/myinst/DAMENG/dmwatcher.ini

启动监视器
dmmonitor /database/dm8/myinst/DAMENG/dmmonitor.ini

 

 https://eco.dameng.com