Re: putting standby into a backup mode

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_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).

Don.

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
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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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


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