Re: Recovery performance of standby databases

There's a media recovery performance paper that may be useful at http://www.oracle.com/technology/deploy/availability/pdf/MAA_WP_10gRecoveryBestPractices.pdf

Doug.

Chloe C wrote:
> Hi
>
> Does anyone have an idea as to why managed recovery would be
> significantly quicker than 'ordinary' recovery of a 9.2 standby
> database? I've really noticed it this week as I try to catch-up a
> standby database following a 2-week outage from hardware failure.
>
>
> The SQL statements are:-
> Managed:-
>
> ALTER DATABASE
> RECOVER MANAGED STANDBY DATABASE
> DISCONNECT FROM SESSION
>
>
> Ordinary:-
>
> RECOVER AUTOMATIC STANDBY DATABASE PARALLEL
>
> I can't imagine that using ALTER DATABASE and DISCONNECT FROM SESSION
> would make a lot of difference, and the PARALLEL clause was intended
> to make things faster.
>
> All I can think of is that normally the log file is scanned prior to
> the update beng applied and this is done during log shipping for
> managed recovery - but this is pure guesswork.
>
>
> Does anyone have any configuration tweaks for improving recovery
> performance in this sitiuation? There doesn't seem to be a lot of
> information in the manuals
Received on Thu Dec 07 2006 - 16:47:39 CST