Re: determine if DB is in a DataGuard config

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. Received on Mon Jan 01 2007 - 10:23:47 CST