RE: Backing up standby db: has stopping recovery prior to backup restriction been removed?
Date: Thu, 15 Jul 2010 17:36:08 +0200
Message-ID: <4814386347E41145AAE79139EAA3989810265B21B6_at_ws03-exch07.iconos.be>
Strange, I have several 10gR2 standby databases of which I take rman backups without stopping the recovery
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of fmhabash
Sent: donderdag 15 juli 2010 16:04
To: Fuad Arshad
Cc: Oracle-L Freelists
Subject: Re: Backing up standby db: has stopping recovery prior to backup restriction been removed?
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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 15 2010 - 10:36:08 CDT