Re: dataguard protection mode...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Thu, 28 Oct 2004 17:41:40 +0200
Message-ID: <clr3vl$390$1@nntp.fujitsu-siemens.com>

"Yong Huang" <yong321_at_gmail.com> schrieb im Newsbeitrag news:a8d66634.0410280726.1653d33d_at_posting.google.com...
> "Volker Hetzer" <volker.hetzer_at_ieee.org> wrote in message news:<clq99k$8s5$1_at_nntp.fujitsu-siemens.com>...
> > "Joel Garry" <joel-garry_at_home.com> schrieb im Newsbeitrag news:91884734.0410271615.6c000f88_at_posting.google.com...
> > >
> > > Just FYI, here's some, er, Bufferin:
> > > http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=263542.1
> > Yes, but it's a bit misleading. You *can* change the configuration afterwards, but only through one of
> > the DataGuard interfaces (dgmgrl or the graphical manager).
> >
> > Lots of Greetings!
> > Volker
>
> To both Volker and Joel,
>
> Does that problem only exist if you use Data Guard Broker?
Yes. Or, rather, if you've created a "configuration" in the DataGuard sense and if you've got DMONs running on your databases.

> I always
> use plain sqlplus to manage data guard and I don't have 9i to verify.
Without the DMONs you should be okay.

Do a show parameter dg_ .
if dg_broker_start is false no DMON should be running. Also you can do a
select * from v$bgprocess where name = 'DMON'; if error (col error format 99999) is 0 and paddr is 00 it's not running and has no error.

Lots of Greetings!
Volker Received on Thu Oct 28 2004 - 10:41:40 CDT