Are you sure about that? The Fal_server is where the standby will request logs from fal_client is used to identify who you are. and should match one of the entries in log_archive_config It would be awesome to see the alert log errors from the primary. Do you have a password file on the standby. Is the password for SYS the same ? 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 2:13 PM, David Barbour <david.barbour1@xxxxxxxxx>wrote: > 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 >> >> >