RE: Synopsis of a database crash and recovery (or time to bash

how did you manage to go 18 months without rebooting? about best i can do on sp5 is 2 mos.

-----Original Message-----
From: Stephen Dance [mailto:steved_at_capbankcf.co.uk] Sent: Monday, June 12, 2000 9:18 AM
To: Multiple recipients of list ORACLE-L Subject: RE: Synopsis of a database crash and recovery (or time to bash

IMHO Poorly configured and (or) administered Unix based systems can be just as bad as poorly configured and (or) administered NT based systems.

NT, when setup correctly for Oracle (and any correctly setup server for Oracle, Unix or otherwise, should be dedicated to running Oracle, nothing else), with a good set of correctly configured fault tolerant disks, can be just as reliable as Unix.

In the last 18 months of live running, our NT based database has only had to be rebooted once for a reason attributable to the OS (we've had a couple of hardware failures, but they would have taken out a Unix box as well), and that problem was cured by a scheduled reboot, it hadn't crashed.

If your database is over 100Gb (and ours is approaching that size with approx 100 concurrent users) then Unix is probably the way to go for now - but watch out, NT WILL catch up.

STEVE (donning flameproof suit)

>----------
>From: rsands_at_lendleaserei.com[SMTP:rsands_at_lendleaserei.com]
>Sent: June 12 2000 16:08
>To: Multiple recipients of list ORACLE-L
>Subject: Re: Synopsis of a database crash and recovery (or time to
bash
>
>

snip
>
>NT databases can be dangerous. Not only is the os less reliable,
>(IMHO) the ease of setup can create a false sense of security/
>competence and the defaults are set to keep things simple, not
>always the best approach. I agree with all the 'lessons' that
>have been posted: stay on unix when possible, configure carefully,
>run frequent backups, monitor them closely and test frequently.
>Also, be certain that you and the sys admin really understand
>each other when discussing what's actually behind a mount point!!

>snip

-- 
Author: Stephen Dance
  INET: steved_at_capbankcf.co.uk

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).