RE: 9i physical standby startup

9.2 will issue an error.

10g will automagically mount it in read only mode

There is more than activate. You can also use the 'alter database commit to switchover to standby' on the primary, restart (nomount), 'alter database mount standby database', followed by 'alter database commit to switchover to primary' on the standby, with again a restart. This is a graceful switchover (switch roles between primary and standby) but I'm not sure whether SE supports this. No SE standby at hand to test. EE does.

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===
On Thu, 2006-09-21 at 14:59 -0500, Roger Xu wrote:
> 9.2.0.7.0
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Carel-Jan
> Engel
> Sent: Thursday, September 21, 2006 2:53 PM
> To: Roger Xu
> Cc: Oracle-L_at_Freelists. Org (E-mail)
> Subject: Re: 9i physical standby startup
>
>
>
> Version?
> On Thu, 2006-09-21 at 14:45 -0500, Roger Xu wrote:
>
> > Hi List,
> > To start up a physical standby database, you use "startup
> > nomount" and "alter database mount standby database;" ....
> > What if someone just types in "startup" and hits Enter?
> > Does the standby need to be recreate from zero?
> > Thanks,
> > Roger
> >
> >
> > 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.
>
> ===
> If you think education is expensive, try ignorance. (Derek
> Bok)
> ===
>
> DBA!ert, Independent Oracle consultancy
> Kastanjelaan 61C
> 2743 BX Waddinxveen
> The Netherlands
> tel. +31 (0) 182 64 04 28
> fax +31 (0) 182 64 04 29
> e-mail info.dbalert_at_xs4all.nl
>
>
> 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