Home » Server Options » Data Guard » DataGuard Swithover (Oracle10.2.0.1.0 and XP)
DataGuard Swithover [message #410452] Sat, 27 June 2009 02:32 Go to next message
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.


Re: DataGuard Swithover [message #410461 is a reply to message #410452] Sat, 27 June 2009 03:01 Go to previous messageGo to next message
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
Re: DataGuard Swithover [message #410466 is a reply to message #410461] Sat, 27 June 2009 03:19 Go to previous messageGo to next message
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
Re: DataGuard Swithover [message #410467 is a reply to message #410466] Sat, 27 June 2009 03:25 Go to previous messageGo to next message
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
Re: DataGuard Swithover [message #410472 is a reply to message #410452] Sat, 27 June 2009 03:46 Go to previous messageGo to next message
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)
Re: DataGuard Swithover [message #410473 is a reply to message #410452] Sat, 27 June 2009 03:47 Go to previous messageGo to next message
skmmmf
Messages: 10
Registered: November 2008
Junior Member
In this case primary and Standby is same only. ie 10.2.0 Release 1
Re: DataGuard Swithover [message #410474 is a reply to message #410473] Sat, 27 June 2009 03:54 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: DataGuard Swithover [message #410476 is a reply to message #410452] Sat, 27 June 2009 04:09 Go to previous messageGo to next message
skmmmf
Messages: 10
Registered: November 2008
Junior Member
My Primary Database Name:RTGS10 and find the attached spfile.

Re: DataGuard Swithover [message #411666 is a reply to message #410476] Mon, 06 July 2009 05:10 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Sorry for delay response.

Upgrade your database to 10.2.0.4

Thanks
Previous Topic: datafile creation in standby(not dataguard)
Next Topic: Manual setup of Logical Standby 10g
Goto Forum:
  


Current Time: Thu Mar 28 02:59:23 CDT 2024