DM8主备集群前期准备:3台服务器(一主一备一监视器)
配置如下:
dwp 192.168.1.10 —主机
dws 192.168.1.11 —备机
dwm 192.168.1.12 —监视器
创建数据库实例:
主库:
/dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_01 -dm_ini /dm8/data/GRP_01/dm.ini
备库:
/dm8/script/root/dm_service_installer.sh -t dmserver -p GRP1_02 -dm_ini /dm8/data/GRP_02/dm/.ini
PS:也可以进到dm8/tool 目录执行./dbca.sh进入图形化创建
主备两台实例全部关掉:
./DmServiceGRP_01 stop
./DmServiceGRP_02 stop
对主机进行备份(在本机备份):
建立备份文件夹
mkdir -p /dm8/backup
./dmrman
BACKUP DATABASE '/dm8/data/GRP_01/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/dm8/backup/BACKUP_FILE_01'
从主传到备
scp /dm8/backup/BACKUP_FILE_01/*.* 192.168.1.11:/dm8/backup
//在备机上进行恢复
./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/GRP1_02/dm.ini' FROM BACKUPSET '/dm8/backup'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/GRP1_02/dm.ini' FROM BACKUPSET '/dm8/backup'"
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/GRP1_03/dm.ini' UPDATE DB_MAGIC"
主机实例配置文件修改
dm.ini
----------
INSTANCE_NAME = GRP1_01
PORT_NUM = 5246
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2 是否允许表空间offline,2是不允许备库offline
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
---------------
//需要新建
dmmal.ini
------------
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = GRP1_01
MAL_HOST = 192.168.1.30
MAL_PORT = 55101
MAL_INST_HOST = 192.168.1.30
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = GRP1_02
MAL_HOST = 192.168.1.20
MAL_PORT = 55121
MAL_INST_HOST = 192.168.1.20
MAL_INST_PORT = 5246
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
------------------
dmarch.ini (注:arch_dest备机写主机实例,主机写备机实例)
------------
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = GRP1_02
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/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 = 453331
INST_INI = /dm8/data/GRP1_01/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
启动主机数据库(挂载模式)
启动主库
cd /dm8/bin
./dmserver /dm8/data/GRP_01/dm.ini mount
重新开一个窗口
cd /dm8/bin
./disql sysdba/dameng123@localhost:5246
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(453331);
SQL>alter database primary;
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
备机需要注意的是dmarch.ini文件需要写主机的实例名,其他配置文件把实例名改为GRP1_02即可,同样需要以mount方式启动并修改参数(参照主机)
监视器配置
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 = 453331
MON_DW_IP = 192.168.1.10:65101
MON_DW_IP = 192.168.1.11:65121
启动监视器
./dmmonitor /dm8/dmmonitor.ini
文章
阅读量
获赞