场景1
应急，需要快速搭建激活备机提供对外服务。步骤如下：
DmMonitorServiceGRP1 stop
DmWatcherServiceGRP1 stop
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
alter database mount;
alter database normal;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
alter database open;
systemctl disable DmMonitorServiceGRP1
场景2
在场景1的情况下，添加新的备库。
1、主库联机备份、备机恢复
BACKUP DATABASE BACKUPSET '/dmdb/dmbak/test01_20220105_1400';
RESTORE DATABASE '/dmdb/dmdata/test/dm.ini' FROM BACKUPSET '/dmdb/dmbak/test01_20220105_1400' ;
配置文件dmmal.ini、dmarch.ini和dmwatcher.ini可以从主机copy
RECOVER DATABASE '/dmdb/dmdata/test/dm.ini' FROM BACKUPSET '/dmdb/dmbak/test01_20220105_1400';
RECOVER DATABASE '/dmdb/dmdata/test/dm.ini' UPDATe DB_MAGIC;
修改备机的dm.ini中的instance_name，dmarch.ini中的ARCH_DEST的值
2、以mount启动备库
注意DmServiceGRP1服务配置的启动方式必须是启动到mount状态
DmServiceGRP1 start
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
select OGUID,MODE$ from v$instance;
--因为是从主库恢复的OGUID可以不用修改，查询确认下
-- sp_set_oguid(453331);
alter database standby;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
3、主库修改为primary
alter database mount;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 1);
alter database primary;
SP_SET_PARA_VALUE(1, 'ALTER_MODE_STATUS', 0);
DmWatcherServiceGRP1 start
systemctl enable DmServiceGRP1.service
4、备库开启
DmWatcherServiceGRP1 start
systemctl enable DmServiceGRP1.service
systemctl enable DmWatcherServiceGRP1.service
