Re: Implementing Redundant Systems

Ronnie,
You might be interested to know that with Oracle 9i, if you add a datafile to the primary database the standby database can be configured to automatically add the datafile as well. I configure my standby instances this way in order to reduce the DBA workload. I also use a series of menu driven Perl scripts to automate much of the setup and switchover tasks as well.
So if it has any bearing on your procedures, you might consider 9i as it does reduce some of your workload of managing a standby db. Here are some scripts which perform this setup:

http://www.dotcomsolutionsinc.net/products/installgen/installgen_files_sol90 1.html

Advanced Replication can be another alternative to consider using as well:

http://www.dotcomsolutionsinc.net/support/repgen/repgen_tn_replication_desig n.html

David Simpson
www.dotcomsolutionsinc.net
(Oracle Replication Consulting & Tools)

"Ronnie Yours" <ronnie_yours_at_yahoo.com> wrote in message news:ap12o1$ljf$1_at_nntp-m01.news.aol.com...
> 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
>
>
Received on Tue Oct 22 2002 - 15:15:15 CDT