Re: determine if DB is in a DataGuard config

From: EdStevens <quetico_man_at_yahoo.com>
Date: 2 Jan 2007 05:40:13 -0800
Message-ID: <1167745213.621459.295130@i12g2000cwa.googlegroups.com>

Niall Litchfield wrote:
> 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_at_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

Ah... I had forgotten that the v$ views are derivatives of the GV$ views. One of those 'use it or lose it' deals. Following the leads on that quickly took me to the LOG_ARCHIVE_CONFIG parm. Looks like that will be my most reliable indicator of whether or not a given DB is a DataGuard primary. Received on Tue Jan 02 2007 - 07:40:13 CST