Re: archive logs are not getting transferred to standby

From: David Barbour <david.barbour1_at_gmail.com>
Date: Fri, 6 Feb 2009 15:13:11 -0500
Message-ID: <69eafc3f0902061213wcef2c40y7aec72f9d0d1e598_at_mail.gmail.com>



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:13:11 CST

Original text of this message