Re: Applying Archive Logs for STANDBY Database
- From: "Andrey Kriushin" <Andrey.Kriushin@xxxxxxxx>
- To: bnsarma@xxxxxxxxx
- Date: Fri, 28 Apr 2006 02:07:32 +0400 (MSD)
Hi,
Well, 450 "interval" checkpoints in 150 (or you mean 138?) minutes might
me too much. Not only the server should write down all the dirty blocks,
but also update all the datafile headers and the controlfiles. And until
then it can't proceed with the next archived log.
Suggestions for next time:
1. trace MRP process to see what it is actually waiting for. Or you can
monitor V$SESSION_EVENT
2. agree - applying redo in parallel is rather good suggestion. Don't
forget to increase PARALLEL_EXECUTION_MESSAGE_SIZE up its maximum
3. add more DBWRs if you don't use AIO.
4. increase the size of your online redo logs on primary DB in order to
decrease the frequency of standby DB checkpoints.
HTH
- Andrey
On Fri, April 28, 2006 0:32, BN said:
> Greetings
>
> 2 CPU HP-UX 11.11 Oracle 9.2.0.7 STANDBY Database
>
> Applying 450 Archive Logs of 20 MB each took 2.30 hrs,
>
> Is there a way to tune this to cut this time?
>
> --
> Regards & Thanks
> BN
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
