数据守护集群

清理数据守护集群

主备库root停watcher服务
systemctl stop DmWatcherServiceDMSERVER.service

systemctl stop DmWatcherServiceDMSERVER2.service

停完后数据库都宕了

主库冷备
/dm8/bin/dmrman
backup database ‘/dm8/data/DAMENG/dm.ini’ backupset ‘/dm8/backup/20240624’;
exit

注销数据守护集群的服务：
root执行
主库：
/dm8/script/root/dm_service_uninstaller.sh -n DmWatcherServiceDMSERVER
备库：
/dm8/script/root/dm_service_uninstaller.sh -n DmWatcherServiceDMSERVER2

删除实例
/dm8/tool/dbca.sh

rm /etc/dm_svc.conf
rm -rf /dm8/data/DAMENG

主库重新建实例

------------开始
/dm8/bin/DmServiceDMSERVER stop
/dm8/bin/dmrman
backup database ‘/dm8/data/DAMENG/dm.ini’ backupset ‘/dm8/backup’;
–backup database ‘/dm8/data/DAMENG/dm.ini’ backupset ‘/dm8/backup/20240624’;
–backup database ‘/dm8/data/DAMENG/dm.ini’ backupset ‘/dm8/backup/bak2’;
exit

---

备机上执行：
mkdir /dm8/backup/

主机：
cd /dm8/backup
scp backup.* dmdba@211.88.42.18:/dm8/backup/
–cd /dm8/backup/bak2
–scp bak2.* dmdba@211.88.42.18:/dm8/backup/bak2/

vi /dm8/data/DAMENG/dm.ini

ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

vi /dm8/data/DAMENG/dmarch.ini

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER2
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi /dm8/data/DAMENG/dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSERVER
MAL_HOST = 211.88.42.17
MAL_PORT = 15236
MAL_INST_HOST = 211.88.42.17
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSERVER2
MAL_HOST = 211.88.42.18
MAL_PORT = 15236
MAL_INST_HOST = 211.88.42.18
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101

vi /dm8/data/DAMENG/dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 8888
INST_INI = /dm8/data/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

/dm8/bin/DmServiceDMSERVER start mount

/dm8/bin/disql sysdba/Dameng123

SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 1);

sp_set_oguid(8888);

SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 0);

alter database primary;

备机操作：

/dm8/bin/dminit db_name=DAMENG instance_name=DMSERVER2 PATH=/dm8/data
/dm8/bin/dmrman
restore database ‘/dm8/data/DAMENG/dm.ini’ from backupset ‘/dm8/backup’;
recover database ‘/dm8/data/DAMENG/dm.ini’ from backupset ‘/dm8/backup’;
–restore database ‘/dm8/data/DAMENG/dm.ini’ from backupset ‘/dm8/backup/bak2’;
–recover database ‘/dm8/data/DAMENG/dm.ini’ from backupset ‘/dm8/backup/bak2’;
recover database ‘/dm8/data/DAMENG/dm.ini’ update db_magic;
exit

vi /dm8/data/DAMENG/dm.ini

ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

vi /dm8/data/DAMENG/dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = DMSERVER
MAL_HOST = 211.88.42.17
MAL_PORT = 15236
MAL_INST_HOST = 211.88.42.17
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = DMSERVER2
MAL_HOST = 211.88.42.18
MAL_PORT = 15236
MAL_INST_HOST = 211.88.42.18
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101

vi /dm8/data/DAMENG/dmarch.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = DMSERVER
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

vi /dm8/data/DAMENG/dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 8888
INST_INI = /dm8/data/DAMENG/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0

/dm8/bin/dmserver /dm8/data/DAMENG/dm.ini mount

复制一个终端

/dm8/bin/disql sysdba/Dameng123
sp_set_oguid(8888);
alter database standby;
SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 0);
exit

---

退出数据库前端 ，按ctrl c

注册数据库服务
root:
/dm8/script/root/dm_service_installer.sh -t dmserver -p DMSERVER2 -dm_ini /dm8/data/DAMENG/dm.ini

start服务
systemctl start DmServiceDMSERVER2

数据库处于处于主库配置状态、备库配置状态

–（先不做，通过注册服务来做）主机备机都执行：
–/dm8/bin/dmwatcher /dm8/data/DAMENG/dmwatcher.ini

注册数据守护集群的服务：
root执行
主库：
/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMSERVER -watcher_ini /dm8/data/DAMENG/dmwatcher.ini
备库：
/dm8/script/root/dm_service_installer.sh -t dmwatcher -p DMSERVER2 -watcher_ini /dm8/data/DAMENG/dmwatcher.ini

起服务

systemctl start DmWatcherServiceDMSERVER
systemctl start DmWatcherServiceDMSERVER2

第三台，配置监视器
mkdir /dm8/data

vi /dm8/data/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 = 8888
MON_DW_IP = 211.88.42.17:65101
MON_DW_IP = 211.88.42.18:65101

/dm8/bin/dmmonitor /dm8/data/dmmonitor.ini
登录监视器：
login
用户名:sysdba
密码:

show

切换主备：
登录监视器后：
switchover

排错：
原因：
防火墙问题
解决：
[root@localhost ~]# systemctl stop firewalld
[root@localhost ~]# systemctl disable firewalld
配置连接服务名
[root@localhost bin]# cat /etc/dm_svc.conf
TIME_ZONE=(480)
LANGUAGE=(CN)
DAMENG=(192.168.240.101:5236,192.168.240.102:5236)