Re: standby database questions

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 26 Jun 2002 20:18:24 +1000
Message-ID: <afc4mj$ppv$1@lust.ihug.co.nz>

"tshen" <tshen01_at_hotmail.com> wrote in message news:sO7S8.14075$5M2.717401_at_news4.srv.hcvlny.cv.net...
> hi, guys:
>
> We use oracle 8.1.7, we have built a standby DB on remote host in
> "managed mode", it
> will automaticly apply the primary database's redo log, but I have some
> questions:
>
> 1) The primary db will hang, if the network between primary and standby
> machine has the problem. if this is true how can we overcome this?

It's not true, so don't panic. It's all to do with whether you configure your archive destinations as 'MANDATORY' or 'OPTIONAL'. Failure to archive to a mandatory destination will indeed hang your primary. But if you make that destination optional, it won't. OPTIONAL happens to be the default.
>
> 2) after I alter standby database into "managed" mode,why the SQL prompt
> hanging there forever to wait primary db's redologs come? should I prevent
> this happenning?
>

Live with it - it's a feature. Until you get to 9i, where you can say 'recover managed standby database disconnect', which gives you your session back and does recovery in the background.

> 3) how can I do, if I have more than one db_file or log_file names to
> convert?
>
> for example: primary standby
> db file1: /oracle/data/xyz.dbf
/oracle/misc/xyz.dbf
> db file2: /export/data/abc.dbf /oraclee/data/abc.dbf
>

Yup... there are parameters to deal with this, too. A question of reading the manual, I think.

Regards
HJR
> Thanks.
>
> Tao
>
>
Received on Wed Jun 26 2002 - 05:18:24 CDT