Re: putting standby into a backup mode

  • From: Laimutis.Nedzinskas@xxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 20 Aug 2009 09:05:18 +0300

>You can use RMAN to take backups from a standby no problem, this is
well documented.

Rigth.

>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@xxxxxxxxx>                                               
                                                                        To 
             2009.08.19 15:45          Laimutis.Nedzinskas@xxxxxx,         
                                       oracle-l@xxxxxxxxxxxxx              
                                                                        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).

Don.

On 8/19/09, Laimutis.Nedzinskas@xxxxxx <Laimutis.Nedzinskas@xxxxxx> 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
while
> managed recovery is active.
>
> The first idea is to put primary standby into backup mode so that redo
logs
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>


--
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us.


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


Other related posts: