This forum is currently locked. You can't register or post questions at this time. (read more)

Switchover command hanged

All posts relating to Oracle database administration.

Moderator: Tim...

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Switchover command hanged

Postby Raaj A » Tue Oct 16, 2012 10:00 am

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Switchover command hanged

Postby Tim... » Tue Oct 16, 2012 1:19 pm

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: Switchover command hanged

Postby Raaj A » Wed Oct 17, 2012 8:13 am

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...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Switchover command hanged

Postby Tim... » Wed Oct 17, 2012 9:51 am

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...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

Raaj A
Senior Member
Posts: 51
Joined: Wed Mar 07, 2012 7:08 am

Re: Switchover command hanged

Postby Raaj A » Wed Oct 17, 2012 11:00 am

Thanks a lot........

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Switchover command hanged

Postby Tim... » Wed Oct 17, 2012 11:10 am

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle Database Administration”

Who is online

Users browsing this forum: No registered users and 0 guests

cron