Re: archive logs are not getting transferred to standby
Date: Sat, 7 Feb 2009 01:26:44 +0530
Message-ID: <7877ab4b0902061156kcc4e5b3l99003a61956800f5_at_mail.gmail.com>
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-lReceived on Fri Feb 06 2009 - 13:56:44 CST