Re: Implementing Redundant Systems

Ronnie Yours wrote:

> Hi,
>
> We have OAS4.0 running as a web server and oracle 8.1.7 as a database
> server. This web server points to the database server.
>
> Whenever OAS or the database server is down our website is down completely.
> We need to have a setup where the downtime is not much... say 1/2 hour at
> the max.
>
> Whats the best way to implement redundant systems so that we have our site
> up and running most of the time. We are looking for redundancy for both OAS
> and the database server.
>
> I suggested Standby databases for the database to the management but one of
> my coworkers suggested that we do Mirroring of servers... Both OAS and the
> database server should be mirrored on a seperate machine.(We have windows
> 2000)
>
> I am not sure how good this solution is and what will be the issues we will
> face. I am not even sure whether its even good for the Databases( If that
> was the case why would oracle provide standby database feature)
>
> Also can you please suggest the alternatives I have.
>
> Thanks
> Ronnie
>

Mirror solves hardware related problems. Standby db solves, if made clever with sufficient delay on archiving, both hardware and the very bad *operator/human* errors. But stdby is more work, rebuilding former production system to be new stdby system, for every switch U make. Some human errors can be avoided by having a schema or instance trigger on whenever drop.
The *famous* oracle guru reply: IT DEPENDS!

/svend Received on Mon Oct 21 2002 - 13:47:16 CDT