达梦备库同步异常恢复

一、环境信息

二、利用主库在线备份恢复备库

1.关闭确认监视器

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./DmMonitorServiceGRP1 stop
Stopping DmMonitorServiceGRP1:                             [ OK ]

2.关闭备库服务

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./DmWatcherServiceGRP1_RT_02 stop
Stopping DmWatcherServiceGRP1_RT_02:                             [ OK ]
[dmdba@localhost bin]$ ./DmServiceGRP1_RT_02 stop
Stopping DmServiceGRP1_RT_02:                             [ OK ]

3.主库联机备份数据库

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$./dmrman
SQL>
backup database full backupset '/dm8/dmdata/dmtest/bak/fullbak_0630' compressed parallel 4;

4.传备份集到备库做恢复

[dmdba@localhost bak]$ scp -r /dm8/dmdata/dmtest/bak/fullbak_0630 192.168.48.8:/dm8/dmdata/dmtest/bak/

Authorized users only. All activities may be monitored and reported.
dmdba@192.168.48.8's password:
fullbak_0630_2.bak                                                                           100%   12KB   8.1MB/s   00:00
fullbak_0630_2.meta                                                                          100%   86KB  17.9MB/s   00:00
fullbak_0630_1.bak                                                                           100%   24KB  10.8MB/s   00:00
fullbak_0630_1.meta                                                                          100%   86KB  23.5MB/s   00:00
fullbak_0630_0.bak                                                                           100%  901KB  68.6MB/s   00:00
fullbak_0630_0.meta                                                                          100%   86KB  44.0MB/s   00:00
fullbak_0630.bak                                                                             100%   11KB  11.1MB/s   00:00
fullbak_0630.meta                                                                            100%  342KB  11.0MB/s   00:00

备库恢复：

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$./dmrman
SQL>
dmrman CTLSTMT="RESTORE DATABASE '/dm8/dmdata/dmtest/dm.ini' FROM BACKUPSET '/dm8/dmdata/dmtest/bak/fullbak_0630'"
dmrman CTLSTMT="RECOVER DATABASE '/dm8/dmdata/dmtest/dm.ini' FROM BACKUPSET '/dm8/dmdata/dmtest/bak/fullbak_0630'"
dmrman CTLSTMT="RECOVER DATABASE '/dm8/dmdata/dmtest/dm.ini' UPDATE DB_MAGIC"

5.启动备库服务进程

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./DmServiceDMTEST_B start
Starting DmServiceDMTEST_B:                           [ OK ]

6.启动备库守护进程

[root@localhost bin]# su - dmdba
[dmdba@localhost bin]$ cd /home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./DmWatcherServiceDMTEST_B start
Starting DmWatcherServiceDMTEST_B:                         [ OK ]

7.启动确认监视器

[dmdba@localhost bin]$ ./DmMonitorServiceGRP1 start
Starting DmMonitorServiceGRP1:                             [ OK ]

三、非确认监视器，查看状态

[dmdba@localhost bin]$ dmmonitor /dm8/monitor/dmmonitor_manual.ini
[monitor]         2023-06-29 03:30:25: DMMONITOR[4.0] V8
[monitor]         2023-06-29 03:30:26: DMMONITOR[4.0] IS READY.

[monitor]         2023-06-29 03:30:26: 收到守护进程(DMTEST_B)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN
                  2023-06-29 03:30:26  OPEN           OK        DMTEST_B         OPEN        STANDBY   NULL     5        43309           43309

[monitor]         2023-06-29 03:30:26:
#--------------------------------------------------------------------------------#
GET MONITOR CONNECT INFO FROM DMWATCHER(DMTEST_B), THE FIRST LINE IS SELF INFO.

DW_CONN_TIME         MON_CONFIRM    MID            MON_IP                   MON_VERSION                                        
2023-06-29 03:30:26  FALSE          1073812968     ::ffff:192.168.48.8      DMMONITOR[4.0] V8

2023-06-29 03:27:40  TRUE           1392362588     ::ffff:192.168.48.8      DMMONITOR[4.0] V8

#--------------------------------------------------------------------------------#

[monitor]         2023-06-29 03:30:26: 收到守护进程(DMTEST)消息
                  WTIME                WSTATUS        INST_OK   INAME            ISTATUS     IMODE     RSTAT    N_OPEN   FLSN            CLSN
                  2023-06-29 03:30:20  OPEN           OK        DMTEST           OPEN        PRIMARY   VALID    5        43309           43309

tip
[monitor]         2023-06-29 03:30:31: [!!! 提示：本监视器不是确认监视器，在故障自动切换模式下如果发生主库故障，本监视器无法执行自动接管 !!!]

[monitor]         2023-06-29 03:30:31: 实例DMTEST[PRIMARY, OPEN, ISTAT_SAME:TRUE]不可加入其他实例，守护进程状态：OPEN，Open记录状态：VALID
[monitor]         2023-06-29 03:30:31: 实例DMTEST[PRIMARY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2023-06-29 03:30:31: 实例DMTEST[PRIMARY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2023-06-29 03:30:31: 实例DMTEST_B[STANDBY, OPEN, ISTAT_SAME:TRUE]可加入实例DMTEST[PRIMARY, OPEN, ISTAT_SAME:TRUE]
[monitor]         2023-06-29 03:30:31: 实例DMTEST_B[STANDBY, OPEN, ISTAT_SAME:TRUE]当前没有命令正在执行
[monitor]         2023-06-29 03:30:31: 实例DMTEST_B[STANDBY, OPEN, ISTAT_SAME:TRUE]运行正常, 守护进程是OPEN状态，守护类型是GLOBAL

[monitor]         2023-06-29 03:30:31: 组(GRP1)当前活动实例运行正常

[monitor]         2023-06-29 03:30:31: 所有组中的活动实例运行正常！

更多技术分享，见社区地址：https://eco.dameng.com