Home » Server Options » Data Guard » oracle 9i logical standby
oracle 9i logical standby [message #545221] Tue, 28 February 2012 00:15 Go to next message
saikat89
Messages: 4
Registered: February 2012
Junior Member
There are two servers.
one in HP-UNIX and another is solaris.

I would like to configure a logical standby using oracle 9i...Is it possible in 9i?
Re: oracle 9i logical standby [message #545250 is a reply to message #545221] Tue, 28 February 2012 02:27 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum. Please read our OraFAQ Forum Guide and How to use [code] tags and make your code easier to read

And yes, Logical Standby was introduced in release 9.2. There were some restrictions.

[update: I just re-read your post, and NO, you can't use Logical standby between HPUX and Solaris.]

[Updated on: Tue, 28 February 2012 02:28]

Report message to a moderator

Re: oracle 9i logical standby [message #545256 is a reply to message #545250] Tue, 28 February 2012 03:06 Go to previous messageGo to next message
saikat89
Messages: 4
Registered: February 2012
Junior Member
Thank you for your reply...

So, it is not possible to configure heterogeneous logical standby in oracle 9i..right???


But in 10g onwards it is possible... no?


Please reply asap....thanks again
Re: oracle 9i logical standby [message #545259 is a reply to message #545256] Tue, 28 February 2012 03:20 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
Metalink notes 413484.1 and 1085687.1 will tell you what you need to know.
Re: oracle 9i logical standby [message #545277 is a reply to message #545259] Tue, 28 February 2012 04:03 Go to previous messageGo to next message
saikat89
Messages: 4
Registered: February 2012
Junior Member
Thanks a lot!!

platform_id and platform_name are absent in v$database in oracle 9i..hence not possible..and they have mentioned for 10g onwards....Thank you very much.


Do you think golden gate is a possible solution in this case?
Re: oracle 9i logical standby [message #545283 is a reply to message #545277] Tue, 28 February 2012 04:28 Go to previous messageGo to next message
Michel Cadot
Messages: 58954
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes but I think Oracle no more supports such configuration (too old).

But you may go for Sybase replication server, I think Sybase still supports it.

Regards
Michel

[Updated on: Tue, 28 February 2012 04:29]

Report message to a moderator

Re: oracle 9i logical standby [message #545303 is a reply to message #545277] Tue, 28 February 2012 05:09 Go to previous messageGo to next message
John Watson
Messages: 4522
Registered: January 2010
Location: Global Village
Senior Member
I would look at using Streams or Advanced Replication. The Oracle sales droids will tell you that these are ancient history and don't work, but that is because they are free.

And as Michel sugegsts, you really should upgrade. No-ine is going to help you with 9i.
Re: oracle 9i logical standby [message #545376 is a reply to message #545303] Tue, 28 February 2012 23:43 Go to previous message
saikat89
Messages: 4
Registered: February 2012
Junior Member
Thanks to michel and John...and yes database upgradation is now our first priority:)
Previous Topic: parameters fal_server issue
Next Topic: ORA-00314
Goto Forum:
  


Current Time: Mon Sep 01 14:40:30 CDT 2014

Total time taken to generate the page: 0.13688 seconds