windwos+oracle9i dataguard 關(guān)于歸檔先后順序的問題

lwtianxie

我發(fā)現(xiàn)日志中總是先歸檔到遠(yuǎn)程，然后再歸檔到本地，如何才能讓其先歸檔本地，再歸檔遠(yuǎn)程啊

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
我的兩個參數(shù)這樣設(shè)置的：
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;

查了資料，說默認(rèn)是先歸檔dest_1,再歸檔DEST_2的啊，我的怎么不是這樣的

lwtianxie

找到問題的原因了

9i中若dg的remove archive stuck卡住可能即便在Max Performance最大性能模式下也會導(dǎo)致Primary database 主庫的local archive 本地歸檔無法正常進(jìn)行， 進(jìn)而導(dǎo)致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.



這個隱藏參數(shù)可以控制ARCH歸檔進(jìn)程優(yōu)先完成本地歸檔local archive工作，這樣就避免了本地重做日志長期無法歸檔造成數(shù)據(jù)庫無響應(yīng)。