Re: archive logs are not getting transferred to standby
- From: nilesh kumar <nileshkum@xxxxxxxxx>
- To: David Barbour <david.barbour1@xxxxxxxxx>
- Date: Sat, 7 Feb 2009 02:09:21 +0530
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
Other related posts:
