Re: archive logs are not getting transferred to standby

From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Fri, 6 Feb 2009 14:38:41 -0600
Message-ID: <e9569ef30902061238k6d26bf8q208a2e8fa7f0f0c6_at_mail.gmail.com>

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_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
>>
>>
>

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

Received on Fri Feb 06 2009 - 14:38:41 CST