环境：

机器规划：
主机 192.168.40.197
备机 192.168.40.199
监视器 192.168.40.198
1、关闭主库，做冷备，将备份拷贝到备机上
[dmdba@localhost bin]$ ./DmServiceHIS stop
[dmdba@localhost bin]$ ./dmrman
RMAN> backup database '/dm8/data/DM01/dm.ini' backupset '/dm8/backup'
[dmdba@study3 bin]$ cd /dm8/backup
[dmdba@localhost backup]$ scp back* dmdba@192.168.40.199:/dm8/backup
2、配置主库的 dm.ini,dmmal.ini,dmarch.ini,dmwatcher.ini 文件
2.1 修改 dm.ini 参数文件如下：
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

2.2 配置 dmmal.ini 文件（主库与备库一致）：
MAL_CHECK_INTERVAL = 5
MAL_CONN_FAIL_INTERVAL = 5
[MAL_INST1]
MAL_INST_NAME = HIS
MAL_HOST = 192.168.40.197
MAL_PORT = 55101
MAL_INST_HOST = 192.168.40.197
MAL_INST_PORT = 5236
MAL_DW_PORT = 65101
MAL_INST_DW_PORT = 45101
[MAL_INST2]
MAL_INST_NAME = HIS2
MAL_HOST = 192.168.40.199
MAL_PORT = 55121
MAL_INST_HOST = 192.168.40.199
MAL_INST_PORT = 5236
MAL_DW_PORT = 65121
MAL_INST_DW_PORT = 45121

2.3 配置归档日志文件dmarch.ini(注意：ARCH_DEST设置备库的服务名)：
ARCH_WAIT_APPLY = 0
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = HIS2
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 0
ARCH_FLUSH_BUF_SIZE = 0
ARCH_HANG_FLAG = 1

2.4 配置 dmwatcher.ini 文件
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 8888
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

3、将主库启动到 mount 状态 （注意：不能启到open状态）
[dmdba@localhost bin]$ ./dmserver /dm8/data/DM01/dm.ini mount

4、修改主库的配置
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
SQL>sp_set_oguid(8888);
SQL>SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
SQL>alter database primary;

5、备机上初始化数据库，并恢复数据库
[dmdba@localhost bin]$ ./dminit db_name=DM01 instance_name=HIS2 port_num=5236 path=/dm8/data
RMAN> restore database '/dm8/data/DM01/dm.ini' from backupset '/dm8/backup'
RMAN> recover database '/dm8/data/DM01/dm.ini' from backupset '/dm8/backup'
RMAN> recover database '/dm8/data/DM01/dm.ini' update db_magic

6、配置备库的 dm.ini,dmmal.ini,dmarch.ini,dmwatcher.ini
6.1 修改 dm.ini 参数文件如下：
ALTER_MODE_STATUS = 0
ENABLE_OFFLINE_TS = 2
MAL_INI = 1
ARCH_INI = 1

6.2 配置 dmmal.ini 文件（主库与备库一致）：同上
6.3 配置归档文件 dmarch.ini (注意：ARCH_DEST设置主库的服务名)：
ARCH_WAIT_APPLY = 0
[ARCHIVE_REALTIME]
ARCH_TYPE = REALTIME
ARCH_DEST = HIS
[ARCHIVE_LOCAL1]
ARCH_TYPE = LOCAL
ARCH_DEST = /dm8/arch
ARCH_FILE_SIZE = 64
ARCH_SPACE_LIMIT = 0
ARCH_FLUSH_BUF_SIZE = 0
ARCH_HANG_FLAG = 1

6.4 配置 dmwatcher.ini
[GRP1]
DW_TYPE = GLOBAL
DW_MODE = AUTO
DW_ERROR_TIME = 10
INST_RECOVER_TIME = 60
INST_ERROR_TIME = 10
INST_OGUID = 8888
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

7、启动备库到 mount 状态 （注意：不能启到open状态）
[dmdba@localhost bin]$ ./dmserver /dm8/data/DM01/dm.ini mount

8、修改备库的配置
SQL> sp_set_oguid(8888);
SQL> alter database standby;

9、分别启动主库和备库上的守护进程
[dmdba@localhost bin]$ ./dmwatcher /dm8/data/DM01/dmwatcher.ini

10、配置监视器
[dmdba@study2 data]$ cd /dm8/data
[dmdba@study2 data]$ vi dmmonitor.ini

MON_DW_CONFIRM = 1
MON_LOG_PATH = /dm8/log
MON_LOG_INTERVAL = 60
MON_LOG_FILE_SIZE = 32
MON_LOG_SPACE_LIMIT = 0
[GRP1]
MON_INST_OGUID = 8888
MON_DW_IP = 192.168.40.197:65101
MON_DW_IP = 192.168.40.199:65121

11、启动监视器
[dmdba@study2 data]$ cd /dm8/bin
[dmdba@study2 bin]$ ./dmmonitor /dm8/data/dmmonitor.ini

12、登录监视器
login
用户名:sysdba
密码:

查看数据守护集群的信息：Show
主备切换：Switchover

13、注册数据守护集群服务（使用root用户执行）：
主库：
[root@localhost ~]# cd /dm8/script/root/
[root@localhost root]# ./dm_service_installer.sh -t dmwatcher -p HIS -watcher_ini /dm8/data/DM01/dmwatcher.ini

备库：
[root@localhost ~]# cd /dm8/script/root/
[root@localhost root]# ./dm_service_installer.sh -t dmwatcher -p HIS2 -watcher_ini /dm8/data/DM01/dmwatcher.ini

监视器：
[root@localhost ~]# cd /dm8/script/root/
[root@localhost root]# ./dm_service_installer.sh -t dmmonitor -p monitor -monitor_ini /dm8/data/dmmonitor.ini