Path: news.f.de.plusline.net!news-fra1.dfn.de!news-stu1.dfn.de!news.germany.com!postnews.google.com!48g2000cwx.googlegroups.com!not-for-mail
From: "EdStevens" <quetico_man@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: determine if DB is in a DataGuard config
Date: 1 Jan 2007 08:23:47 -0800
Organization: http://groups.google.com
Lines: 39
Message-ID: <1167668627.267801.291120@48g2000cwx.googlegroups.com>
References: <1167510553.685819.72780@h40g2000cwb.googlegroups.com>
   <1167511000.991467@bubbleator.drizzle.com>
NNTP-Posting-Host: 65.82.131.225
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1167668633 4338 127.0.0.1 (1 Jan 2007 16:23:53 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 1 Jan 2007 16:23:53 +0000 (UTC)
In-Reply-To: <1167511000.991467@bubbleator.drizzle.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.9) Gecko/20061206 Firefox/1.5.0.9,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: 48g2000cwx.googlegroups.com; posting-host=65.82.131.225;
   posting-account=U6cb-w0AAABHLCv5oskKmlFGXS7ueXvN
Xref: news.f.de.plusline.net comp.databases.oracle.server:191528


DA Morgan wrote:
> EdStevens wrote:
> > Is there a value that can be queried to absolutely determine if a
> > database is in a DataGuard config?
> >
> > I see a few things in v$database that would *IF* it were not the
> > primary, OR if it were the primary *AND* managed by the DG Broker.  But
> > what if it were the primary and NOT manged by the DG Broker?
>
> desc GV_$DATAGUARD_STATUS
> --
> Daniel A. Morgan
> University of Washington
> damorgan@x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Daniel,

Thanks for the lead.  It was rather interesting running this one down.
Describing it and selecting on it, it appears to be a log of error
messages.  I thought to myself, 'what if it simply hasn't generated any
messages to this?' so went looking for related tables/views -  anything
starting with GV_$DATA%.    the document search at tahiti didn't turn
up any hits.   Initially, I couldn't find anything under dba_objects,
dba_views, dba_tables, or dba_synonyms, until I searached specifically
where owner='SYS'.  Finally found SYS.GV_$DATAGUARD_CONFIG, but am not
sure of it's value either.  Selecting that in a known primary DB
returned two rows, while selecting it in a non-DG setup returned on
row.  I'm not sure if that difference is inherent in the DG setup, or
happens as a result of the way *this* one is set up.

A search of MetaLink for 'GV_$DATAGUARD' turned up no hits.
A search of AskTom for 'GV_$DATAGUARD' turned up no hits.
A search of google turned up (in English) only the reference at PSOUG,
and this thread.