Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Hot Standby Database & alternatives

Re: Hot Standby Database & alternatives

From: Olivier Bercovitz <oberco_at_club-internet.fr>
Date: Wed, 19 Aug 1998 22:05:00 +0200
Message-ID: <35DB2FEC.5492659F@club-internet.fr>


Hello Andy

We have implemented standby database on Solaris witj Oracle 7.3 You have to manually (by cron for example) copy the archived redo logs from normal db to the standby db and then execute on the standby db the following command (under svrmgrl) : recover standby automatic This operation applies all the archived log to the standby db If you have a crash on the normal db you have to activate the standby db (I don't remember exactly the comand) and then restart the standby db as normal (startup pfile=.... and not startup standby pfile....) After the standby db is mouted, opened and works well as normal your previous normal db is desynchronized exceptif you restart it as standby db and you come back to the beginning :-)

If you want I can mail you our shell scripts

Hope this help's

Regards
Olivier

Andy Moorhouse wrote:

> Hi all. My company want me to implement some form of hot standby for an
> Oracle 7.3 database between 2 RS/6000s. I have read about the hot standby
> feature in the Admin manual, but it is not very detailed. How do people go
> about automatically copying the archived redo logs from one machine to
> another? How are they "applied" to the standby database? Is it possible to
> force a redo log switch every 10 minutes or so? It would be useful to hear
> people's experiences with Hot Standby.
>
> I am also confused about testing the procedure. Is it true that once you
> have switched over to the standby db, your original one is no good, and you
> have to re-copy the standby database onto the live machine? Surely not, I
> hope I have misunderstood this!
>
> Lastly, are there any alternative commercial packages which would let me
> keep a database (and possibly normal Unix files) in sync across a live &
> backup machine?
>
> Thanks, Andy Moorhouse, Guardian Insurance.
Received on Wed Aug 19 1998 - 15:05:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US