RE: 9i physical standby startup

  • From: Carel-Jan Engel <cjpengel.dbalert@xxxxxxxxx>
  • To: Roger.Xu@xxxxxxxxxxx
  • Date: Thu, 21 Sep 2006 22:29:54 +0200

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:
>  
> * 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


Other related posts: