Re: Suitability of Oracle for 24 hour by 7 day operations

We also have HPUX. We have had Oracle 7 databases up for months at a time. Hot backups and ARCHIVELOG mode provide major protection. Oracle redo logs are both Oracle duplexed and hardwared mirrored. All data files are mirrored.

We use HP's MC ServiceGuard to implement failover support. If a database server machine fails, the alternate machine grabs the disk and IP address and restarts the database. Back in business 10 minutes.

This recovery time suits us, as long as the frequency remains low.

If you cannot stand that long a recovery, Oracle's Parallel Server lets multiple machines share access to the same database. If one dies, the users move to another server machine.

dba wrote:

> Greetings all
>
> I am not an Oracle DBA and have been asked to look at the suitability
> of Oracle in a 24 Hour * 7 Day a week operations. Many of our
> databases etc require max uptime and the most frequent shutdown
> schedule is 1-2 hours once a fortnight.
>
> After an unexpected failure we require rapid database recovery. We are
> a HP-UX site. Ignoring hype is Oracle really suited for 24 hour ops in
> a unix environment?
>
> My email address is dba_at_mailbox.police.qld.gov.au
>
> Thanks in advance
>
> Ross Hall
> DBA Co-ord
> Queensland Police Service
Received on Mon Feb 01 1999 - 21:15:29 CST