逻辑DG ORA-16240: Waiting for logfile

问题现象：逻辑DG日志未应用处理。

通过Select * From v$logstdby

发现存在等待日志ORA-16240: Waiting for logfile (thread# 2, sequence# 25793)

问题原因：逻辑DG备库归档目录满

处理方法：

1、从主库拷贝归档到逻辑DB

$ ftp 192.168.128.36

Connected to 192.168.128.36.

220 P560D FTP server (Version 4.2 Fri Feb 3 22:13:23 CST 2006) ready.

Name (192.168.128.36:oracle): oracle

331 Password required for oracle.

Password: 

230-1 unsuccessful login attempt since last login.

230-Last unsuccessful login: Tue Apr 24 08:01:09 BEIST 2012 on ftp from P560A

230-Last login: Wed Mar 28 22:58:07 BEIST 2012 on 172_16_3_6_2 from 172.16.3.6:2

230 User oracle logged in.

ftp> cd /archivelog

250 CWD command successful.

ftp> put arch_2_25793_614088933.arc

200 PORT command successful.

150 Opening data connection for arch_2_25793_614088933.arc.

226 Transfer complete.

47813645 bytes sent in 3.076 seconds (1.518e+04 Kbytes/s)

local: arch_2_25793_614088933.arc remote: arch_2_25793_614088933.arc

ftp> 

2、逻辑备库上重命名归档

mv arch_2_25793_614088933.arc archive_2_25793_614088933.arc

3、逻辑备库上重新注册日志

alter database register logfile '/archivelog/archive_2_25793_614088933.arc';

4、查看逻辑备库发现已经正常应用日志

Tue Apr 24 08:12:07 2012

LOGMINER: End mining logfile: /archivelog/archive_2_25793_614088933.arc

Tue Apr 24 08:12:07 2012

LOGMINER: Begin mining logfile for session 1 thread 2 sequence 25794, /archivelog/archive_2_25794_614088933.arc

Tue Apr 24 08:12:07 2012

LOGMINER: Log Auto Delete - deleting: /archivelog/archive_2_25792_614088933.arc

Deleted file /archivelog/archive_2_25792_614088933.arc

Tue Apr 24 08:12:16 2012

LOGMINER: Log Auto Delete - deleting: /archivelog/archive_1_30978_614088933.arc

Deleted file /archivelog/archive_1_30978_614088933.arc

Tue Apr 24 08:12:16 2012

LOGMINER: Log Auto Delete - deleting: /archivelog/archive_2_25793_614088933.arc

Deleted file /archivelog/archive_2_25793_614088933.arc

Tue Apr 24 08:12:19 2012

Thread 1 advanced to log sequence 525 (LGWR switch)

  Current log# 1 seq# 525 mem# 0: /oradata/rlog11_disk

本文转自zylhsy 51CTO博客，原文链接：http://blog.51cto.com/yunlongzheng/842760，如需转载请自行联系原作者