RE: 9i physical standby startup

  • From: <Jay.Miller@xxxxxxxxxxxxxxxx>
  • To: <Roger.Xu@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Sep 2006 15:59:38 -0400

Just to clarify further, the only way to take it out of standby mode is
to issue the ACTIVATE command.

 

Thanks,

Jay Miller

Sr. Oracle DBA

x68355

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Thursday, September 21, 2006 3:54 PM
To: Roger.Xu@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i physical standby startup

 

No, the startup will fail with an error telling you that you have a
standby controlfile.

 

Thanks,

Jay Miller

Sr. Oracle DBA

x68355

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: Thursday, September 21, 2006 3:45 PM
To: Oracle-L@Freelists. Org (E-mail)
Subject: 9i physical standby startup

 

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.

Other related posts: