1.安装前准备
1.1.集规划
| A节点(master) | B节点(slave) | C节点(slave) |
INSTANCE_NAME | RWC1_01 | RWC1_02 | RWC1_03 |
PORT_NUM | 5236 | 5236 | 5236 |
MAL_INST_HOST | 192.168.0.104 | 192.168.0.155 | 192.168.0.188 |
MAL_HOST | 192.168.250.104 | 192.168.250.155 | 192.168.250.188 |
MAL_PORT | 5336 | 5336 | 5336 |
MAL_DW_PORT | 5436 | 5436 | 5436 |
MAL_INST_DW_PORT | 5536 | 5536 | 5536 |
OGUID | 45331 |
守护组 | GRWC1_01 |
| /home/dmdba/dmdbms/ |
数据库实例目录 | /home/dmdba/dmdata/ |
本地归档文件路径 | /home/dmdba/dmdata/oa/arch |
MAL_TEMP_PATH | /home/dmdba/dmdata/malpath |
归档上限 | 10240 |
确认监视器地址 | 192.168.0.188 |
确认监视器目录 | |
| | | |
1.2.数据准备
配置集之前,必须先同步实例数据,确保两者保持完全一致,否则会出现文章最后部分的错误信息。
1.3.同步数据
1)A节点
#首先关闭数据库
systemctl stop DmServiceoa
#然后检查Dmap服务是否在运行,要确保在运行状态 systemctl status DmAPService
#切换到dmdba用户,执行进行脱机备份(数据库处于关闭状态下执行)。 su - dmdba
cd dmdbms/bin
./dmrman CTLSTMT="BACKUP DATABASE '/home/dmdba/dmdata/oa/dm.ini' FULL TO BACKUP_FILE1 BACKUPSET '/home/dmdba/dmdata/BACKUP_FILE_01'"
#拷贝脱机备份的文件到备库所在的机器
scp -r /home/dmdba/dmdata/BACKUP_FILE_01/ 192.168.0.155:/home/dmdba
scp -r /home/dmdba/dmdata/BACKUP_FILE_01/ 192.168.0.188:/home/dmdba
2)B节点
#首先关闭数据库
systemctl stop DmServiceoa
#然后检查Dmap服务是否在运行,要确保在运行状态
systemctl status DmAPService
#切换到dmdba用户,执行进行脱机备份(数据库处于关闭状态下执行)。
su - dmdba
cd dmdbms/bin
./dmrman CTLSTMT="RESTORE DATABASE '/home/dmdba/dmdata/oa/dm.ini' FROM BACKUPSET '/home/dmdba/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/home/dmdba/dmdata/oa/dm.ini' UPDATE DB_MAGIC"
3)C节点
#首先关闭数据库
systemctl stop DmServiceoa
#然后检查Dmap服务是否在运行,要确保在运行状态
systemctl status DmAPService
#切换到dmdba用户,执行进行脱机备份(数据库处于关闭状态下执行)。
su - dmdba
cd dmdbms/bin
./dmrman CTLSTMT="RESTORE DATABASE '/home/dmdba/dmdata/oa/dm.ini' FROM BACKUPSET '/home/dmdba/BACKUP_FILE_01'"
./dmrman CTLSTMT="RECOVER DATABASE '/home/dmdba/dmdata/oa/dm.ini' UPDATE DB_MAGIC"
2.配置A节点
2.1.关服务
systemctl stop DmServiceoa
2.2.创建配置文件
mkdir -p /home/dmdba/dmdata/oa/arch
mkdir -p /home/dmdba/dmdata/malpath
chown -R dmdba.dinstall /home/dmdba/dmdata/malpath
chown -R dmdba.dinstall /home/dmdba/dmdata/oa/arch
touch /home/dmdba/dmdata/oa/{dmarch.ini,dmmal.ini,dmwatcher.ini}
chown dmdba.dinstall /home/dmdba/dmdata/oa/dmarch.ini
chown dmdba.dinstall /home/dmdba/dmdata/oa/dmmal.ini
chown dmdba.dinstall /home/dmdba/dmdata/oa/dmwatcher.ini
2.3.配置dm.ini
#实例名,建议使用―组名_守护环境_序号‖的命名方式,总长度不能超过 16
vi /home/dmdba/dmdata/oa/dm.ini
INSTANCE_NAME = RWC1_01
PORT_NUM = 5236
DW_INACTIVE_INTERVAL = 60
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1
RLOG_SEND_APPLY_MON = 64
2.4.配置dmarch.ini
vi /home/dmdba/dmdata/oa/dmarch.ini
[ARCHIVE_TIMELY1]
ARCH_TYPE = TIMELY
ARCH_DEST = RWC1_02
[ARCHIVE_TIMELY2]
ARCH_TYPE = TIMELY
ARCH_DEST = RWC1_03
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /home/dmdba/dmdata/oa/arch/
ARCH_FILE_SIZE = 2048
ARCH_SPACE_LIMIT = 10240
2.5.配置dmmal.ini
vi /home/dmdba/dmdata/oa/dmmal.ini
MAL_CHECK_INTERVAL = 30
MAL_CONN_FAIL_INTERVAL = 60
MAL_TEMP_PATH = /home/dmdba/dmdata/malpath
MAL_BUF_SIZE = 512
MAL_SYS_BUF_SIZE = 2048
MAL_COMPRESS_LEVEL = 0
[MAL_INST1]
MAL_INST_NAME = RWC1_01
MAL_HOST = 192.168.250.104
MAL_PORT = 5336
MAL_INST_HOST = 192.168.0.104
MAL_INST_PORT = 5236
MAL_DW_PORT = 5436
MAL_INST_DW_PORT = 5536
[MAL_INST2]
MAL_INST_NAME = RWC1_02
MAL_HOST = 192.168.250.155
MAL_PORT = 5336
MAL_INST_HOST = 192.168.0.155
MAL_INST_PORT = 5236
MAL_DW_PORT = 5436
MAL_INST_DW_PORT = 5536
[MAL_INST3]
MAL_INST_NAME = RWC1_03
MAL_HOST = 192.168.250.188
MAL_PORT = 5336
MAL_INST_HOST = 192.168.0.188
MAL_INST_PORT = 5236