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.