Home » Server Options » Data Guard » Different platforms & data types
Different platforms & data types [message #256076] Thu, 02 August 2007 22:26 Go to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
Hi

I need to create a standby server for 10.1.0.5 database (SPARC, Solaris 9)

I have Intel x64 server for standby. So, as far as i know - i can't use physical standby (am i right?).

There are NCLOB & LONG data types in the database. So, i can't use logical standby?

Is there any solution?



Re: Different platforms & data types [message #256092 is a reply to message #256076] Fri, 03 August 2007 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can neither use physical not logical standby if you are not in the same platform.
From Data Guard Concepts and Administration, Chapter 2 "Getting Started with Data Guard", section "Data Guard Operational Prerequisites", subsection "Hardware and Operating System Requirements":
Quote:
All members of a Data Guard configuration must run an Oracle image that is built for the same platform.

Regards
Michel
Re: Different platforms & data types [message #256093 is a reply to message #256092] Fri, 03 August 2007 00:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, NCLOB and LONG datatypes are supported in 10.2.

Regards
Michel
Re: Different platforms & data types [message #256129 is a reply to message #256076] Fri, 03 August 2007 01:58 Go to previous messageGo to next message
Sergius
Messages: 13
Registered: November 2006
Junior Member
I can't buy new server right now(out of budget). But i need some kind of standby right now.

May be i can use replication as a temporary solution?

I have 10.1.0.5 database enterprise edition, and i can't upgrade it (application server if not certified for 10.2)

"Oracle Streams" in 10.1.0.5 do not support NCLOB.
May be i can use Advanced Replication?

Any suggestions?
Re: Different platforms & data types [message #256139 is a reply to message #256129] Fri, 03 August 2007 02:23 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can use materialized views.

Regards
Michel
Previous Topic: redo logs not getting applied
Next Topic: A question of Operating Systems
Goto Forum:
  


Current Time: Thu Mar 28 04:47:29 CDT 2024