Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!s53g2000cws.googlegroups.com!not-for-mail
From: yong321@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Re: DATAGUARD: Primary 2 NODE RAC: Standby Single node Single instance
Date: 7 Jul 2006 11:09:30 -0700
Organization: http://groups.google.com
Lines: 21
Message-ID: <1152295770.376552.95810@s53g2000cws.googlegroups.com>
References: <1152215828.643837.63630@s26g2000cwa.googlegroups.com>
NNTP-Posting-Host: 143.111.141.54
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1152295775 25871 127.0.0.1 (7 Jul 2006 18:09:35 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 7 Jul 2006 18:09:35 +0000 (UTC)
In-Reply-To: <1152215828.643837.63630@s26g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: s53g2000cws.googlegroups.com; posting-host=143.111.141.54;
   posting-account=JpMAKQwAAABLDMST8mNv88o_ATaOYKGK
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:270596

wannabe DBA wrote:
...
> Then on the standby:
>
> SQL>alter database recover managed standby database finish;
> SQL>alter database open read only;
> SQL>select * from testthiscarbuncle;
>
> table does not exist!
>
> It seems the logs are not being applied. Can someone give me some
> pointers as to where i should look to diagnose this issue!!!?

Is there anything in v$archive_gap on standby? Can you check Metalink
Note:232649.1 for any clue? In short, you can wait for 1 minute before
you check if the log is applied. Make sure parameters FAL_SERVER and
FAL_CLIENT are set. If nothing helps, you have to manually apply the
logs by alter database register logfile.

Yong Huang