OraFAQ Forum: Data Guard » Different platforms & data types

Home » Server Options » Data Guard » Different platforms & data types

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

Different platforms & data types [message #256076]

Thu, 02 August 2007 22:26

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?

Report message to a moderator

Re: Different platforms & data types [message #256092 is a reply to message #256076]

Fri, 03 August 2007 00:47

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Different platforms & data types [message #256093 is a reply to message #256092]

Fri, 03 August 2007 00:49

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

In addition, NCLOB and LONG datatypes are supported in 10.2.

Regards
Michel

Report message to a moderator

Re: Different platforms & data types [message #256129 is a reply to message #256076]

Fri, 03 August 2007 01:58

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?

Report message to a moderator

Re: Different platforms & data types [message #256139 is a reply to message #256129]

Fri, 03 August 2007 02:23

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes, you can use materialized views.

Regards
Michel

Report message to a moderator

Previous Topic:	redo logs not getting applied
Next Topic:	A question of Operating Systems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 16:49:39 CST 2025