Re: Archiver error on logical standby database

No, I haven't seen it -- but I haven't been looking from the same place as you. %-)

One problem, which may or may not relate to the symptom you describe, is that you are over-using the FRA parameters (quote from the documentation):

"Flash recovery area destinations specified with the STANDBY_ARCHIVE_DEST parameter on logical standby databases (SQL Apply) are ignored."

Beyond that, is your error reproducible (in other words, what if anything special was in log seq 176)?

Are you using a shared flash recovery area? (funny, I can't find any useful documenation on that as it pertains to logical standby). Does your configuration need to be so complicated?

Stalin wrote:

> Hi All,
>
> Has anyone seen this behaivour with logical standby database in max.
> performace mode with standby redologfiles.
>

[...]
> Anyone seen this ?
>
> necessary DG parameters in standby database :
>
> *.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST
> VALID_FOR=(ONLINE_LOGFILES, ALL_ROLES) DB_UNIQUE_NAME=dogstdby'
> *.log_archive_dest_2='SERVICE=dogbert VALID_FOR=(ONLINE_LOGFILES,
> PRIMARY_ROLE) DB_UNIQUE_NAME=dogbert'
> *.log_archive_dest_3='LOCATION=USE_DB_RECOVERY_FILE_DEST
> VALID_FOR=(STANDBY_LOGFILES, STANDBY_ROLE) DB_UNIQUE_NAME=dogstdby'
> *.log_archive_dest_state_1='ENABLE'
> *.log_archive_dest_state_2='ENABLE'
> *.log_archive_dest_state_3='ENABLE'
> *.standby_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'
>
>
> Regards,
> Stalin
> Version : 10g(10.1.0.4)/Sol 5.9
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Mark Bole
http://www.bincomputing.com



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