达梦数据库主备集群搭建（一主一备）

一、主机实例准备1.注册实例./dminit path/dmdata/data INSTANCE_NAMEDMSERVER01 DB_NAMEDMDBA PORT_NUM5234 PAGE_SIZE32 EXTENT_SIZE32 CASE_SENSITIVEy CHARSET1 LOG_SIZE2048 SYSDBA_PWDDameng123 SYSAUDITOR_PWDDameng1232.注册服务./dm_service_installer.sh -t dmserver -dm_ini /dmdata/data/DMDBA/dm.ini -p DMSERVER01二、备机实例准备1.注册实例./dminit path/dmdata/data INSTANCE_NAMEDMSERVER02 DB_NAMEDMDBA PORT_NUM5234 PAGE_SIZE32 EXTENT_SIZE32 CASE_SENSITIVEy CHARSET1 LOG_SIZE2048 SYSDBA_PWDDameng123 SYSAUDITOR_PWDDameng1232.注册服务./dm_service_installer.sh -t dmserver -dm_ini /dmdata/data/DMDBA/dm.ini -p DMSERVER02三、脱机备份、脱机还原1.正常关闭数据库开启主机和备机数据库后再将其关闭。./DmServerDMSERVER01 start./DmServerDMSERVER01 stop备机只需将01改为022.主机进行脱机备份./dmrman CTLSTMTBACKUP DATABASE /dmdata/data/DMDBA/dm.ini FULL TO BACKUP_FILE1 BACKUPSET /dmdata/dmbak/BACKUP_FILE_013.主机拷贝备份文件到备机scp -r /dmdata/dmbak/BACKUP_FILE_01 root192.168.18.138:/dmdata/dmbak4.执行脱机数据库还原与恢复1备机备库数据库还原./dmrman CTLSTMTRESTORE DATABASE /dmdata/data/DMDBA/dm.ini FROM BACKUPSET /dmdata/dmbak/BACKUP_FILE_01因为脱机备份没有产生任何 REDO 日志所以此处省略恢复数据库的操作步骤。2备机备库数据库更新./dmrman CTLSTMTRECOVER DATABASE /dmdata/data/DMDBA/dm.ini UPDATE DB_MAGIC四、配置主库DMSERVER011.通过vi /dmdata/data/DMDBA /dm.ini修改dm.iniINSTANCE_NAME DMSERVER01PORT_NUM 5234 ##数据库实例监听端口DW_INACTIVE_INTERVAL 60 ##接收守护进程消息超时时间ALTER_MODE_STATUS 0 ##不允许手工方式修改实例模式/状态/OGUIDENABLE_OFFLINE_TS 2 ##不允许备库OFFLINE表空间MAL_INI 1 ##打开MAL系统ARCH_INI 1 ##打开归档配置RLOG_SEND_APPLY_MON 64 ##统计最近64次的日志发送信息2.通过vi ./dmdata/data/DMDBA/dmmal.ini配置dmmal.iniMAL_CHECK_INTERVAL 5MAL_CONN_FAIL_INTERVAL 5[MAL_INST1]MAL_INST_NAME DMSERVER01MAL_HOST 192.168.18.137MAL_PORT 5235MAL_INST_HOST 192.168.18.137MAL_INST_PORT 5234MAL_DW_PORT 5236MAL_INST_DW_PORT 5237[MAL_INST2]MAL_INST_NAME DMSERVER02MAL_HOST 192.168.18.138MAL_PORT 5235MAL_INST_HOST 192.168.18.138MAL_INST_PORT 5234MAL_DW_PORT 5236MAL_INST_DW_PORT 52373.通过vi./dmdata/data/DMDBA/dmarch.ini配置dmarch.ini[ARCHIVE_REALTIME]ARCH_TYPE REALTIMEARCH_DEST DMSERVER02 # 指向备库实例名ARCH_WAIT_APPLY 0[ARCHIVE_LOCAL1]ARCH_TYPE LOCALARCH_DEST /dmdata/archARCH_FILE_SIZE 128ARCH_SPACE_LIMIT 04.通过vi ./dmdata/data/DMDBA/dmwatcher.ini配置dmwatcher.ini[GRP1]DW_TYPE GLOBAL #全局守护类型DW_MODE AUTO #自动切换模式DW_ERROR_TIME 10 #远程守护进程故障认定时间INST_RECOVER_TIME 60 #主库守护进程启动恢复的间隔时间INST_ERROR_TIME 10 #本地实例故障认定时间INST_OGUID 453331 #守护系统唯一 OGUID 值INST_INI /dmdata/data/DMDBA/dm.ini #dm.ini 配置文件路径INST_AUTO_RESTART 1 #打开实例的自动启动功能INST_STARTUP_CMD /home/dmdba/dmdbms/bin/DmServiceDMSERVER01 #命令行方式启动RLOG_SEND_THRESHOLD 0 #指定主库发送日志到备库的时间阈值默认关闭RLOG_APPLY_THRESHOLD 0 #指定备库重演日志的时间阈值默认关闭注册服务./dm_service_installer.sh \-t dmwatcher \-watcher_ini /dmdata/data/DMDBA/dmwatcher.ini \-p DMSERVER01_WATCHER5.以Mount方式启动主库./dmserver /dmdata/data/DMDBA/dm.ini mount运行直到看到 SYSTEM IS READY 后不要关闭另起一个终端来设置 OGUID。6.设置OGUID以及修改数据库模式通过./disql SYSDBA/Dameng123localhost:5234进入数据库执行下面命令SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 1);sp_set_oguid(453331);ALTER DATABASE PRIMARY;SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 0);五、配置备库DMSERVER021.通过vi /dmdata/data/DMDBA /dm.ini修改dm.iniINSTANCE_NAME DMSERVER02PORT_NUM 5234 ##数据库实例监听端口DW_INACTIVE_INTERVAL 60 ##接收守护进程消息超时时间ALTER_MODE_STATUS 0 ##不允许手工方式修改实例模式/状态/OGUIDENABLE_OFFLINE_TS 2 ##不允许备库OFFLINE表空间MAL_INI 1 ##打开MAL系统ARCH_INI 1 ##打开归档配置RLOG_SEND_APPLY_MON 64 ##统计最近64次的日志发送信息2.通过vi ./dmdata/data/DMDBA/dmmal.ini配置dmmal.iniMAL_CHECK_INTERVAL 5MAL_CONN_FAIL_INTERVAL 5[MAL_INST1]MAL_INST_NAME DMSERVER01MAL_HOST 192.168.18.137MAL_PORT 5235MAL_INST_HOST 192.168.18.137MAL_INST_PORT 5234MAL_DW_PORT 5236MAL_INST_DW_PORT 5237[MAL_INST2]MAL_INST_NAME DMSERVER02MAL_HOST 192.168.18.138MAL_PORT 5235MAL_INST_HOST 192.168.18.138MAL_INST_PORT 5234MAL_DW_PORT 5236MAL_INST_DW_PORT 52373通过vi./dmdata/data/DMDBA/dmarch.ini配置dmarch.ini[ARCHIVE_REALTIME]ARCH_TYPE REALTIME #实时归档类型ARCH_DEST DMSERVER01#实时归档目标实例名[ARCHIVE_LOCAL1]ARCH_TYPE LOCAL #本地归档类型ARCH_DEST /dmdata/arch #本地归档文件路径ARCH_FILE_SIZE 128 #单位 Mb本地单个归档文件最大值ARCH_SPACE_LIMIT 0 #单位 Mb0 表示无限制范围 1024~2147483647M3.通过vi ./dmdata/data/DMDBA/dmwatcher.ini配置dmwatcher.ini[GRP1]DW_TYPE GLOBAL #全局守护类型DW_MODE AUTO #自动切换模式DW_ERROR_TIME 10 #远程守护进程故障认定时间INST_RECOVER_TIME 60 #主库守护进程启动恢复的间隔时间INST_ERROR_TIME 10 #本地实例故障认定时间INST_OGUID 453331 #守护系统唯一 OGUID 值INST_INI /dmdata/data/DMDBA/dm.ini #dm.ini 配置文件路径INST_AUTO_RESTART 1 #打开实例的自动启动功能INST_STARTUP_CMD /home/dmdba/dmdbms/bin/DmServiceDMSERVER02 #命令行方式启动RLOG_SEND_THRESHOLD 0 #指定主库发送日志到备库的时间阈值默认关闭RLOG_APPLY_THRESHOLD 0 #指定备库重演日志的时间阈值默认关闭注册服务./dm_service_installer.sh \-t dmwatcher \-watcher_ini /dmdata/data/DMDBA/dmwatcher.ini \-p DMSERVER02_WATCHER4.以Mount方式启动备库./dmserver /dmdata/data/DMDBA/dm.ini mount运行知道看到SYSTEM IS READY不要关闭另起一个终端来设置 OGUID。5.设置OGUID以及修改数据库模式通过./disql SYSDBA/Dameng123localhost:5234进入数据库执行下面命令SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 1);sp_set_oguid(453331);ALTER DATABASE STANDBY ;SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 0);六、配备监视器可以在主机、备机或另开一台机器上配置监视器本实验在主机上进行。通过 vi /dmdata/data/DMDBA/dmmonitor.ini 配置 dmmonitor.ini。MON_DW_CONFIRM 1MON_LOG_PATH /home/dmdba/dmdbms/logMON_LOG_INTERVAL 60MON_LOG_FILE_SIZE 32MON_LOG_SPACE_LIMIT 0[GRP1]MON_INST_OGUID 453331MON_DW_IP 192.168.18.138:5236MON_DW_IP 192.168.18.139:5236七、服务启停1.服务启动顺序主备启动cd /home/dmdba/dmdbms/bin主库实例./DmServiceDMSERVER01 start备库实例./DmServiceDMSERVER02 start主库守护进程./DmWatcherServiceDMSERVER01 start备库守护进程./DmWatcherServiceDMSERVER02 start监视器前台启动./dmmonitor /dmdata/data/DMDBA/dmmonitor.ini也可创建监视器服务即可后台启动监视器2.服务关闭顺序主备停止cd /home/dmdba/dmdbms/bin关闭监视器前台ctrlc备库守护进程./DmWatcherServiceDMSERVER02 stop主库守护进程./DmWatcherServiceDMSERVER01 stop主库实例./DmServiceDMSERVER01 stop备库实例./DmServiceDMSERVER02 stop