EasyCFM.COM ColdFusion Forums / Oracle Related Issues / Oracle DB Failure Tracking

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Oracle DB Failure Tracking

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

CFRAM
06-22-2005 @ 2:08 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 42
Joined: Jun 2004

Hi Everyone,

I have two oracle databases. I wanted to dynamically point to another DB if one of the server goes down through coldfusion code. Does anyone know or same situation. Any help pointing to solution is highly appericiated.

Thanks
CFRAM

Webmaster
06-22-2005 @ 8:04 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

ok, this is a tricky situation because you are getting into clustring.

The questions I would have for you first are:

1) Are they mirrored? by this I mean do they have all the data (exactly) the same in both servers?
2) What method are you using to mirror them if the answer is yes?
3) Depending on what you are using to mirror them, most solution then also handle clusting (or load balancing them) in which case it should NOT be done at the CF level, but at the network level.

Thanks,
Pablo Varando
Team Macromedia Member
=====================================================

CFRAM
06-23-2005 @ 1:39 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 42
Joined: Jun 2004

thanks for the reply Pablo.

1. Yes they are mirrored. both have the same data.
2. data gaurd is used for mirroring.
3. they are not clustered since oracle clustering is expensive.

Regards
RAM


Website Designed and Developed by Pablo Varando.