1 故障现象

搭建的DG 日志报错如下：

Wed Jun 18 22:45:51 2025
Completed: alter database recover managed standby database using current logfile disconnect from session
Wed Jun 18 22:47:49 2025
FAL[client]: Failed to request gap sequence
 GAP - SCN range: 0x0006.ef6d8e57 - 0x0006.ef6d8e57
 DBID 1680763292 branch 1110167814
FAL[client]: All defined FAL servers have been attempted.

2 解决方法

因为这里是RAC 到单实例的Data Guard，根据缺少的日志，支持用ASMCMD 工具，从ASM 磁盘组里搂文件即可：http://www.cndba.cn/dave/article/131637http://www.cndba.cn/dave/article/131637

-rw-r-----. 1 oracle oinstall 8.1M Jun 18 21:26 2_28800_1110167814.arch
-rw-r-----. 1 oracle oinstall 2.2M Jun 18 21:32 2_28803_1110167814.arch
-rw-r-----. 1 oracle oinstall 9.1M Jun 18 21:38 2_28805_1110167814.arch
-rw-r-----. 1 oracle oinstall 8.2M Jun 18 21:44 2_28807_1110167814.arch
-rw-r-----. 1 oracle oinstall 8.3M Jun 18 21:50 2_28809_1110167814.arch
-rw-r-----. 1 oracle oinstall 9.9M Jun 18 21:56 2_28811_1110167814.arch
-rw-r-----. 1 oracle oinstall  16M Jun 18 22:02 2_28813_1110167814.arch
-rw-r-----. 1 oracle oinstall 9.1M Jun 18 22:08 2_28815_1110167814.arch
-rw-r-----. 1 oracle oinstall 3.1M Jun 18 22:09 2_28817_1110167814.arch
-rw-r-----. 1 oracle oinstall  24K Jun 18 22:09 2_28818_1110167814.arch
-rw-r-----. 1 oracle oinstall 8.5M Jun 18 22:15 2_28820_1110167814.arch
-rw-r-----. 1 oracle oinstall 9.0M Jun 18 22:21 2_28822_1110167814.arch
-rw-r-----. 1 oracle oinstall  30M Jun 18 22:33 2_28823_1110167814.arch

在ASMCMD 中复制到本地：http://www.cndba.cn/dave/article/131637http://www.cndba.cn/dave/article/131637http://www.cndba.cn/dave/article/131637

cp thread_2_seq_28797.2034.1204146901 /u01/backup
cp thread_2_seq_28799.1627.1204147221 /u01/backup
cp thread_2_seq_28801.2084.1204147583 /u01/backup
cp thread_2_seq_28802.1531.1204147833 /u01/backup
cp thread_2_seq_28804.1811.1204147939 /u01/backup
cp thread_2_seq_28806.1996.1204148303 /u01/backup
cp thread_2_seq_28808.1646.1204148665 /u01/backup
cp thread_2_seq_28810.1983.1204149027 /u01/backup
cp thread_2_seq_28812.1998.1204149389 /u01/backup
cp thread_2_seq_28814.1616.1204149745 /u01/backup
cp thread_2_seq_28816.2039.1204150099 /u01/backup
cp thread_2_seq_28819.2026.1204150201 /u01/backup
cp thread_2_seq_28821.1580.1204150519 /u01/backup

在传到单实例：http://www.cndba.cn/dave/article/131637http://www.cndba.cn/dave/article/131637

[oracle@cndba.cn backup]$ scp * 198.198.198.5:/u01/archivelog/

手工注册后恢复正常：http://www.cndba.cn/dave/article/131637http://www.cndba.cn/dave/article/131637

ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28797.2034.1204146901';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28799.1627.1204147221';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28801.2084.1204147583';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28802.1531.1204147833';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28804.1811.1204147939';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28806.1996.1204148303';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28808.1646.1204148665';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28810.1983.1204149027';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28812.1998.1204149389';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28814.1616.1204149745';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28816.2039.1204150099';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28819.2026.1204150201';
ALTER DATABASE REGISTER PHYSICAL LOGFILE '/u01/archivelog/thread_2_seq_28821.1580.1204150519';

版权声明：本文为博主原创文章，未经博主允许不得转载。