dwp 192.168.165.245 主
dws 192.168.165.208 备
dwm 192.168.165.208 监视器

1、备库初始化实例：

su - dmdba
cd /dm8/bin
./dminit PATH=/dm8/data DB_NAME=DM01  INSTANCE_NAME=DMSVR02 PORT_NUM=5236 PAGE_SIZE=16 EXTENT_SIZE=32  LOG_SIZE=500 CASE_SENSITIVE=Y SYSDBA_PWD=DM01SYSDBA  SYSAUDITOR_PWD=DM01SYSDBA

2、备库注册实例服务：

cd /dm8/script/root/
./dm_service_installer.sh -t dmserver -p DMSVR02 -dm_ini /dm8/data/DM01/dm.ini

3、将主备库两台实例停掉

./DmServiceDMSVR01 stop
./DmServiceDMSVR02 stop

4、对主库进行备份

mkdir dm8/backup    #先在主库中创建备份目录
./dmrman CTLSTMT="BACKUP DATABASE '/dm8/data/DM01/dm.ini' FULL TO BACKUP_FILE BACKUPSET '/dm8/backup/backup_file'" 

5、从主库传到备库

mkdir dm8/backup  #先在备库中创建备份目录
scp -r /dm8/backup/backup_file dmdba@192.168.165.208:/dm8/backup  #注意可以先调整备库中dmdba密码

6、在备库上进行还原

./dmrman CTLSTMT="RESTORE DATABASE '/dm8/data/DM01/dm.ini' FROM BACKUPSET '/dm8/backup/backup_file/'" 
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DM01/dm.ini' FROM BACKUPSET '/dm8/backup/backup_file/'" 
./dmrman CTLSTMT="RECOVER DATABASE '/dm8/data/DM01/dm.ini' UPDATE DB_MAGIC"

----------主库primary配置-------------
dm.ini

INSTANCE_NAME = DMSVR01 
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

dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1] 
MAL_INST_NAME = DMSVR01 
MAL_HOST = 192.168.165.245
MAL_PORT = 55101
MAL_INST_HOST = 192.168.165.245
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2] 
MAL_INST_NAME = DMSVR02 
MAL_HOST = 192.168.165.208 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.165.208
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121

dmarch.ini

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME
ARCH_DEST = DMSVR02   #注意写备机实例
[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/DM01/dm.ini  
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_SEND_THRESHOLD = 0  
RLOG_APPLY_THRESHOLD = 0 

主库注册守护进程服务：

 cd /dm8/script/root/
./dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /dm8/data/DM01/dmwatcher.ini

启动主库（以mount方式）：

cd /dm8/bin 
./DmServiceDMSVR01 start mount

修改主库的模式和设置oguid：

 ./disql SYSDBA/DM01SYSDBA

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);

--------------备库standby配置---------------
dm.ini

INSTANCE_NAME = DMSVR02 
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 

dmmal.ini

MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1] 
MAL_INST_NAME = DMSVR01 
MAL_HOST = 192.168.165.245
MAL_PORT = 55101
MAL_INST_HOST = 192.168.165.245
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2] 
MAL_INST_NAME = DMSVR02 
MAL_HOST = 192.168.165.208 
MAL_PORT = 55121 
MAL_INST_HOST = 192.168.165.208
MAL_INST_PORT = 5236 
MAL_DW_PORT = 65121 
MAL_INST_DW_PORT = 45121

dmarch.ini

[ARCHIVE_REALTIME] 
ARCH_TYPE = REALTIME 
ARCH_DEST = DMSVR01  #注意写主库实例
[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/DM01/dm.ini 
INST_AUTO_RESTART = 1
INST_STARTUP_CMD = /dm8/bin/dmserver 
RLOG_APPLY_THRESHOLD = 0 

备库注册守护进程服务：

cd /dm8/script/root/
./dm_service_installer.sh -t dmwatcher -p Watcher -watcher_ini /dm8/data/DM01/dmwatcher.ini

启动备库（以mount方式）：

cd /dm8/bin 
./DmServiceDMSVR02 start mount

设置备库模式和oguid值：

./disql SYSDBA/DM01SYSDBA

SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1); 
SQL>sp_set_oguid(453331); 
SQL>alter database standby; 
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);

---

启动主备库守护进程：

./DmWatcherServiceWatcher start    #主库

./DmWatcherServiceWatcher start    #备库

搭建并启动监视器：
切换到监视器所在服务器，用dmdba用户，切换到数据库安装路径
新建 dmmonitor.ini

MON_DW_CONFIRM = 0 
MON_LOG_PATH = /dm8/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.165.245:65101 
MON_DW_IP = 192.168.165.208:65121

监视器查看状态：

./dmmonitor  /dm8/bin/dmmonitor.ini