Re: 8i Standby Problem
- From: Jose Luis Delgado <joseluis_delgado@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 18 May 2004 11:59:13 -0700 (PDT)
Hi Robert...
see in-lines...
--- Robert Pegram <pegramrg@xxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
