Re: Mutiple sessions for Managed Recovery Oracle10gr2

From: Ravi Madabhushanam <ravi.madabhushanam_at_gmail.com>
Date: Tue, 20 Jul 2010 09:43:00 +0530
Message-ID: <AANLkTikY6JI4iWTMX7OMGeNAN9c5LeJg4qYwOUAiMuwv_at_mail.gmail.com>

There are multiple ways to increase the recovery speed. Few options are:

1. recovery_parallelism - you can set the parameter in init.ora and you can see multiple background mr<n> processes. I cannot quantiy the speed as the difference will not be very huge. This must be less than parallel_max_servers and in turn number of cpu's on the server.
2. Incremental backup for standby - this is the simplest approach with guaranteed results. You have not mentioned the reason for not considering this.
3. If the I/O is very huge on standby environment consider identifying a subset of datafiles on PROD which will have more than 50% changes from recovery and copy those datafiles to standby and restart recovery. this will help you to speed up the process as well.

most importantly, what is the total size of archive logs to be applied ? and what is the database size ? if amount of recovery is more than 70% of database size, recreating standby might be better option.

Thanks,
~Ravi.M

On Tue, Jul 20, 2010 at 3:06 AM, Mohammad Rafiq <rafiq9857_at_hotmail.com>wrote:

> Thanks for sharing. We are still having around 3100+ logs to be applied.
> Meantime normal business actvity is going on as well. which keep generating
> new logs.
>
> Regards
> Rafiq
>
>
> ------------------------------
> From: harel.safra_at_gmail.com
>
> To: rafiq9857_at_hotmail.com; oracle-l_at_freelists.org
> Subject: RE: Mutiple sessions for Managed Recovery Oracle10gr2
> Date: Tue, 20 Jul 2010 00:12:23 +0300
>
>
> Have a look here:
>
>
> blogs.oracle.com/AlejandroVargas/How-To-Synchronize-Standby-When-Logs-Lost.pdf
>
>
>
> it details how to do an incremental backup of the production database to
> catch up a standby when archives logs are lost. You could use it in your
> situation too.
>
>
>
> Harel Safra
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Mohammad Rafiq
> *Sent:* Monday, July 19, 2010 4:44 PM
> *To:* oracle list
> *Subject:* Mutiple sessions for Managed Recovery Oracle10gr2
>
>
>
> Oracle 10gr2 - Linux 64 - 4 Nodes Rac Cluster
>
> Is it possible to start managed recovery sessions from all standby nodes to
> expedite recovery of standby to sync with production. We are far behind in
> recovery as log shipping stopped/hanged and we have to restart prod and
> standby nodes after getting production down time approval last evening. The
> logs accumulated due adding partionioning on prod during weekend.
>
> did googled and searched on MOS but not much help.
>
> Any solution / pointer / guidance shall be appreciated.
>
> Regards
> Rafiq
> ------------------------------
>
> Hotmail has tools for the New Busy. Search, chat and e-mail from your
> inbox. Learn more.<http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1>
>
> ------------------------------
> Hotmail is redefining busy with tools for the New Busy. Get more from your
> inbox. See how.<http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_2>
>

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

Received on Mon Jul 19 2010 - 23:13:00 CDT