Re: archive logs are not getting transferred to standby
- From: Bradd Piontek <piontekdd@xxxxxxxxx>
- To: nileshkum@xxxxxxxxx
- Date: Fri, 6 Feb 2009 13:25:31 -0600
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@xxxxxxxxx> 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
>
>
Other related posts:
