Re: Determining dataguard protection mode

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<40f7d930$0$4219$626a14ce_at_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

Im am not only ashamed that I didn't see it myself, but also

truly yours

Albert Received on Fri Jul 16 2004 - 16:39:14 CDT