Re: Data Guard query

"Alistair Thomson" <alistair_at_despammed.com> wrote in message news:<bkut03$q7g$1$8302bc10_at_news.demon.co.uk>...
> Hi
>
> O/S Solaris 9
> Oracle 9i release 2, latest patch
>
> I have two identical servers, Sunfire 280R's in a standby configuration. The
> standby configuration was created using the data guard tool. The database
> configuration is in Maximum Availability mode and works okay.
>
> Whilst testing the switchover and Failover I noticed that on rebuilding the
> standby database and switching the databases back to their original
> configuration the parameter
>
> log_archive_dest_3= service="(DESCRIPTION=(ADDRESS_LIST =
> (ADDRESS=(PROTOCOL=tcp)
> (HOST=nell.xynomix.com)(PORT=1521)))(CONNECT_DATA=(SID=prods)
> (ORACLE_HOME=/oracle/product/920)(SERVER=DEDICATED)))",
> ARCH SYNC NOAFFIRM delay=0 OPTIONAL max_failure=0
> reopen=300 register
>
> was set? I already have log_archive_dest_2 set and enabled. Why is this
> being set and from where is it getting the information? It's not set in the
> pfile or spfile! I'm a bit puzzled. I tried removing the entries using
>
> alter system set xxxxxx scope =both;
>
> but when you bounce the database they just come back!
>
> Any thoughts or advice greatly appreciated.
>
> Alistair

Do you have any startup database triggers defined which could alter it?

Regards,

Steve Received on Fri Sep 26 2003 - 09:56:04 CDT