问题现象:逻辑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';