Re: Standby Database performance

From: kapil vaish <kapilvaish1_at_yahoo.com>
Date: Wed, 23 Nov 2011 10:32:56 -0800 (PST)
Message-ID: <1322073176.42303.YahooMailNeo_at_web111706.mail.gq1.yahoo.com>

Thanks for all the answers, awesome team. Here are some answers to your questions . Manual means thru scripts only, this is not Dataguard . There is no issue in shipping time, we hae plenty archived logs available on the standby server to apply. The lag becomes 30-40 hours in 3-4 days and will continue to grow . This DR  is used for multiple purposes and we can not afford this much lag . This is 3 node RAC BTW.   What we are trying to figure out is that if it is limitation of Oracle and it can not get any better or some other tunings can be checked. We are continously working with our storage/hw teams to take care of any contentions .

---

From: Subodh Deshpande <deshpande.subodh_at_gmail.com> To: kapilvaish1_at_yahoo.com
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Sent: Wednesday, November 23, 2011 9:43 AM Subject: Re: Standby Database performance

just curious to know
why you are doing manual recovery..

why you did not configured to ship and apply the archives..and just monitor the archive gap in primary and standby..

thanks..subodh

On 23 November 2011 23:03, Subodh Deshpande <deshpande.subodh_at_gmail.com>wrote:

> rightoo alan :)
>
>
> On 23 November 2011 19:23, Guillermo Alan Bort <cicciuxdba_at_gmail.com>wrote:
>
>> <disclaimer>this is a strictly unhelpful comment </disclaimer>
>> I'm curious as to why you want to further reduce the apply time. Are you
>> experiencing a delay in the standby because it takes 45 seconds to apply
>> the archivelogs?
>>
>> One of the key concepts of tuning in knowing when to stop, so perhaps if
>> you are experiencing no problems with this apply time it's time to leave
>> it
>> be and move on to the next problem (there's always a next problem...
>> otherwise life would be boring)
>>
>> hope that wasn't too unhelpful
>> Alan.-
>>
>>
>> On Tue, Nov 22, 2011 at 4:23 PM, kapil vaish <kapilvaish1_at_yahoo.com>
>> wrote:
>>
>> >
>> > Hi Guys ,
>> >
>> > we have physical standby database for one of our biggest database.
>> Scripts
>> > ship the archived log to standby server and then using parallel 32,
>> manual
>> > recovery is performed (thru scripts) . Archived log size is 2 GB and
>> daily
>> > production archive generation is aorund 2.5 TB. We are trying to
>> increase
>> > performance on our standby database. We tried tuning various standby
>> > related parameters and IO, maximum apply rate we could achieve is 45 sec
>> > per archive log.  Can you suggest any other tunings you may have seen in
>> > your environments ? any pointers are appreciated ..
>> >
>> > thanks
>> > kapil Vaish
>> > --
>> > http://www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>
> --
> =============================================
> TRUTH WINS AT LAST, DO NOT FORGET TO SMILE TODAY
> =============================================
>

-- 
=============================================
TRUTH WINS AT LAST, DO NOT FORGET TO SMILE TODAY
=============================================


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

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

Received on Wed Nov 23 2011 - 12:32:56 CST