Re: Help! Oracle server clustering

"shrinad_at_ora-india.com" <daekw_at_yahoo.com> wrote in message news:afd7ib$65t$04$2_at_news.t-online.com...
> forget all the cluster shit !!!
>
> go for standby database
>
> easy and really unbreakable

This is really funny! Haven't laughed so much in ages. Thanks.

Oh. You were being serious. :-(

Have you ever performed a 'nologging' operation when operating a standby? Guess what? It 'breaks' the standby. Add a datafile, resize a file.... er, yup: same thing.

> put the server in different places, propagate the logfiles over network
>

Ah, log files. You mean those things that store redo. The redo that isn't generated by nologging operations? I, er, can't quite see how non-existent redo can be propagated over the network. Please explain....

> this is the best solution, use the standby server for testing, reporting,
> make a second standby database with delayed log apply, copy a test
database
> from the standby databases, make your backups on the standby
>
> no serious shop should ever be without standby
>

Standby is a wonderful solution, actually. For the right problem. And especially in 9i, with Data Guard. But don't over-egg the pudding: it's not 'unbreakable', has significant management requirements and overhead, and is probably not what our original poster would consider an appropriate solution in the first place.

Regards
HJR
>
> "Thao" <thuthaot_at_hotmail.com> schrieb im Newsbeitrag
> news:1b9e9988.0206260809.4efe5df4_at_posting.google.com...
> > I am looking to have my 8i oracle server run on NT to two compaq Win2K
> > servers that will back-up for each other. I dont' know waht method I
> > use use and what are the advantages/disadvantages?
> >
> > 1. Clustering server or server-mirroring?
> > 2. what tools do I need?
> > 3. Does Oracle 8i support clustering?
> > 4. Any suggestions on using Oracle on Win2K clustering on Fault
> > Tolerance Features?
> >
> > Thanks for any of your feedbacks
> > thao
>
>
Received on Thu Jun 27 2002 - 04:22:30 CDT