Re: Standby Database and Oracle Standard Edition 9i

"Tom K" <tomk_at_projectx.com.au> wrote in message news:b6b81b29.0309181451.6f388c45_at_posting.google.com...
> Hi all,
>
> I have a quick question on whether it is possible to set up a Standby
> Database (9i) using Oracle Standard Edition 9i?
>
> I have noticed that I can only use log_archive_dest and
> log_archive_duplex_dest with Oracle Standard Edn and that both these
> can only accept a location on a drive rather than a SERVICE=stdby like
> you could with the log_archive_dest_n parameters.
>
> This means that I can not transport the archive logs to the standby
> database using Oracle Net.
>
> Has anyone come across this scenario before? I have created the
> physical standby database and placed it into managed recovery mode,
> but it does not feed itself the archive logs even when I copy them to
> the standby_archive_dest location. I need to manually perform a
> recovery command to get the archive logs to be applied to the standby
> database?
>
> We are looking at scripting something to get this to automate the
> process. Unfortunately we cannot jump to Oracle Enterprise Edn which
> has all this automated....
>
> Has anybody set up a Standby Database using Oracle Standard Edition?

In a word yes. If you are on Windows I can let you have a look at the scripts I wrote - in fact you can have a copy even if you are on UNIX but it may help less. Either way you can't do managed recovery with STD edition, you have to do manual recovery.

Disadvantages:
It relies on your scripts being correct and understood. It relies on you detecting nologging events, breaks in communication etc. People don't seem to realize it can be done - even Oracle Support when I first enquired about how supported it was said I needed EE. No GUI :(

Advantages:
Can introduce a time delay easily between Main site and Stdby - for those DBA introduced disasters:(
20-30K a processor. :(
No GUI :)

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK