DG备库之间互传日志文件的问题

深圳－刀

Windows 2008 + Oracle 10.2.0.4
1主库带2个逻辑备库的DG，其中A备库与主库的网络出现问题，但与B备库的网络正常，要如何设置才能让A备库从B备库中取日志？
目前设置参数如下：

主库：
DB_NAME=usaserver
DB_UNIQUE_NAME=usaserver
LOG_ARCHIVE_CONFIG='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
LOG_ARCHIVE_DEST_1 = 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\
   VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_2='SERVICE=usaserver2 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_3= 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)  DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_4='SERVICE=usaserver3 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver3 reopen=600'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=DEFER
LOG_ARCHIVE_DEST_STATE_3=ENABLE
LOG_ARCHIVE_DEST_STATE_4=ENABLE
FAL_SERVER='usaserver2','usaserver3'
FAL_CLIENT=usaserver
STANDBY_FILE_MANAGEMENT=AUTO

A备库：
DB_NAME=usaserver
DB_UNIQUE_NAME=usaserver2
LOG_ARCHIVE_CONFIG='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
LOG_ARCHIVE_DEST_1 = 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_2='SERVICE=usaserver LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver'
LOG_ARCHIVE_DEST_3= 'LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)  DB_UNIQUE_NAME=usaserver2'
LOG_ARCHIVE_DEST_4='SERVICE=usaserver3 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver3 reopen=600'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_3=ENABLE
LOG_ARCHIVE_DEST_STATE_4=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
FAL_SERVER=usaserver
FAL_CLIENT='usaserver2','usaserver3'
STANDBY_FILE_MANAGEMENT=AUTO

B备库：
*.db_name='usaserver'
*.DB_UNIQUE_NAME='usaserver3'
*.fal_client='usaserver3'
*.fal_server='usaserver','usaserver2'
*.log_archive_config='DG_CONFIG=(usaserver,usaserver2,usaserver3)'
*.LOG_ARCHIVE_DEST_1='LOCATION=D:\oracle\product\10.2.0\oradata\archive\arc\ VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES)  DB_UNIQUE_NAME=usaserver3'
*.LOG_ARCHIVE_DEST_2='SERVICE=usaserver LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver'
*.LOG_ARCHIVE_DEST_3='LOCATION=D:\oracle\product\10.2.0\oradata\archive\std\ VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE)  DB_UNIQUE_NAME=usaserver3'
*.LOG_ARCHIVE_DEST_4='SERVICE=usaserver2 LGWR ASYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)   DB_UNIQUE_NAME=usaserver2 REOPEN=600'
*.log_archive_dest_state_1='ENABLE'
*.log_archive_dest_state_2='ENABLE'
*.log_archive_dest_state_3='ENABLE'
*.log_archive_dest_state_4='ENABLE'
STANDBY_FILE_MANAGEMENT=AUTO

Maclean Liu(刘相兵

请将 A备库的 alert.log 和 RSF、ARCH进程的trace文件压缩打包后上传

深圳－刀

刚重启A备库，相关日志如附件。
RSF、ARCH进程的trace文件在备库重启后无相关trace产生。

Maclean Liu(刘相兵

FOR STANDBY A :

Media Recovery Waiting for thread 1 sequence 22195
Fetching gap sequence in thread 1, gap sequence 22195-22294
Wed Apr 04 22:50:20 2012
Completed: alter database recover managed standby database disconnect from session
Wed Apr 04 22:53:23 2012
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 22195-22294
DBID 1342406147 branch 766797318
FAL[client]: All defined FAL servers have been attempted.


FAL_SERVER=usaserver
FAL_CLIENT='usaserver2','usaserver3'


尝试修改 FAL_SERVER='usaserver','usaserver3'
                 FAL_CLIENT='usaserver2'