Re: What to Choose ?

Kevin Loney came to visit for a few days last year and I spoke about HA with him. We're running on Sun/Sparc, fairly new hardware (and Sun disks [grrrrrrr]). Kevin asked me to list each failure. They clustered around the disks: losing a cable, controller problem.

"Why, then" he asked, "would you go OPS for HA?"

We are very happy with the HA path we chose: Fiber Channel, filesystem mirroring. When node A has a problem, we export the filesystems from node A, import them into node B, start Oracle on node B. Oracle looks around, sees a crashed database, performs instance recovery. We don't have autofailover of sessions, don't need it.

The Fiber Channel, filesystem mirroring also allows me to have a reporting database every day: form a mirror, break the mirror, scp a copy of the control file and archived redo logs (after a bunch of log switches on production). We start up the reporting database, recover it, open for business. ----- Original Message -----
From: Jain, Akshay <Akshay.Jain_at_cit.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, August 30, 2000 3:27 PM Subject: RE: What to Choose ?

> I thought that Oracle parallel server meant multiple processing
> nodes mounted onto the same disk farm. Thus disk failures would show
> up in all instances. Also, if different instances are accessing
> the same data block, one has to wait for the other to finish with it,
> making OPS not a proven technology for OLTP (??).
>
> A backup from the hardware end sounds more purposeful towards high
> availability.
>
> P.S. Someone said IBM's HACMP config isn't reliable in having the
> second node mount disks when one node goes down, leaving no access
> to data at all.
>
> Akshay Jain
> _______________________
> Newcourt-CIT
> Tel. (416) 507-5385
> mailto:Akshay.Jain_at_cit.com
> _______________________
>
>
> -----Original Message-----
> Sent: Friday, August 25, 2000 6:02 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> WE are looking at "high availability".I need some help to decide
> whether to go for
> a High Availability Sun cluster with backup server or for Oracle parallel
> server.
> Keeping the key word in mind what would u people advice ?
> I would be happy if you can provide any links to the mentioned Subject.
> Thanks,
> Kamal
> --
> Author: Kamalakannan, D (CAP, GCF)
> INET: D.Kamalakannan_at_gecapital.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Author: Jain, Akshay
> INET: Akshay.Jain_at_cit.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Aug 31 2000 - 13:05:36 CDT