dm8-两台操作机搭建主备及监视器集群

集群规划

!### 规划.PNG
/crbank/dm/rpa/bin是我的bin目录
/dmdata/rpa/rpa是数据文件目录
/dmdata/rpa/backup是存放备份文件的路径

初始化与数据备份还原

①重启服务 —主操作
[dmdba@dmdw03 ~]$ /crbank/dm/rpa/bin/DmServicerpa stop
DmServicerpa service is stopped.

②开启AP服务 —主操作
[dmdba@dmdw03 ~]$ /crbank/dm/rpa/bin/DmServicerpa/DmAPService status
DmAPService is stopped

[dmdba@dmdw03 ~]$ /crbank/dm/rpa/bin/DmServicerpa/DmAPService start
Starting DmAPService:
[ ok ]

③初始化备机数据库
/crbank/dm/rpa/bin/dminit path=/dmdata/rpa/rpa page_size=16 db_name=RPA02 INSTANCE_NAME=RPA03 PORT_NUM=5251 CHARSET=1 CASE_SENSITIVE=1

④备份及还原（主机备-传到备机-备机还原）为了方便大家理解，我都添加了绝对路径
主机备份
[dmdba@dmdw03 ~]$ /crbank/dm/rpa/bin/dmrman ctlstmt="backup database ‘/dm/data/DAMENG1/dm.ini’ full backupset ‘/dmdata/rpa/backup’; "
传输----备机操作数据从87传到88
scp -r root@10.241.223.87:/dmdata/rpa/backup/* /dmdata/rpa/backup/
备机还原—备机操作
[dmdba@localhost bin]$ /crbank/dm/rpa/bin/dmrman ctlstmt=“restore database ‘/dmdata/rpa/rpa/dm.ini’ from backupset ‘/dmdata/rpa/backup/’;”

[dmdba@localhost bin]$ /crbank/dm/rpa/bin/dmrman ctlstmt="recover database ‘/dmdata/rpa/rpa/dm.ini’ update db_magic; "

⑤注册服务 —备机注册，主的我以及注册了
–root执行
/crbank/dm/rpa/script/root/dm_service_installer.sh -t dmserver -p rpa03 -dm_ini /crbank/dm/rpa/bin/dm.ini -auto false -m mount

# 配置文件

## ### 主库操作

1.修改dm.ini参数 /dmdata/rpa/rpa下
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS   = 2
MAL_INI       = 1
ARCH_INI      = 1

2.创建dmmal.ini 这里面的几个参数文件与规划保持一致
[dmdba@localhost bin]$ vim /dmdata/rpa/rpa/dmmal.ini
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = RPA
MAL_HOST = 10.241.223.87
MAL_PORT = 55101
MAL_INST_HOST = 10.241.223.87
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = RPA03
MAL_HOST = 10.241.223.88
MAL_PORT = 55121
MAL_INST_HOST = 10.241.223.88
MAL_INST_PORT = 5251
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

2. 修改dmarch.ini 这里也是填两个参数，一个配置自己归档，一个配置对方归档
[dmdba@dmdw03 rpa]$ vim /dmdata/rpa/rpa/dmmal.ini
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = RPA03
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dmdata/rpa/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm/data/dmdb1/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

3. 创建dmwatcher.ini 监控自己的一些参数配置
[dmdba@dmdw03 rpa]$ vim /dmdata/rpa/rpa/dmwatcher.ini
[RPA]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dmdata/rpa/rpa/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /crbank/dm/rpa/bin/dmserver
RLOG_SEND_THRESHOLD = 0
RLOG_APPLY_THRESHOLD = 0
4.mount方式启动主库

[dmdba@localhost bin]$ ./DmServicerpa start

设置OGUID

启动命令行工具DIsql，登录主库设置OGUID值。
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA
SQL> SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 1);
SQL> SP_SET_OGUID(453331);
和上面的INST_OGUID监控配置的一致

### 备机操作

1.修改dmini参数
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS   = 2
MAL_INI       = 1
ARCH_INI      = 1

2.创建vi /dmdata/rpa/rpa03/dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = RPA
MAL_HOST = 10.241.223.87
MAL_PORT = 55101
MAL_INST_HOST = 10.241.223.87
MAL_INST_PORT = 5246
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = RPA03
MAL_HOST = 10.241.223.88
MAL_PORT = 55121
MAL_INST_HOST = 10.241.223.88
MAL_INST_PORT = 5251
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121
~

3.创建dmarch.ini
[dmdba@localhost bin]$ vi /dmdata/rpa/rpa03/dmarch.ini

[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = RPA
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dmdata/rpa/arch
ARCH_FILE_SIZE = 128
ARCH_SPACE_LIMIT = 0

4.创建dmwatcher.ini
[dmdba@localhost bin]$ vi /dmdata/rpa/rpa03/dmwatcher.ini

[RPA]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 453331
INST_INI = /dmdata/rpa/rpa03/dm.ini
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /crbank/dm/rpa/bin/dmserver
RLOG_APPLY_THRESHOLD = 0
~

5.mount方式启动备库

[dmdba@localhost bin]$ ./DmServirpa03 start

设置OGUID

启动命令行工具DIsql，登录主库设置OGUID值。
[dmdba@localhost bin]$ ./disql SYSDBA/SYSDBA

SQL> SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 1);
SQL> SP_SET_OGUID(453331);

SQL> SP_SET_PARA_VALUE(1, ‘ALTER_MODE_STATUS’, 0);

系统通过OGUID值确定一个守护进程组，由用户保证OGUID值的唯一性，并确保数据守护系统中，数据库、守护进程和监视器配置相同的OGUID值。

修改数据库模式

启动命令行工具DIsql，登录主库修改数据库为Primary模式

SQL> ALTER DATABASE STANDBY;

启动守护进程
此时数据库还是配置状态

监控操作

在88备机上操作，按规划是放在备机上

[root@dmdw04 ~]# vi/dmdata/rpa/conf/dmmonitor.ini
MON_DW_CONFIRM = 1
MON_LOG_PATH = /dmdata/rpa/conf
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[RPA]
MON_INST_OGUID = 453331
MON_DW_IP = 10.241.223.87:65101
MON_DW_IP = 10.241.223.88:65121
1.注册主库守护进程服务并启动

sh-5.0# /crbank/dm/rpa/bin/dm_service_installer.sh -t dmwatcher -watcher_ini /dmdata/rpa/rpa/dmwatcher.ini -p rpa
[dmdba@localhost bin]$ /DmWatcherServicerpa start

2.注册备库守护进程服务并启动
sh-5.0# /crbank/dm/rpa/bin/dm_service_installer.sh -t dmwatcher -watcher_ini /dmdata/rpa/rpa/dmwatcher.ini -p rpa03
[dmdba@localhost bin]$ ./DmWatcherServicerpa03 start

演示效果

守护进程开启后，数据库会自动从mount拉起到open状态，没拉起代表配置有问题
主库状态
![image.png]