Hi Jerome. Can I take a backup of a controlfile from standby db. ??? it errors out though.not sure if there is any other syntax available. RMAN> backup current controlfile; Starting backup at 04-OCT-07 allocated channel: ORA_DISK_1 channel ORA_DISK_1: sid=20 devtype=DISK channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 10/04/2007 10:16:24 ORA-00236: snapshot operation disallowed: mounted controlfile is a backup On 10/4/07, Vitalis Jerome <vitalisman@xxxxxxxxx> wrote: > > Hi, > > Have you tried restoring the control file from a control file backup > taken on the standby database? > > On 10/2/07, Prasad <p4cldba@xxxxxxxxx> wrote: > > Hi Jerome, > > > > I checked again the permission of the backup piece and directory and > looks > > Ok. I mentioned I was able to do the controlfile restore from the > > controlfile backuppiece. and I found that the controlfile backup doesnot > > store the datafiles backed up on standby if it is not connected to > catalog . > > So I do not really know what are my options here. > > > > thanks > > -Prasad > > > > > > > > On 10/2/07, Vitalis Jerome <vitalisman@xxxxxxxxx> wrote: > > > On 10/1/07, Prasad <p4cldba@xxxxxxxxx> wrote: > > > > Hi Jerome. > > > > > > > > There is no error on the output . > > > > > > Ah. > > > > > > > it just say that file not found . > > > > > > That's an error, isn't it? > > > > > > >somehow > > > > it is not able to catch the backup piece that was done on standby > server > > . > > > > any ideas. > > > > > > RMAN can't see those backup pieces? Have you checked the directory and > > > file permissions? > > > > > > > >