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
Received on Mon Jan 01 2007 - 15:36:13 CST
