Re: Archiver error on logical standby database

Hi Mark,

i'd this working fine, right before i created standby redolog files on primary/standby databases. After stadby redolog creation, i started to see this error.

yes, this is reproducible with every 2 log switches. Not specific to seq 176.

nope, i'm not sharing FRA. primary and standby has its own FRA destinations.

Regards,
Stalin

On 9/27/05, Mark Bole <makbo_at_pacbell.net> wrote:
> 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
>

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