I just reversed the two parameters that David suggested me, *.fal_server=ORCL1 *.fal_client=STDBY and bounced the db,,,and they are working now. Thanks Nilesh On Sat, Feb 7, 2009 at 2:09 AM, nilesh kumar <nileshkum@xxxxxxxxx> wrote: > Hello All, > > It works now, I see the log on stand by. > > Thank you for all you your help > > Thank you David Barbour!! > > Thanks > nilesh > > > On Sat, Feb 7, 2009 at 1:47 AM, David Barbour <david.barbour1@xxxxxxxxx>wrote: > >> Same on your standby. >> >> >> On Fri, Feb 6, 2009 at 3: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 >>>> >>>> >>> >> > > > -- > 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