Re: Backing up standby db: has stopping recovery prior to backup restriction been removed?
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Thu, 15 Jul 2010 16:12:49 +0200
Not sure about the others, but this one poked me right in the eye:
"Answer
======
The database cannot be in 'read only' and manage recovery in a release less
than 11.2.0.1"
That is completely wrong. Tell them to read up on their own product, called
Active Data Guard, introduced as an 11.1 enterprise edition option. And that
is precisely what it does.
You should probably ask for your SR to be reassigned, or even let a manager
know that you're being given totally wrong information there. Shouldn't
happen IMHO.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Thu, Jul 15, 2010 at 4:04 PM, fmhabash <fmhabash@xxxxxxxxx> wrote:
> The information is contradictory as I have seen it in multiple places. I
> raised a tar with Oracle and they are saying recovery must be stopped with
> 11.2 being the only exception. These are my questions and Oracle's response
> to them. I'm still debating these answers to clear up this contradiction.
>
>
> Question
> ========
> - There is NO need to cancel recovery (managed or manual) before performing
> rman
> based backup while db is MOUNTED.
>
> Answer
> ======
> The database CANNOT be in managed recovery mode if the database is less
> the 11.2.0.1 release.
>
> Question
> ========
> - An rman based backup is valid if the standby db was opened in 'read only'
> mode before backup withOUT stopping recovery (managed or manual).
>
> Answer
> ======
> The database cannot be in 'read only' and manage recovery in a release less
> than 11.2.0.1
>
> Question
> ========
> - Performing user managed backup e.g. cp will ALWAYS require either a
> shutdown or
> cancel recovery first.
>
> Answer
> ======
> yes.
>
>
> Question
> ========
> - In you initial answers, why did you exclude 11.2
>
> Answer
> ======
> Don't understand what the question is. All releases require that you stop
> managed
> recovery except for 11.2
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
