Re: 9i RMAN restore to a different server with a backup from dataguard env

  • From: Prasad <p4cldba@xxxxxxxxx>
  • To: "Vitalis Jerome" <vitalisman@xxxxxxxxx>
  • Date: Thu, 4 Oct 2007 11:30:09 -0700

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

Other related posts: