适用范围
dataguard
问题概述
错误如下：
pri:
Sat Jun 15 03:05:39 CST 2013
ORACLE Instance yesno1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
Sat Jun 15 03:05:39 CST 2013
Errors in file /u01/app/oracle/admin/yesno/bdump/yesno1_arc1_20232.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sat Jun 15 03:05:39 CST 2013
ORACLE Instance yesno1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
Sat Jun 15 03:05:39 CST 2013
Errors in file /u01/app/oracle/admin/yesno/bdump/yesno1_arc1_20232.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sat Jun 15 03:05:39 CST 2013
ORACLE Instance yesno1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
Sat Jun 15 03:05:39 CST 2013
Errors in file /u01/app/oracle/admin/yesno/bdump/yesno1_arc1_20232.trc:
ORA-16055: FAL request rejected
ARCH: FAL archive failed. Archiver continuing
Sat Jun 15 03:05:39 CST 2013
ORACLE Instance yesno1 - Archival Error. Archiver continuing.
FAL[server, ARC1]: FAL archive failed, see trace file.
TRACE文件内容如下：
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
ORA-16055: FAL request rejected
其他什么也没了
stb：
MRP0: Background Managed Standby Recovery process started (yesno)
Managed Standby Recovery not using Real Time Apply
parallel recovery started with 15 processes
Sat Jun 15 03:04:48 CST 2013
Waiting for all non-current ORLs to be archived...
Media Recovery Waiting for thread 1 sequence 17136
Fetching gap sequence in thread 1, gap sequence 17136-17229
Sat Jun 15 03:04:48 CST 2013
Completed: ALTER DATABASE RECOVER managed standby database disconnect from session
Sat Jun 15 03:06:23 CST 2013
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 17136-17229
DBID 423650287 branch 770684126
FAL[client]: All defined FAL servers have been attempted.
-------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that is sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
问题原因
oracle没有分析出LOG_ARCHIVE_DEST_N中的配置，导致了ORA-16055: FAL request rejected问题出现，日志无法正常传输
解决方案
在pri上先执行：
ALTER SYSTEM SET log_archive_dest_state_2='DEFER' SCOPE=BOTH;
然后用：
alter system switch logfile；
执行几次，再执行：
ALTER SYSTEM SET log_archive_dest_state_2='ENABLE' SCOPE=BOTH;
解释：
正常配置DG，先配置LOG_ARCHIVE_CONFIG，然后再配置LOG_ARCHIVE_DEST_N参数既可。
如果出现了这个问题，只需要通过参数LOG_ARCHIVE_DEST_STATE_N暂停日志，随后在启用，Oracle就会重新分析LOG_ARCHIVE_DEST_N中的配置