Re: Thoughts on Enterprise manager

I used Dataguard 9i on Release 1 and Release 2 ... In short : DG on 9iR1 - the DG manager is waste of time and effort ... you still need to perform failovers and switchovers manually - meaning, logging on using sqlplus - check active sessions - commit to failover etc
And on AIX the damn DG events would not work in EM. So I had to create some scripts for
archive gap detection (v$archive_gap)

On 9iR2 however it's very impressive ... the DG manager enables you to perform graceful/force
failovers, switchovers en switchback using just a *button* in the GUI - it then submits
jobs to the agent on the node which in turn does all the work for you - and it actually
works quite nicely ....
The monitor events also worked as they supposed to...

"steve deno" <sldcrew2k_at_yahoo.com> wrote in message news:8e6b14d8.0209170801.7a8ee75a_at_posting.google.com...
> Man, That's good news! It shows that the pains I'm going through
> right now should pay off.
>
> Have you ever done dataGuard? Anyone?
>
> Sean
> "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message
news:<3d86f7b5_at_dnews.tpgi.com.au>...
> > I find the 9i release of Enterprise Manager to be (gasp!) a thoroughly
> > delightful and useful tool. As a die-hard command line fan, it's taken
me a
> > while, but I think it's finally there. It still has its oddities (trying
to
> > actually view any information the Logminer Viewer attempts to display is
a
> > battle and a half, as an example), but you live with it for the many
other
> > benefits.
> >
> > Regards
> > HJR
> >
> >
> > "steve deno" <sldcrew2k_at_yahoo.com> wrote in message
> > news:8e6b14d8.0209161250.1df5f1e9_at_posting.google.com...
> > > I am curious what people think of Oracle Enterprise manager. Which
> > > experienced DBA's out there use it to manage databases.
> > >
> > > I am setting up an environment with 3 instances(1 data warehouse, and
> > > one OLTP with a standby) These will all be 9.2 on Solaris 9. Up
> > > through 8i I often found that keeping agents and data gatherers, and
> > > alerts running proved to be a sort of a headache so I just wrote UNIX
> > > scripts for notifications/jobs/backups, etc. What I'm wondering is:
> > > Are there significant numbers of experienced DBAs who get a lot out of
> > > OEM? Is it the way to go if you are doing a logical standby database
> > > with Dataguard?
> > >
> > > Any thoughts are welcomeed. Thanks
Received on Tue Sep 17 2002 - 15:00:03 CDT