RE: archive logs are not getting transferred to standby

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Fri, 6 Feb 2009 14:21:28 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F237FF691_at_US-BOS-MX011.na.pxl.int>

How are log_archive_dest_x set on the primary?? It's the primary's responsibility to transfer the logs, not the standby's. Also what is fal_server and fal_client set to on both?? And log_archive_config??  

Dick Goulet  

---

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:21:28 CST