Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: 9i physical standby startup

RE: 9i physical standby startup

From: Roger Xu <>
Date: Thu, 21 Sep 2006 15:46:27 -0500
Message-ID: <>

Right after the last command - "* on primary: alter system switch logfile; "  

$ cat /SRV_ACE/server/database/bdump/srv_ace_arc0_16980.trc Dump file /SRV_ACE/server/database/bdump/srv_ace_arc0_16980.trc Oracle9i Enterprise Edition Release - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release - Production
ORACLE_HOME = /oracle/OraHome1
System name: SunOS

Node name:      a632dse0
Release:        5.10
Version:        Generic_118833-03
Machine:        sun4u

Instance name: SRV_ACE
Redo thread mounted by this instance: 0 <none> Oracle process number: 10
Unix process pid: 16980, image: oracle_at_a632dse0 (ARC0)  

TNS Ping Utility for Solaris: Version - Production on 21-SEP-2006 14:52:41  

Copyright (c) 1997 Oracle Corporation. All rights reserved.  

Used parameter files:

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (HOST = (PORT = 1527))) (CONNECT_DATA = (SERVICE_NAME = SRV_ACE))) OK (60 msec)

After a while, everything was back to normal and stays normal.  


[Roger Xu]
 ----Original Message-----
From: Carel-Jan Engel [] Sent: Thursday, September 21, 2006 3:30 PM To: Roger Xu
Cc:; Subject: RE: 9i physical standby startup

Where in the command sequence did you see this message? You don't put timestamps at the 9 commands.

Wat's in the file /SRV_ACE/server/database/bdump/srv_ace_arc0_16980.trc?

I see the 3113's pretty often in my trace's. The shutdown of the standby kills the RFS proces. The primary therefore can no longer communicate with this proces, responsible for receiving the redo and writing it to disk. ORA-3113 is well resembling that state transition.

Maybe I wouldn't defer the destination. Depending on your further settings it will automagically resume once you restart the standby. If you plan to keep the standby shutdown for a longer time deferring makes sense.

Best regards,

Carel-Jan Engel

If you think education is expensive, try ignorance. (Derek Bok) ===

On Thu, 2006-09-21 at 15:10 -0500, Roger Xu wrote:

Thanks - Now I had another problem:

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?



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.
Received on Thu Sep 21 2006 - 15:46:27 CDT

Original text of this message