Re: Determining dataguard protection mode

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Fri, 16 Jul 2004 15:35:34 +0200
Message-ID: <40f7d930$0$4219$626a14ce@news.free.fr>

"Albert Albani" <albanialbert_at_yahoo.de> a écrit dans le message de news:7c2ca73a.0407160247.17bbd11b_at_posting.google.com...
> > "Albert Albani" <albanialbert_at_yahoo.de> a écrit dans le message de
> > news:7c2ca73a.0407150023.4d2a9383_at_posting.google.com...
> > > Hello
> > >
> > > I am unable to find out (in a data guard primary-standby environment),
> > > how one can determine in which of the three distinct modes (Maximum
> > > protection, Maximum availability or Maximum availability) the
> > > environment operates.
> > >
> > > If someone gave me a hint on that....
> > >
> > > Albert
> >
> > v$database.protection_mode/protection_level.
>
> Indeed! Thanks a lot. Yet, I am also stuck determing if it is a physical
> standby or a logical standby database. Another hint, maybe?

v$database.database_role

--
Regards
Michel Cadot

Received on Fri Jul 16 2004 - 08:35:34 CDT