Re: archive logs are not getting transferred to standby

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 6 Feb 2009 13:25:31 -0600
Message-ID: <e9569ef30902061125yee851beg1afae89899d9ffe5_at_mail.gmail.com>

Can you post what Richard asked for, as well as some excerpts from the alert logs on both the primary and standby? You should see errors there.

Are you using a dataguard broker?
what is standby_archive_dest set to?
what is the value of log_archive_dest_state_<n> on the primary? It should be ENABLE.
Bradd Piontek
  "Next to doing a good job yourself,

        the greatest joy is in having someone
        else do a first-class job under your
        direction."

• William Feather

On Fri, Feb 6, 2009 at 1:17 PM, nilesh kumar <nileshkum_at_gmail.com> wrote:

> Hello All,
>
> Good Afternoon!!
> Hope Every one is doing great and preparing for the Weekend!!
>
> I have a issue with the dataguard,
>
> The logs are not gettitng transferred in the Standby database from the
> primary.
>
> The screen shot of STDBY database is as below.
>
> SQL> show parameter log_archive_dest_1;
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> log_archive_dest_1 string
> LOCATION=D:\oracle\product\10.
>
> 2.0\flash_recovery_area\stdby\
> ARCHIVELOG
> VALID_FOR=(ALL_LOGF
> ILES,ALL_ROLES)
> DB_UNIQUE_NAME
> =STDBY
> log_archive_dest_10 string
> SQL> show parameter log_archive_dest_2;
>
> NAME TYPE VALUE
> ------------------------------------ -----------
> ------------------------------
> log_archive_dest_2 string SERVICE=orcl1 LGWR ASYNC
> VALID
>
> _FOR=(ONLINE_LOGFILES,PRIMARY_
> ROLE) DB_UNIQUE_NAME=orcl1
>
>
> =============================================================================
>
> how do I solve this problem ? I am using this for the first time.
> Even after doing the "alter system switch logfile"; I do not see any logs
> that are transferred to the standby.
>
> How should i solve this problem...
>
>
> --
> Thanks
> Nilesh Soni
> Oracle DBA--OCA 10g
> Oracle is not a magic..it takes years of experiance :-)
> 9860584034
>
>

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

Received on Fri Feb 06 2009 - 13:25:31 CST