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

From: Prasad <p4cldba_at_gmail.com>
Date: Thu, 4 Oct 2007 11:30:09 -0700
Message-ID: <666b99c70710041130q71d2db5fi6cba39882710c33e@mail.gmail.com>

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

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

Received on Thu Oct 04 2007 - 13:30:09 CDT