0 基本信息

环境：CentOS 7
数据库版本：V8.1.3.26

SQL> select id_code;
LINEID     ID_CODE                                   
---------- ------------------------------------------
1          --03134284058-20240821-240039-20046 Pack37

数据库信息：主备集群部署在同一台服务器
软件目录：/dm8
实例目录：
主：/dmdata/5236
备：/dmdata/5237

1 全库备份

这里全库备份执行脱机的全备或联机全备都可以。
此处执行的是脱机的全备

1.1 停止服务

停监视器

[dmdba@dba ~]$ DmMonitorServiceMONITOR stop
Stopping DmMonitorServiceMONITOR:                       [ OK ]

停备的守护：

[dmdba@dba ~]$ DmWatcherServiceDMSERVER02 stop
Stopping DmWatcherServiceDMSERVER02:                  [ OK ]

停主的守护：

[dmdba@dba ~]$ DmWatcherServiceDMSERVER01 stop
Stopping DmWatcherServiceDMSERVER01:                  [ OK ]

停主的数据库：

[dmdba@dba ~]$ DmServiceDMSERVER01 stop
Stopping DmServiceDMSERVER01:                        [ OK ]

停备的数据库：

[dmdba@dba ~]$ DmServiceDMSERVER02 stop
Stopping DmServiceDMSERVER02:                         [ OK ]

1.2 dmrman执行备份

[dmdba@dba ~]$ dmrman
dmrman V8
RMAN> backup database '/dmdata/5236/DMDB/dm.ini' backupset '/home/dmdba/full.bak';
backup database '/dmdata/5236/DMDB/dm.ini' backupset '/home/dmdba/full.bak';
file dm.key not found, use default license!
Database mode = 1, oguid = 26180
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[41419], file_lsn[41419]
Processing backupset /home/dmdba/full.bak
                                                                                                                                    [Percent:81.94%][Speed:628.71M/s][Cost:00:00:02][Remaining:00:00:0                                                                                                                                    [Percent:98.71%][Speed:426.23M/s][Cost:00:00:02][Remaining:00:00:0                                                                                                                                    [Percent:100.00%][Speed:285.71M/s][Cost:00:00:02][Remaining:00:00:                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
backup successfully!
time used: 00:00:03.517

2 模拟故障

2.1 system.dbf文件改名

[dmdba@dba ~]$ cd /dmdata/5236/DMDB/
[dmdba@dba DMDB]$ ls
bak         dm.ini.dmbak              HMAIN
ctl_bak     dminit20241025092424.log  MAIN.DBF
dmarch.ini  dmmal.ini                 ROLL.DBF
dm.ctl      dmmonitor.ini             sqllog.ini
DMDB01.log  dmmonitor_noc.ini         SYSTEM.DBF
DMDB02.log  dm_service.prikey         TEMP.DBF
dm.ini      dmwatcher.ini             trace
[dmdba@dba DMDB]$ cp dm.ini dm.ini.bak
[dmdba@dba DMDB]$ mv SYSTEM.DBF SYSTEM.DBF.BAK

2.2 识别system.dbf文件丢失

启主库服务

[dmdba@dba DMDB]$ DmServiceDMSERVER01 start
Starting DmServiceDMSERVER01:                     [ FAILED ]

查看日志报错

3 解决故障

3.1 重新生成一个system.dbf文件

注：此处需要重新拷贝回来一个system.dbf文件，否则在restore时提示，SYSTEM.DBF文件不存在。
将备库的system.dbf文件拷贝回来

[dmdba@dba ~]$ cd /dmdata/5237/DMDB/
[dmdba@dba DMDB]$ ls
bak         dm.ini.dmbak              HMAIN
ctl_bak     dminit20241025093427.log  MAIN.DBF
dmarch.ini  dmmal.ini                 ROLL.DBF
dm.ctl      dmmonitor.ini             sqllog.ini
DMDB01.log  dmmonitor_noc.ini         SYSTEM.DBF
DMDB02.log  dm_service.prikey         TEMP.DBF
dm.ini      dmwatcher.ini             trace
[dmdba@dba DMDB]$ cp SYSTEM.DBF ../../5236/DMDB/

3.2 dmrman执行restore重储备份

[dmdba@dba DMDB]$ dmrman
dmrman V8
RMAN> restore database '/dmdata/5236/DMDB/dm.ini' from backupset '/home/dmdba/full.bak';
restore database '/dmdata/5236/DMDB/dm.ini' from backupset '/home/dmdba/full.bak';
file dm.key not found, use default license!
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
                                                                                                                                                                                                                                                                                                                                          [Percent:100.00%][Speed:1316.29M/s][Cost:00:00:02][Remaining:00:00                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00                                                                  [Percent:100.00%][Speed:0.00M/s][Cost:00:00:02][Remaining:00:00:00]
restore successfully.
time used: 00:00:02.790

3.3 dmrman执行recover恢复

RMAN> recover database '/dmdata/5236/DMDB/dm.ini' from backupset '/home/dmdba/full.bak';
recover database '/dmdata/5236/DMDB/dm.ini' from backupset '/home/dmdba/full.bak';
Database mode = 2, oguid = 26180
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[41419], file_lsn[41419]
recover successfully!
time used: 448.116(ms)

3.4 更新db_magic

RMAN> recover database '/dmdata/5236/DMDB/dm.ini' update db_magic;
recover database '/dmdata/5236/DMDB/dm.ini' update db_magic;
Database mode = 2, oguid = 26180
Normal of FAST
Normal of DEFAULT
Normal of RECYCLE
Normal of KEEP
Normal of ROLL
EP[0]'s cur_lsn[41419], file_lsn[41419]
recover successfully!
time used: 00:00:01.095

3.5 启服务

[dmdba@dba DMDB]$ DmServiceDMSERVER01 start
Starting DmServiceDMSERVER01:                   [ OK ]
[dmdba@dba DMDB]$ DmServiceDMSERVER02 start
Starting DmServiceDMSERVER02:                    [ OK ]
[dmdba@dba DMDB]$ DmWatcherServiceDMSERVER01 start
Starting DmWatcherServiceDMSERVER01:              [ OK ]
[dmdba@dba DMDB]$ DmWatcherServiceDMSERVER02 start
Starting DmWatcherServiceDMSERVER02:               [ OK ]

至此结束！