Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i Physical Standby failover

Re: 9i Physical Standby failover

From: David Sharples <davidsharples_at_gmail.com>
Date: Mon, 9 Oct 2006 21:05:17 +0100
Message-ID: <be592d550610091305q3ab06d1dqe5c0b55a162a165b@mail.gmail.com>


SQL> *alter database commit to switchover to primary; *alter database commit to switchover to primary *
ERROR at line 1:
ORA-16139: media recovery required

you need to sort that part out, what had you dont previously

On 09/10/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:
>
> Hi,
>
> I am testing failover but getting ORA-1666 error.
> Am I missing something here?
>
> Thanks,
>
> Roger
>
>
>
> SQL> *alter database recover managed standby database finish;*
>
> Database altered.
>
> SQL> *alter database commit to switchover to primary;
> *alter database commit to switchover to primary
> *
> ERROR at line 1:
> ORA-16139: media recovery required
>

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 09 2006 - 15:05:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US