Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 9i Physical Standby failover
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-lReceived on Mon Oct 09 2006 - 15:05:17 CDT
![]() |
![]() |