达梦单机恢复到2节点的DSC

环境:
OS:Centos 7
DB:DMV8
单机实例名:HXL
DSC实例名:SLNNGK

1.单机备份

disql SYSDBA/SYSDBA
SQL>backup database full backupset '/dmdbms/backup/single_fullbak_20240411';
SQL>backup archivelog all delete input to "singe_archbak_20240411" backupset '/dmdbms/backup/single_archbak_20240411';

2.备份文件拷贝到dsc的其中一台机器上
scp -r single_fullbak_20240411 [email protected]:/dmdbms/backup/
scp -r single_archbak_20240411 [email protected]:/dmdbms/backup/

3.停掉dsc数据库
这里需要停掉2个节点的数据库,但是drs和asm不能停掉

4.删除旧实例的相应文件
在一个实例上执行即可,我这里是在节点1上操作

[dmdba@dsc1 bin]$ cd /dmdbms/product/bin
./dmasmtool dcr_ini=/dmdbms/config/dmdcr.ini

删除DMDATA目录下的文件
ASM>pwd
+DMDATA/data/SLNNGK
Used time: 0.161(ms).

ASM>rm dm_service.prikey
Used time: 13.047(ms).
ASM>rm main.dbf
Used time: 24.151(ms).
ASM>rm roll.dbf
Used time: 25.235(ms).
ASM>rm -rf HMAIN
Used time: 20.013(ms).
ASM>rm TEMP0.DBF
Used time: 15.715(ms).
ASM>rm TEMP1.DBF
Used time: 21.627(ms).
ASM>rm tps_hxl01.dbf
Used time: 26.113(ms).

ASM>ls
        dir : bak
        file : dm.ctl
        dir : ctl_bak
        file : system.dbf
total count 4.
Used time: 1.939(ms).
ASM>

删除DMLOG
ASM>pwd
+DMLOG/log
ASM>ls
        file : SLNNGK1_log01.log
        file : SLNNGK1_log02.log
        file : SLNNGK2_log01.log
        file : SLNNGK2_log02.log

ASM>rm *

5.恢复
只在一个节点上操作,我这里是在节点1上操作
su - dmdba
dmrman DCR_INI=/dmdbms/config/dmdcr.ini ##这里很关键需要使用dmcdr.ini配置文件
RMAN>restore archive log from backupset '/dmdbms/backup/single_archbak_20240411' TO ARCHIVEDIR'+DMDATA/arch' overwrite 2;
1表示认为归档文件完好,不再还原该归档文件,添加一条日志记录;
2表示存在同名归档立即报错返回,终止还原;
3表示强制删除归档,重新还原同名归档.

B.恢复
RMAN> RESTORE DATABASE '/dmdbms/config/slnngk1/dm.ini' FROM BACKUPSET '/dmdbms/backup/single_fullbak_20240411';
RMAN> recover database '/dmdbms/config/slnngk1/dm.ini' with archivedir '+DMDATA/arch';
RMAN> recover database '/dmdbms/config/slnngk1/dm.ini' update db_magic;

查看DMDATA文件
ASM>ls
        dir : bak
        file : dm.ctl
        dir : ctl_bak
        file : system.dbf
        file : roll.dbf
        file : main.dbf
        file : tps_hxl01.dbf
        dir : HMAIN
        file : dm_service.prikey
total count 9.
Used time: 0.992(ms).
ASM>pwd
+DMDATA/data/SLNNGK
Used time: 0.157(ms).

DMLOG日志文件
ASM>ls
        file : SLNNGK1_log01.log
        file : SLNNGK1_log02.log
        file : SLNNGK2_log01.log
        file : SLNNGK2_log02.log
total count 4.
Used time: 1.517(ms).
ASM>pwd
+DMLOG/log
Used time: 0.322(ms).

启动数据库
节点1
[dmdba@dsc1 bin]$ cd /dmdbms/product/bin
./dmserver path=/dmdbms/config/slnngk1/dm.ini dcr_ini=/dmdbms/config/dmdcr.ini

节点2:
[dmdba@dsc2 bin]$ cd /dmdbms/product/bin
./dmserver path=/dmdbms/config/slnngk2/dm.ini dcr_ini=/dmdbms/config/dmdcr.ini

6.数据验证

[dmdba@dsc1 bin]$ disql hxl/dameng123

Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 13.063(ms)
disql V8
SQL> select * from tb_hxl;

LINEID     ID NAME 
---------- -- -----
1          1  name1
2          2  name2
3          3  name3
4          4  name4
5          5  name5
6          6  name1
7          7  name2
8          8  name3
9          9  name4
10         10 name5
11         11 name1