Re: 9i Physical Standby failover
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 09 Oct 2006 22:14:12 +0200
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.
Other related posts:
