Re: archive logs are not getting transferred to standby
- From: David Barbour <david.barbour1@xxxxxxxxx>
- To: nilesh kumar <nileshkum@xxxxxxxxx>
- Date: Fri, 6 Feb 2009 15:46:48 -0500
Yeah, but Brad was right. No excuse, but I'm sitting a class for SAP
Developers right now and I shot from the hip. Keep it the way you have it
on the primary.
On Fri, Feb 6, 2009 at 3:43 PM, nilesh kumar <nileshkum@xxxxxxxxx> wrote:
> 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
>
>
Other related posts:
