ARC on standby fills Tracefile with useless messages after upgrade to 9.2.0.7

From: dhalek <l.armbruester_at_vertriebsunion.de>
Date: 5 Sep 2005 00:15:34 -0700
Message-ID: <1125904534.831891.212930@g43g2000cwa.googlegroups.com>

Hello out there,

last weekend, I patched our Oracle Databases on W2k from 9.2.0.6 to 9.2.0.7.
As for now everything runs fine but one thing. On the physical standby database, the archiver minutely writes messages in his trace file like the following:

• 2005-09-05 09:03:43.751 Archiving standby database
• 2005-09-05 09:04:43.751 Archiving standby database
• 2005-09-05 09:05:43.752 Archiving standby database
• 2005-09-05 09:06:43.752 Archiving standby database

The initialization parameters on the standby database are as follows:

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
archive_lag_target                   integer     0
log_archive_dest                     string
log_archive_dest_state_1             string      enable
log_archive_dest_state_10            string      enable
log_archive_dest_state_2             string      enable
log_archive_dest_state_3             string      enable
log_archive_dest_state_4             string      enable
log_archive_dest_state_5             string      enable
log_archive_dest_state_6             string      enable
log_archive_dest_state_7             string      enable
log_archive_dest_state_8             string      enable
log_archive_dest_state_9             string      enable
log_archive_dest_1                   string
LOCATION=d:\oradb\archiv
log_archive_dest_10                  string
log_archive_dest_2                   string
log_archive_dest_3                   string
log_archive_dest_4                   string
log_archive_dest_5                   string
log_archive_dest_6                   string
log_archive_dest_7                   string
log_archive_dest_8                   string
log_archive_dest_9                   string
log_archive_duplex_dest              string
log_archive_format                   string      ARC%S.%T
log_archive_max_processes            integer     2
log_archive_min_succeed_dest         integer     1
log_archive_start                    boolean     TRUE
log_archive_trace                    integer     0
remote_archive_enable                string      receive
standby_archive_dest                 string

d:\oradata\standby\archiv

These did not change after or during the patch. In the log_archive_dest_1 no files are written. I'm thinking of disabling the archiver on the standby site but I think this would not be a good idea when failover occurs since then no archiving would take place.
Is there a better way to stop ARC writing these IMHO useless messages into his trace?

Many thanks in advance,
Lothar Received on Mon Sep 05 2005 - 02:15:34 CDT