|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: PROS and CONS of cross platform dataguard(Linux and windows) [message #687725 is a reply to message #687724] |
Wed, 17 May 2023 00:46   |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
All right, I'll try again.Quote:I have to give them a short descriptive presentation on pros and cons of doing this I would tell the client that the sole purpose of the cross platform Data Guard capability is to assist with platform migration. It is not intended for any sort of high availability. If they intend to switch over to the Windows system and then drop the Linux system, great! Zero downtime for the move! If they intend to use the Windows system in the event of failure of the Linux system, well, forget it. Think of such basic things as external procedures or directories: They won't work.
|
|
|
|
| Re: PROS and CONS of cross platform dataguard(Linux and windows) [message #687726 is a reply to message #687724] |
Wed, 17 May 2023 00:58 |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Data Guard Concepts and Administration,
Chapter 2.3 Oracle Data Guard Operational Prerequisites,
Section 2.3.1 Hardware and Operating System Requirements:
Quote:The same release of Oracle Database Enterprise Edition must be installed on the primary database and all standby databases, except during rolling database upgrades using logical or transient logical standby databases.
As of Oracle Database 11g, Oracle Data Guard provides increased flexibility for Oracle Data Guard configurations in which the primary and standby systems may have different CPU architectures, operating systems (for example, Windows and Linux), operating system binaries (32-bit/64-bit), or Oracle database binaries (32-bit/64-bit).
This increased mixed-platform flexibility is subject to the current restrictions documented in the My Oracle Support notes 413484.1 and 1085687.1 at http://support.oracle.com.
Note 413484.1 discusses mixed-platform support and restrictions for physical standbys.
Note 1085687.1 discusses mixed-platform support and restrictions for logical standbys.
This for Oracle side, for application one, the purpose of a DR database is to replace the usual production one in case of failure.
So are you sure your application will 100% work on Windows? Have all tests been executed? Features, performances, support of load, security, backup...?
With all evolution of your application, tests have to be done on Linux and Windows. Have you the people to do so?
And to quote John:
Quote:You must have had reasons for choosing Linux for the primary, those reasons are 100% valid for the standby too.
So the first question is not "what are the cons?" but "will this work?", not only for Oracle side (it is supported) but for the enterprise one.
[Updated on: Wed, 17 May 2023 01:01] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
