Re: Applying Archive Logs for STANDBY Database

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
>

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