thanks Jerome. I was able to restore the controlfile from the standby controlfile . but while I try to mount .it complains. RMAN> alter database mount; RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of alter db command at 10/04/2007 10:19:41 ORA-01666: controlfile is for a standby database please advise. On 10/4/07, Vitalis Jerome <vitalisman@xxxxxxxxx> wrote: > > You can take it without using rman, directly with sqlplus: > alter database backup controlfile to '...'; > > You may have difficulties later with your new database since this is a > control file from a standby database though. > > You're in a situation where an RMAN catalog would simplify the restore > operation. > > On 10/4/07, Prasad <p4cldba@xxxxxxxxx> wrote: > > 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. > > >