Re: Can I have Standby Server with Oracle SE ?

Hi Hans,

How about the licensing issue of standby server : Is it doubled (since there are 2 servers now)? or any other way ?

Thanks,
Krist

> Well, I actually have such a solution running for a year and a half
> now, implemented in Delphi.
> Apart from a few snags in the beginning it has been running with no
> problems. After a an unintentional reboot the program automatically
> starts the instance in standby mode, that is unless the database has
> been activated of course. Switching log files, copying these and
> recovery are initiated at fixed intervals depending on time of day
> (workload).
> Further my program deletes old archivelogs (>10 days old) at primary
> and standby..
> Activating the standby has been done several times with no problems,
> also semiautomated by delphi.
> The only serious problem in the beginning was copying an archive log
> that wasn't completed by Oracle, causing the recovery process to stop.
> The trick of course is either to insure that archiving has completed
> or alternatively to recopy archivelogs with same name and different
> size and/or time stamp on primary and standby.
>
> The whole programming was actually quite simple and made in a few days
> spare time. And no - I don't have an exorbitant amount of spare time
> ;-)
>
> Yours Hans Erik Busk
> tbf_at_cn.stam.dk
Received on Mon Feb 11 2002 - 01:56:10 CST