If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

switchover problem in dataguard

Hi all,
I am working in oracle 9i on windows platform,
Im struct in dataguard switchover.
On primary server i write a sql
> select switchover_status from v$database;
session active
even though i make switchover
>alter database commit to switchover to standby;
it is completed sucessfully;
my this server is also standby server
Now on old standby server i write a sql
>select switchover_status from v$database;
session active
and not switchover pending ,even though i make switchover
>alter database commit to switchover to primary;
it still hang ,no error or no message has came from half hr.

please let me know my both database in standby mode,what should i do??

In version 9.2.0 this process has been automated with the session shutdown clause that has been added to the alter database commit to switchover command. If SWITCHOVER_STATUS returns SESSIONS ACTIVE then you should either disconnect all sessions manually or when performing step 2 you should append with session shutdown clause. For example:

Note that the clause also works with the switchover to primary command.

The SWITCHOVER_STATUS column of v$database can have the following values:

NOT ALLOWED - Either this is a standby database and the primary database has not been uswitched first, or this is a primary database and there are no standby databases.

SESSIONS ACTIVE - Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted.

SWITCHOVER PENDING - This is a standby database and the primary database
switchover request has been received but not processed.

SWITCHOVER LATENT - The switchover was in pending mode, but did not complete
and went back to the primary database.

TO PRIMARY - This is a standby database, with no active sessions, that is allowed to switch over to a primary database.

TO STANDBY - This is a primary database, with no active sessions, that is allowed to switch over to a standby database.

RECOVERY NEEDED - This is a standby database that has not received the switchover request.

During normal operations it is acceptable to see the following values for SWITCHOVER_STATUS on the primary to be SESSIONS ACTIVE or TO STANDBY. During normal operations on the standby it is acceptable to see the values of NOT ALLOWED or SESSIONS ACTIVE.

Note: Changes related to IP address need to be done at application level.

I've found this information really helpful!! I couldn't belive it worked the very first time I run it after having spent so many hours trying things which didn't work!
Now, I've come across a problem I can't resolve... I'm implementing 'failover' and it worked ... but I just don't know how to make the original Primary Db be a Standby... Would you help me?