RE: 9i Physical Standby failover

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96653/sql_stmts.htm#1007811

It effectively is an incomplete recovery and performs a resetlogs, rendering your primary and other standby databases (if present at all) unusable.
So, after the activate standby database you need to re-instantiate a standby to the primary site, to be able to switch over to the original primary server.

What do you mean with 'the primary is gone'? Is the server accessible? Can you move online redo logs to the standby to complete recovery? Do you have all archived redo available at the standby?

I hope you're testing this with a test database. It is good to prepare for future disasters. I strongly recommend to start this preparation with a careful read of Data Guard Concepts & Administration.

Best regards,

Carel-Jan Engel

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

On Mon, 2006-10-09 at 15:16 -0500, Roger Xu wrote:
> I do not have standby redo log files implemented.
>
> What does 'alter database activate standby database' do?
> The original primary is gone and I want to turn the only physical
> standby to production.
>
>
> Thanks,
>
> Roger
> -----Original Message-----
> From: Carel-Jan Engel [mailto:cjpengel.dbalert_at_xs4all.nl]
> Sent: Monday, October 09, 2006 3:11 PM
> To: Roger Xu
> Subject: 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.
>
>
>
>
>
> 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