Switchover command hanged

[Raaj A]

Hi Tim,

My prod db is on 10g(10.2.0.1.0) win2k3 32 bit. I did switchover activity but the command mentioned below got hanged.

1) alter database commit to switchover to physical standby with session shutdown

above command got hanged and i opened another session and fire " shut immediate"

after opening the db in r/w mode i again fire the switchover command but it again got hanged. below are the some part of alert log file.

Please suggest why this command got hanged or where i am wrong?

Fri Oct 12 08:41:07 2012
alter database commit to switchover to physical standby with session shutdown ( command got hanged)

Fri Oct 12 09:16:25 2012 ( shut immediate)
Shutting down instance: further logons disabled
Fri Oct 12 09:20:00 2012
Starting ORACLE instance (normal) (startup)
Fri Oct 12 09:20:25 2012
Completed: ALTER DATABASE OPEN
Fri Oct 12 09:23:31 2012
alter database commit to switchover to physical standby with session shutdown (again fired switchover command)
ARC2: Standby redo logfile selected for thread 1 sequence 7724 for destination LOG_ARCHIVE_DEST_2
Fri Oct 12 09:24:57 2012
Background process MMON not dead after 30 seconds
Fri Oct 12 09:24:57 2012
Killing background process MMON
Fri Oct 12 09:25:24 2012
Starting background process MMON
Starting background process MMNL
MMON started with pid=22, OS id=6692
MMNL started with pid=24, OS id=10460
Fri Oct 12 09:25:24 2012
Fri Oct 12 09:26:54 2012
LGWR: Archiving did not complete within timeout

Fri Oct 12 09:30:01 2012
Errors in file g:\oracle\product\10.2.0\admin\dpampl\udump\dpampl_ora_11932.trc:
ORA-16040: standby destination archive log file is locked

Fri Oct 12 09:30:01 2012
ARCH: Error 16040 Creating archive log file to 'STBYDR'

Fri Oct 12 09:34:58 2012
ARCH: Archiving is disabled due to current logfile archival
Switchover target is not synchronized with the primary
ORA-16416 signalled during: alter database commit to switchover to physical standby with session shutdown...

Fri Oct 12 09:38:36 2012
alter database open

Fri Oct 12 09:39:13 2012 ( db got restarted automatically)
Shutting down instance (immediate)

Fri Oct 12 09:39:51 2012
ALTER DATABASE OPEN

Fri Oct 12 09:39:59 2012
ARCH: Possible network disconnect with primary database

Fri Oct 12 09:48:39 2012
WARNING: inbound connection timed out (ORA-3136)

Fri Oct 12 09:52:17 2012
Destination LOG_ARCHIVE_DEST_2 is SYNCHRONIZED


Fri Oct 12 10:00:03 2012
alter database commit to switchover to physical standby with session shutdown

Fri Oct 12 10:05:28 2012
Completed: alter database commit to switchover to physical standby with session shutdown


Please help.

[Tim...]

Hi.

From a cursory look, it seems your standby is not recovered to the same level as your primary. I suggest:

1) Start you primary up as normal.
2) Make sure your standby database is in managed recovery mode and has recovered up to the current latest SCN.
3) Start the switchover process again.

A switchover is a graceful change and as such, excepts things to be working properly before you start.

Cheers

Tim...

[Raaj A]

Hi Tim,

Thanks a lot for your suggestion and help.
Just one discussion with you.

On that day before firing switchover command on primary db, i did "alter system switch logfile" on primary db and checked on standby db it
was sync with primary db. I restarted primary db and checked standby db it was in sync. When again i did switchover command on primary db, command got hanged.

If you have any link where such scenario happened pls share with us, just to know more about this.


thanks

[Tim...]

Hi.

I've never seen this, but I wouldn't call myself a data guard expert. This type of switchover normally works for me.

http://www.oracle-base.com/articles/11g ... switchover

Cheers

Tim...

[Raaj A]

Thanks a lot........

[Tim...]