问题现象：
逻辑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，如需转载请自行联系原作者
