RE: 9i physical standby startup
- From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
- To: Roger Xu <Roger.Xu@xxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 22:19:15 +0200
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Carel-Jan
> Engel
> Sent: Thursday, September 21, 2006 2:53 PM
> To: Roger Xu
> Cc: Oracle-L@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@xxxxxxxxx
>
>
> 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:
