RE: archive logs are not getting transferred to standby

From: Klonicki, Stephen A <SKLONICK_at_tycoelectronics.com>
Date: Fri, 6 Feb 2009 14:26:52 -0500
Message-ID: <D00A9309AEEDEC4387F2751F859B210104AFFB78A6_at_us194mx002.tycoelectronics.net>

On production, please run the following from sqlplus: select dest_id, status, error from v$archive_dest;

Let's make sure production is trying to send the logs, and if so, is it able to send the logs to the standby.

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of nilesh kumar Sent: Friday, February 06, 2009 2:17 PM
To: ORACLE-L
Subject: archive logs are not getting transferred to standby

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:26:52 CST