From your primary pfile; *.fal_server=STDBY *.fal_client=ORCL1l Switch those around - they're backwards. On Fri, Feb 6, 2009 at 2:56 PM, nilesh kumar <nileshkum@xxxxxxxxx> wrote: > yes..I can tnsping the standby, in my case both are on the same server. > > D:\>tnsping stdby > > TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on > 07-FEB-2 > 009 01:25:23 > > Copyright (c) 1997, 2005, Oracle. All rights reserved. > > Used parameter files: > D:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora > > > Used TNSNAMES adapter to resolve the alias > Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = > w2xz6nj5 > 01.apac.corp.eds.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) > (SERVIC > E_NAME = stdby))) > OK (30 msec) > > Thanks > Nilesh > > > On Sat, Feb 7, 2009 at 1:23 AM, Bradd Piontek <piontekdd@xxxxxxxxx> wrote: > >> I'll ask the obvious question. Can you reach the standby from the primary >> by using the "STDBY" service name? >> i.e. tnsping stdby >> 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:43 PM, nilesh kumar <nileshkum@xxxxxxxxx> wrote: >> >>> Attach are the pfiles of both standby and primary. >>> >>> >>> On Sat, Feb 7, 2009 at 12:56 AM, Klonicki, Stephen A < >>> SKLONICK@xxxxxxxxxxxxxxxxxxx> wrote: >>> >>>> 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@xxxxxxxxxxxxx [mailto: >>>> oracle-l-bounce@xxxxxxxxxxxxx] *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 >>>> >>>> >>> >>> >>> -- >>> Thanks >>> Nilesh Soni >>> Oracle DBA--OCA 10g >>> Oracle is not a magic..it takes years of experiance :-) >>> 9860584034 >>> >>> >> > > > -- > Thanks > Nilesh Soni > Oracle DBA--OCA 10g > Oracle is not a magic..it takes years of experiance :-) > 9860584034 > >