Path: news.f.de.plusline.net!news-fra1.dfn.de!news-lei1.dfn.de!newsfeed.freenet.de!newsfeed0.kamp.net!newsfeed.kamp.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!local01.nntp.dca.giganews.com!nntp.pipex.net!news.pipex.net.POSTED!not-for-mail
NNTP-Posting-Date: Mon, 01 Jan 2007 15:28:43 -0600
Date: Mon, 01 Jan 2007 21:36:13 +0000
From: Niall Litchfield <niall.litchfield@dial.pipex.com>
User-Agent: Thunderbird 1.5.0.7 (X11/20060911)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: determine if DB is in a DataGuard config
References: <1167510553.685819.72780@h40g2000cwb.googlegroups.com>   <1167511000.991467@bubbleator.drizzle.com> <1167668627.267801.291120@48g2000cwx.googlegroups.com>
In-Reply-To: <1167668627.267801.291120@48g2000cwx.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Message-ID: <G92dnRjgzK-W4ATYnZ2dnUVZ8tKsnZ2d@pipex.net>
Lines: 50
NNTP-Posting-Host: 81.179.178.127
X-Trace: sv3-6VXHZzDd0kHjuT4hlHil2WDs83Ndx5Zg0euWGvd9iuWCckz5qbc9eIdzCiBuygPKMjUpmG7Ih+D8Ntc!WLU+M5r+iX6Uu/V53VO8eq3TrlQxydv5rTeIo53ni+JfseeHxQ6R4mY0XXYJPSAqVSwnCRDGAJ1p!8P6ZRDfBplaEGEhoFMlMfvMwlWc=
X-Complaints-To: abuse@dsl.pipex.net
X-DMCA-Complaints-To: abuse@dsl.pipex.net
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.32
Xref: news.f.de.plusline.net comp.databases.oracle.server:191539

EdStevens wrote:
> 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.
> 

Despite the fact that almost all v$ views are simple derivatives of the
GV$ view I usually find it better to search for the v$ version.
searching for v$dataguard_status gives us
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96536/ch343.htm
for the 9i manuals and it will be in the 10g ones as well no doubt.


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info/services