Path: news.cambrium.nl!textnews.cambrium.nl!feeder2.cambriumusenet.nl!feed.tweaknews.nl!postnews.google.com!d27g2000yqn.googlegroups.com!not-for-mail
From: Johne_uk <edgarj@tiscali.co.uk>
Newsgroups: comp.databases.oracle.server
Subject: Re: Problem with 10G Physical Standby Database (archive gap). HELP 
 :-)
Date: Tue, 2 Feb 2010 07:30:12 -0800 (PST)
Organization: http://groups.google.com
Lines: 54
Message-ID: <35bababc-8f3a-4caf-9596-070ba4ac908d@d27g2000yqn.googlegroups.com>
References: <8e3e6c37-d819-4852-9359-a9ae54d56f9e@s12g2000yqj.googlegroups.com>
NNTP-Posting-Host: 213.121.188.67
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1265124612 21039 127.0.0.1 (2 Feb 2010 15:30:12 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Tue, 2 Feb 2010 15:30:12 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d27g2000yqn.googlegroups.com; posting-host=213.121.188.67; 
 posting-account=WBgnVAoAAADz7JcpVItkoi-eX_FYyLlk
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-GB; rv:1.9.1.7) 
 Gecko/20091221 Firefox/3.5.7 (.NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On 2 Feb, 11:28, Johne_uk <edg...@tiscali.co.uk> wrote:
> Hi
>
> I'm having some isses with a 10G physical standby database and an
> archive gap. The standby instance does not use dataguard because of
> bandwidth limitations so instead I periodically copy over and manually
> register any archive logs from the primary instance i.e. alter
> database register physical logfile xxxxx. All of the logs are being
> reported as successfully registered.
>
> I created the standby instance a few weeks ago and all was going well
> until last weekend. I have a daily monitoring script that runs after
> the logs have been copied over and registered which shows the current
> log sequence on both primary/standby instances and checks if there is
> an archive gap. The entries below was the last log before things
> started to go wrong.
>
> Standby Current Log Sequence (DR) : =A0 =A0 =A0 =A0 =A0 =A0 =A014383
> Primary Current Log Sequence (PROD) : =A0 =A0 =A0 =A0 =A0 =A014383
> Archive Gap
> no rows selected
>
> Then an archive gap appeared
> Standby Current Log Sequence (DR) : =A0 =A0 =A0 =A0 =A0 =A0 =A014531
> Primary Current Log Sequence (PROD) : =A0 =A0 =A0 =A0 =A0 =A014531
>
> Archive Gap
> =A0 =A0THREAD# LOW_SEQUENCE#
> HIGH_SEQUENCE#
> ---------- -------------
> --------------
> =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 =A0 13310 =A0 =A0 =A0 =A0 =A013411
>
> The strange thing is the range of logs in the gap were lower than the
> previous day's email that indicated that the current log was 14383 and
> there was no gap. The missing archive logs have now been purged on
> both instances although I may be able to restore from from tape.
>
> NB: Just checked todays logs and now the gap stands at
> THREAD# LOW_SEQUENCE#
> HIGH_SEQUENCE#
> ---------- -------------
> --------------
> =A0 =A0 =A0 =A0 =A01 =A0 =A0 =A0 =A0 13310 =A0 =A0 =A0 =A0 =A013535
>
> This is the first time I've setup a physical standby and most
> documentation assumes I would be using Dataguard. I'd appreciate a few
> pointers on what I may have done wrong as I thought once a logfile had
> been registered then the database would be updated.
>
> Thanks in advance
> John

I re-applied the single 13310 log and the entire gap disappeared.