RE: 9i physical standby startup
- From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
- To: <Jay.Miller@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Sep 2006 15:10:50 -0500
Thanks - Now I had another problem:
* on primary: alter system set log_archive_dest_state_2=defer scope=both;
* on primary: alter system switch logfile;
* on standby: alter database recover managed standby database cancel;
* on standby: shutdown immediate;
* on standby: startup nomount;
* on standby: alter database mount standby database;
* on standby: alter database recover managed standby database disconnect from
session;
* on primary: alter system set log_archive_dest_state_2=enable scope=both;
* on primary: alter system switch logfile;
Immediately, I saw the following in the alert log - I guess this is normal?
Thu Sep 21 14:50:10 2006
Errors in file /SRV_ACE/server/database/bdump/srv_ace_arc0_16980.trc:
ORA-03113: end-of-file on communication channel
BTW, is this the right procedure to shutdown a standby?
Thanks,
Roger
-----Original Message-----
From: Jay.Miller@xxxxxxxxxxxxxxxx [mailto:Jay.Miller@xxxxxxxxxxxxxxxx]
Sent: Thursday, September 21, 2006 3:00 PM
To: Roger Xu; oracle-l@xxxxxxxxxxxxx
Subject: RE: 9i physical standby startup
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.
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:
