Re: Data Guard Broker 10.2.0.3 and log_archive_dest_n

Hi Pete!

I am indeed using an spfile, but IMO for a parameter to be effective data guard needs to do the alter system set ... scope=both, otherwise I'd have to bounce the instance. Interesting point though, I'll have a look at v$spparameter to see if the situation is the same there.

TA,

Martin

Pete Sharman wrote:
> Are you by chance using an SPFILE, in which case the relevant view is
> V$SPPARAMETER?
>
>
>
> Pete
>
>
>
> "Controlling developers is like herding cats."
>
> Kevin Loney, Oracle DBA Handbook
>
>
>
> "Oh no, it's not, it's much harder than that!"
>
> Bruce Pihlamae, long term Oracle DBA
>
>
>
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Jason Heinrich
> *Sent:* Saturday, 1 March 2008 2:59 AM
> *To:* development_at_the-playground.de
> *Cc:* Oracle-L_at_freelists.org
> *Subject:* Re: Data Guard Broker 10.2.0.3 and log_archive_dest_n
>
>
>
> Do you have the same problem if you do a "show parameter
> log_archive_dest" in sqlplus?
>
> On 2/29/08, *Martin Bach* <development_at_the-playground.de
> <mailto:development_at_the-playground.de>> wrote:
>
> However, one thing is quite odd: in the databases' v$parameter views on
> primary and standby I don't find a value for log_archive_dest_n. Here
> you'd normally see a value similar to "service=myServiceDescriptor LGWR
> ASYNC valid_for(....." but not in my case. I know the settings are
> working (show configuration in DGMGRL) but that's still quite
> surprising. I also see lines beginning with "alter system set
> log_archive_dest_2=..." but why don't they appear in v$parameter? I have
> done a quick search on Metalink but did not find anything related to
> this feature.
>
>
>
> --
> Jason Heinrich
>

--
http://www.freelists.org/webpage/oracle-l