Re: 9i Physical Standby failover

Either take care of getting all redo to the standby (do you have standby redo log files implemented) or do an 'alter database activate standby database'

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Mon, 2006-10-09 at 14:54 -0500, Roger Xu 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
>
>
> SQL> shutdown immediate;
> ORA-01109: database not open
>
>
> Database dismounted.
> ORACLE instance shut down.
> SQL> startup
> ORACLE instance started.
>
> Total System Global Area 420480856 bytes
> Fixed Size 730968 bytes
> Variable Size 117440512 bytes
> Database Buffers 301989888 bytes
> Redo Buffers 319488 bytes
> ORA-01666: controlfile is for a standby database
>
>
> SQL>
>
> This e-mail is intended solely for the person or entity to which it is
> addressed and may contain confidential and/or privileged information.
> Any review, dissemination, copying, printing or other use o
> ____________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email
> Security System.

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