Re: archive logs are not getting transferred to standby

From: nilesh kumar <nileshkum_at_gmail.com>
Date: Sat, 7 Feb 2009 01:24:22 +0530
Message-ID: <7877ab4b0902061154s602782fal3b3703ef46c045e3_at_mail.gmail.com>



Please let me know if there are difficulty in opening those files. I'll resend the text format.

Thanks
Nilesh

On Sat, Feb 7, 2009 at 1:13 AM, 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 - 13:54:22 CST

Original text of this message