Re: putting standby into a backup mode
Date: Thu, 20 Aug 2009 09:05:18 +0300
>You can use RMAN to take backups from a standby no problem, this is
>If you want to take a user-managed backup
This is the case.
> then you'll want to cancel recovery first
yeah, it's my conclusion too.
> (or take snapshots)
Freezing for Short Time snapshots I want to avoid because supposedly primary-standby is in Maximum Availability mode. Freezing standby effectively freezes LGWR if primary. Please correct me if I am wrong here.
Online snapshots require Oracle database in backup mode or to cancel managed recovery. Q.E.D.
Please consider the environment before printing this e-mail
Don Seiler <don_at_seiler.us> To 2009.08.19 15:45 Laimutis.Nedzinskas_at_seb.lt, oracle-l_at_freelists.org cc Subject Re: putting standby into a backup mode
You can use RMAN to take backups from a standby no problem, this is well documented. If you want to take a user-managed backup then you'll want to cancel recovery first and then copy the datafiles and arch logs (or take snapshots).
On 8/19/09, Laimutis.Nedzinskas_at_seb.lt <Laimutis.Nedzinskas_at_seb.lt> wrote:
> Is it possible to put a standby database in a backup mode?
> The question is weather a hot backup of standby database can be done
> managed recovery is active.
> The first idea is to put primary standby into backup mode so that redo
> contain extra data.
> But my understanding is that standby datafiles headers need to be freezed
> as well. While recovery is active this is not the case, is it ?
> All in all the answer seems to be NO.
> Please consider the environment before printing this e-mail
-- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 20 2009 - 01:05:18 CDT