Re: 8i Standby Problem

From: Jose Luis Delgado <joseluis_delgado_at_yahoo.com>
Date: Tue, 18 May 2004 11:59:13 -0700 (PDT)
Message-ID: <20040518185913.21865.qmail@web41003.mail.yahoo.com>

Hi Robert...

see in-lines...

Robert Pegram <pegramrg_at_yahoo.com> wrote:
> OS: Solaris 8
> Database: 8.1.7.4 - physical standby configuration:
>
> The primary database received "ARC2: Failed to
> archive log# 3 seq#
> 20878" messages, and would only allow internal
> connections.

However, more lines below, in your alert.log file, you should see the 'log#3, seq# 29878 ARCHIVED' message.

> It
> appeared to be a problem archiving to the standby
> server (see sequence
> of events below). Why would the primary instance
> "freeze" if the
> standby was set up as optional?

some of the problems that I know with standby db servers is: network unreachable, or RFS not in sync with the primary db. It is a bit strange that your primary db get freeze if you say that there is enough space...

> 8. Changed init.ora to comment out standby database
> info:
> #log_archive_dest_2 = "SERVICE=XXXXXX_STDBY OPTIONAL
> REOPEN=300"
> #log_archive_dest_state_2 = ENABLE
> #log_archive_min_succeed_dest = 1
> 9. Bounced database - all is ok.
> 10. Changed init.ora archive dest to orig location -
> bounced database -
> all is OK

I think that you do not need to bounce your database...
try with:

sql> alter system set
sql> log_archive_dest_state_2 = defer;

then, after reviewing the cause, try:

sql> alter system set
sql> log_archive_dest_state_2 = enable;

NOTE that to diagnose problems with your primary and standby databases, you should check v$archive_dest view. It will give you more info about the problem.

> I have a theory, but management wants a definite
> answer before we turn
> the standby back on.
>

well, mine is that it was a sync prob... but, you need to look further.

HTH
JL

Do you Yahoo!?
SBC Yahoo! - Internet access at a great low price. http://promo.yahoo.com/sbc/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue May 18 2004 - 13:56:03 CDT