Re: Standby Database performance
- From: kapil vaish <kapilvaish1@xxxxxxxxx>
- To: "deshpande.subodh@xxxxxxxxx" <deshpande.subodh@xxxxxxxxx>
- Date: Wed, 23 Nov 2011 10:32:56 -0800 (PST)
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@xxxxxxxxx>
To: kapilvaish1@xxxxxxxxx
Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx>wrote:
> rightoo alan :)
>
>
> On 23 November 2011 19:23, Guillermo Alan Bort <cicciuxdba@xxxxxxxxx>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@xxxxxxxxx>
>> 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
>> > --
>> > //www.freelists.org/webpage/oracle-l
>> >
>> >
>> >
>>
>>
>> --
>> //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
=============================================
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
