windwos+oracle9i dataguard 关于归档先后顺序的问题

lwtianxie

我发现日志中总是先归档到远程，然后再归档到本地，如何才能让其先归档本地，再归档远程啊

ARC0: Beginning to archive log 3 thread 1 sequence 2320
Creating archive destination LOG_ARCHIVE_DEST_2: 'tydg'
Creating archive destination LOG_ARCHIVE_DEST_1: 'G:\ARCH\ARC02320.001'
Tue Mar 27 00:28:04 2012
ARC1: Evaluating archive   log 3 thread 1 sequence 2320
ARC1: Unable to archive log 3 thread 1 sequence 2320
      Log actively being archived by another process
Tue Mar 27 00:28:11 2012
ARC0: Completed archiving  log 3 thread 1 sequence 2320
我的两个参数这样设置的：
alter system set log_archive_dest_1='location=c:\arch' scope=spfile;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=tydg LGWR ASYNC' scope=spfile;

查了资料，说默认是先归档dest_1,再归档DEST_2的啊，我的怎么不是这样的

lwtianxie

找到问题的原因了

9i中若dg的remove archive stuck卡住可能即便在Max Performance最大性能模式下也会导致Primary database 主库的local archive 本地归档无法正常进行， 进而导致Primary db hang挂起。

For 9iR2 (9.2.0.5 and above):

_log_archive_callout=’LOCAL_FIRST=TRUE’

–OR–

alter system set “_LOG_ARCHIVE_CALLOUT”=’LOCAL_FIRST=TRUE’ scope=both;

In Oracle 10g, this parameter is replaced by ‘log_archive_local_first’, which defaults to TRUE.

In Oracle 11g, ‘log_archive_local_first’ has been deprecated.



这个隐藏参数可以控制ARCH归档进程优先完成本地归档local archive工作，这样就避免了本地重做日志长期无法归档造成数据库无响应。