OraFAQ Forum: Data Guard » DataGuard Swithover

Home » Server Options » Data Guard » DataGuard Swithover (Oracle10.2.0.1.0 and XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

DataGuard Swithover [message #410452]

Sat, 27 June 2009 02:32

skmmmf
Messages: 10
Registered: November 2008

Junior Member

Hi All,

I am using 10.2.0.1.0 in Windows XP os. I have successfully configured Primary and Standby Database. Archive Log files are also applied to Standby DB. But When i try to Switchover from primary to Standby i.e. after issuing the following command

alter database commit to switchover to standby

in the Primary DB this is running , running for long time ( hours together ).

No entry is made in my Log file too. But in trace file the entries are like
Redo shipping client performing standby login
*** 2009-06-27 11:34:18.315 64562 kcrr.c
Logged on to standby successfully
Client logon and security negotiation successful!
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:35:19.952
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:35:39.748
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:36:20.582
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:37:21.212
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:38:21.858
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:39:22.379
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:40:22.767
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:41:23.124
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:42:23.480
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:43:23.836
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:44:24.199
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:45:24.473
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:46:24.685
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:47:24.912
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:48:25.170
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:49:25.382
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:50:25.577
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:51:25.766
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:52:25.963
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:53:26.160
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:54:26.326
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:55:26.539
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:56:26.718
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:57:26.910
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:58:27.086
kcrrwkx: nothing to do (end)
*** 2009-06-27 11:59:27.263
kcrrwkx: nothing to do (end)
*** 2009-06-27 12:00:27.455
kcrrwkx: nothing to do (end)

Can anyone tell me whether 10.2.0.1.0 support for Switchover and Failover? Or anything from myside is wrong? No active users connected with DB.

Need solution asap. Thanks in Advance.

Report message to a moderator

Re: DataGuard Swithover [message #410461 is a reply to message #410452]

Sat, 27 June 2009 03:01

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>Logged on to standby successfully
>>Client logon and security negotiation successful!

Looks like successfully switchover your primary to standby. Is there any error message in alert log?

Why your not upgraded your database to latest version?

Thanks

Report message to a moderator

Re: DataGuard Swithover [message #410466 is a reply to message #410461]

Sat, 27 June 2009 03:19

skmmmf
Messages: 10
Registered: November 2008

Junior Member

Babu,
Thanks for your immediate reply.

In My Case Switchover is not successful. My client Version (Production ) is 10.2.0.2.0. But in my office version is 10.2.0.1.0. If version is the problem i can restart the process in 10.2.0.2.0.

I really want to know why that ( alter database commit to switchover to standby ) command is not getting completed. Is my Fault? or Something else.

Regards
Mohideen

Report message to a moderator

Re: DataGuard Swithover [message #410467 is a reply to message #410466]

Sat, 27 June 2009 03:25

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

I think some confusion; If you don't mind once again can you confirm your primary & standby database version ?? (With 4 digit )

Thanks

Report message to a moderator

Re: DataGuard Swithover [message #410472 is a reply to message #410452]

Sat, 27 June 2009 03:46

skmmmf
Messages: 10
Registered: November 2008

Junior Member

Both Version is 10.2.0 Only.
but
production Version Release 2. it. ( 10.2.0.2)
Office Version Release 1. ie (10.2.0.1)

Report message to a moderator

Re: DataGuard Swithover [message #410473 is a reply to message #410452]

Sat, 27 June 2009 03:47

skmmmf
Messages: 10
Registered: November 2008

Junior Member

In this case primary and Standby is same only. ie 10.2.0 Release 1

Report message to a moderator

Re: DataGuard Swithover [message #410474 is a reply to message #410473]

Sat, 27 June 2009 03:54

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Could please provide valid proof; Like execute the below statement in primary & standby database.

select * from v$version

also
Post your primary & standby pfile

[Updated on: Sat, 27 June 2009 03:54]

Report message to a moderator

Re: DataGuard Swithover [message #410475 is a reply to message #410452]

Sat, 27 June 2009 04:07

skmmmf
Messages: 10
Registered: November 2008

Junior Member

Also find the attached SPfile of Standby.

From my Primary DB
---------------------

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

From my Standby DB
---------------------

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production