RE: 9i physical standby startup

From: <Jay.Miller_at_tdameritrade.com>
Date: Thu, 21 Sep 2006 16:28:03 -0400
Message-ID: <DDCBD4EBE91C514287DCBCF303EAAFD75BF76D@prdhswsemlmb01.prod-am.ameritrade.com>

My apologies, I was thinking only in the context of the question (which seemed to be concerned about accidentally messing up the standby through issuing a startup command).  

I'd guess SE would support a graceful failover using the pre-Dataguard method of copying the logfiles and recreating the controlfile from a backup to trace. But I don't have an installation to test that either.      

Thanks,

Jay Miller

Sr. Oracle DBA

x68355  

---

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 4:19 PM To: Roger Xu
Cc: oracle-l_at_freelists.org
Subject: 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

Received on Thu Sep 21 2006 - 15:28:03 CDT