Re: 9i Physical Standby failover

hi:

If you active standby database, you need to build a new standby database for the new activated primary database.

I think it's not your original purpose. You planned to do swithover but at last you did activate standby. They are different things.

On 10/10/06, Roger Xu <Roger.Xu_at_dp7upbg.com> wrote:
>
> It's working now - thank you all - Roger
>
> SQL> *alter database mount standby database;*
>
> Database altered.
>
> SQL> *ALTER DATABASE ACTIVATE STANDBY DATABASE;*
>
> Database altered.
>
> SQL> select status from v$instance;
>
> STATUS
> ------------
> STARTED
>
> SQL> *alter database mount;*
>
> Database altered.
>
> SQL> *alter database open;*
>
> Database altered.
>
> SQL> select status from v$instance;
>
> STATUS
> ------------
> OPEN
>
> SQL>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org]*On Behalf Of *Roger Xu
> *Sent:* Monday, October 09, 2006 2:54 PM
> *To:* Oracle-L_at_Freelists. Org (E-mail)
> *Subject:* 9i Physical Standby failover
>
> 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.
>
> 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.
>

-- 
Eagle Fan

Oracle DBA

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