Re: archive logs are not getting transferred to standby

*.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_at_gmail.com> 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_at_gmail.com>wrote:
>
>> Same on your standby.
>>
>>
>> On Fri, Feb 6, 2009 at 3:13 PM, David Barbour <david.barbour1_at_gmail.com>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_at_gmail.com>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_at_gmail.com>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_at_gmail.com>wrote:
>>>>>
>>>>>> Attach are the pfiles of both standby and primary.
>>>>>>
>>>>>>
>>>>>> On Sat, Feb 7, 2009 at 12:56 AM, Klonicki, Stephen A <
>>>>>> SKLONICK_at_tycoelectronics.com> 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_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
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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

--
http://www.freelists.org/webpage/oracle-l