Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i RMAN restore to a different server with a backup from dataguard env
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-lReceived on Thu Oct 04 2007 - 13:30:09 CDT
![]() |
![]() |