目录
四、配置主库文件(dm.ini、dmmal.ini、dmarch.ini、dmwatcher.ini)
五、配置备库文件(dm.ini、dmmal.ini、dmarch.ini、dmwatcher.ini)
一、规划
可以批量替换,没有双IP也可以替换成一样的
主库IP: 10.10.1.1
主库心跳IP: 192.168.1.1
备库IP: 10.10.2.1
备库心跳IP: 192.168.2.1
集群组名: GRP1
OGUID: 453332
软件安装目录:C:\dmdbms
二、安装软件及初始化实例
安装软件(略)
1、初始化实例
#初始化实例(GRP1_DW_01)
C:\dmdbms\bin\dminit PATH=D:\dmdata INSTANCE_NAME=GRP1_DW_01 LOG_SIZE=2048 EXTENT_SIZE=32 PAGE_SIZE=32 SYSDBA_PWD=HEN_SYSDBA2022 CASE_SENSITIVE=N CHARSET=1
#初始化实例(GRP1_DW_02)
C:\dmdbms\bin\dminit PATH=D:\dmdata INSTANCE_NAME=GRP1_DW_02 LOG_SIZE=2048 EXTENT_SIZE=32 PAGE_SIZE=32 SYSDBA_PWD=HEN_SYSDBA2022 CASE_SENSITIVE=N CHARSET=1
2、主库启停一次
C:\dmdbms\bin\dmserver D:\dmdata\DAMENG\dm.ini
SYSTEM IS READY.之后,exit退出
三、准备数据
1、主库脱机备份
C:\dmdbms\bin\dmrman use_ap=2 CTLSTMT="BACKUP DATABASE 'D:\dmdata\DAMENG\dm.ini' FULL TO BACKUP_FILE1 BACKUPSET 'D:\dmdata\DAMENG\bak\BACKUP_FILE_01'"
2、拷贝数据至备库
拷贝D:\dmdata\DAMENG\bak\BACKUP_FILE_01到备机的D:下面
3、还原数据至备库
C:\dmdbms\bin\dmrman use_ap=2 CTLSTMT="RESTORE DATABASE 'D:\dmdata\DAMENG\dm.ini' FROM BACKUPSET 'D:\BACKUP_FILE_01'"
C:\dmdbms\bin\dmrman use_ap=2 CTLSTMT="RECOVER DATABASE 'D:\dmdata\DAMENG\dm.ini' FROM BACKUPSET 'D:\BACKUP_FILE_01'"
C:\dmdbms\bin\dmrman use_ap=2 CTLSTMT="RECOVER DATABASE 'D:\dmdata\DAMENG\dm.ini' UPDATE DB_MAGIC"
--------------------------------------------------------------------------------------
四、配置主库文件(dm.ini、dmmal.ini、dmarch.ini、dmwatcher.ini)
#1、dm.ini(打开编辑)
ALTER_MODE_STATUS = 1
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
#2、dmmal.ini
echo MAL_CHECK_INTERVAL = 5 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_CONN_FAIL_INTERVAL = 5 >> D:\dmdata\DAMENG\dmmal.ini
echo. >> D:\dmdata\DAMENG\dmmal.ini
echo [MAL_INST1] >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_INST_NAME = GRP1_DW_01 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_HOST = 192.168.1.1 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_PORT = 5516 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_INST_HOST = 10.10.1.1 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_INST_PORT = 5236 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_DW_PORT = 5536 >> D:\dmdata\DAMENG\dmmal.ini
echo MAL_INST_DW_PORT = 5336 >> D:\dmdata\DAMENG\dmmal.ini
echo. >> D:\dmdata\DAMENG\dmmal.ini
echo [MAL_INST2] >> D:\dmdata\DAMENG\dmmal.ini