Re: Mutiple sessions for Managed Recovery Oracle10gr2

  • From: Harel Safra <harel.safra@xxxxxxxxx>
  • To: Mohammad Rafiq <rafiq9857@xxxxxxxxxxx>
  • Date: Tue, 20 Jul 2010 07:38:40 +0300

If you'll take an incremental backup of the production database you won't
need to apply all those log files.

Harel Safra
(Sent from my phone, excuse the terseness)

ב-20/07/2010, בשעה 00:36, Mohammad Rafiq <rafiq9857@xxxxxxxxxxx> כתב/ה:

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@xxxxxxxxx
To: rafiq9857@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
*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>

Other related posts: