Re: v$instance -- meaning of INSTANCE_ROLE ?

From: Mark J. Bobak <mark_at_bobak.net>
Date: Tue, 15 Mar 2016 15:43:58 +0000
Message-ID: <CAFQ5ACJREPMvsTzrQqjii0HTNgexQs52rxiWz+-Fkx3Jm-4pGA_at_mail.gmail.com>

If you've configured DatsGuard, it indicates whether the instance is primary or standby.

-Mark

On Mon, Mar 14, 2016, 17:55 Brad Peek <dmarc-noreply_at_freelists.org> wrote:

> This is just a curiosity question, but does anyone know under what
> circumstances the INSTANCE_ROLE column in gv$instance would have a value of
> 'SECONDARY_INSTANCE'?
>
> Oracle Doc on that column states:
>
> "Indicates whether the instance is an active instance (
> PRIMARY_INSTANCE) or an inactive secondary instance (SECONDARY_INSTANCE),
> or UNKNOWN if the instance has been started but not mounted".
>
> What is an "inactive secondary instance"?
>
> The value is "PRIMARY_INSTANCE" for all four instances of both my Primary
> and Physical Standby databases. I don't think this column has anything to
> do with Data Guard but I could be wrong and didn't find much of anything
> when I tried a search on MOS or elsewhere.
>
>
> Brad Peek
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Mar 15 2016 - 16:43:58 CET