>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