Re: 24x7 with full backup

ga wrote:
>
> My company just made a decision to go 24x7 with oracle 8.0.5.
>
> I am stuck with finding out if there is an easy way (i know that within
> oracle nothing is every easy) to get an oracle server up with 24 hours -
> 7 days a week access. And if the server dies, be back up - with minimum
> data loss within 1/2 hour.
>
> I have heard about oracle 8 with enterprise server and replication.
>
> Does that sound like the right path?
>
> I have no experiance with replication and do not know what its
> performance is or how complicated it is to:
> set up
> manage
> cut over to backup if the primary is down
> go back to primary when it is up to date
>

I would explore other options ... It is an option but it requeires a good
bit of maintenance ... I would consider updatable snapshots if you were going this route ... read only would be better but would be switchover nightmare

I recommend hot standby database ... the new 8i features are great as it allows the db to be opened read only (export) and can be returned to recovery mode ... it also has features that assist in auto recovery ...

I have seen others use a shared drive system and then failover to a new box ... but if the disk is gone ...

--
-Kevin Cook Received on Mon Apr 19 1999 - 07:33:06 CDT