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.
> >
>
- Follow-Ups:
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- References:
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Prasad
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Prasad
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
Other related posts:
- » 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- » Re: 9i RMAN restore to a different server with a backup from dataguard env
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Prasad
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Prasad
- Re: 9i RMAN restore to a different server with a backup from dataguard env
- From: Vitalis Jerome