hailstorm82

AllmembersofaDataGuardconfigurationmustrunanOracleimagethatisbuiltforthesameplatform.
Forexample, thismeansaDataGuardconfigurationwithaprimarydatabaseona32-bitLinuxonIntelsystem
canhaveastandbydatabasethatisconfiguredona32-bitLinuxonIntelsystem.However, aprimarydatabase
ona64-bitHP-UXsystemcanalsobeconfiguredwithastandbydatabaseona32-bitHP-UXsystem,
aslongasbothserversarerunning32-bitimages.
The above mainly puts forward two needs: namely, the platform (platform) as well as the word length (wordsize) should be the exact same. Note that whether it truly is physicalstandby or logicalstandby here, it really is essential to comply.

The explanation why the official document is written like this can be that Oracle will not propose users to create DataGuard on heterogeneous platforms. If a large quantity of users deploy DataGuard on heterogeneous platforms, it might bring about trouble for subsequent services and assistance; so unless you ca n’t find other Available hardware, otherwise it can be not recommended to make use of a DataGuard atmosphere built on a heterogeneous platform to provide higher availability.

https://berryend84.soup.io/post/693983312/Draw-house is the fact that there are actually already some heterogeneous platform combinations in 10g that happen to be compatible with physicalstandby or logicalstandby, and in 11g, a number of heterogeneous platform combinations that help physicalstandby are added (AsofOracleDatabase11gDataGuardprovidesincreasedflexibilityforDataGuardconfigurationsinwhichtheprimaryandstandbysystemsmayhavedifferentCPUarchitectures, operating, Windows, operating, operating, Windows, operating, Linux 32-bit / 64-bit), orOracledatabasebinaries (32-bit / 64-bit). Forspecific info about mixed-platform support, seetheMyOracleSupportnote413484.1).

The distinct heterogeneous platform combinations out there for 10g / 11gDataGuard are shown in the following chart:

10g
PhysicalStandby
LogicalStandby
Heterogeneous

Assistance
No
WinLinuxOnly
Different

Word-size

(32 / 64bit)
Win32Win64

Linux32Linux64
Win32-Win64

Linux32-Linux64 (1wayonly)

HeterogeneousANDWord-size
No
No



11g
PhysicalStandby
LogicalStandby
Heterogeneous

Support
WinLinux

SolarisAIX

SolarisLinux
WinLinuxOnly
Various

Word-size

(32 / 64bit)
Win32Win64

Linux32Linux64
Win32-Win64Linux32-Linux64 (1wayonly)
HeterogeneousANDWord-size
Win32Linux64
Win32-Linux64

(1wayonly)


Within the metalink document DataGuardSupportforHeterogeneousPrimaryandPhysicalStandbysinSameDataGuardConfiguration [ID413484.1] and DataGuardSupportforHeterogeneousPrimaryandLogicalStandbysinSameDataGuardConfiguration [ID1085687.1], extra detailed compatibility facts between platforms is listed here.

PhysicalStandbys

InadditiontogeneralsupportwhenusingthesameOracleplatform, DataGuardRedoApply (physicalstandby) cansupportspecificmixedOraclePlatformcombinations.OraclePlatformIDs, platformnames, andwhichcombinationsofplatformID (s) thatcanbecombinedtoformasupportedDataGuardconfigurationusingRedoApplyarelistedinthetablebelow.PlatformAppliesListedApps

TableNotes
PriortoDataGuard11g, theDataGuardBrokerdidnotsupportdifferentword-sizeinthesameDataGuardconfiguration, thusrequiringmanagementfromtheSQL * Pluscommandlineformixedword-sizeDataGuardconfigurations.ThisrestrictionisliftedfromDataGuard11gonward.
Bothprimaryandstandbydatabasesmustbesetatthesamecompatibilitymodeastheminimumrelease (ifspecified) inthetablebelow.
Astandbydatabasecannotbeopenread-onlyinanyenvironmentthathasbinary-levelPL / SQL-relatedincompatibilitiesbetweenprimaryandstandbydatabases.SupportNote414043.1isreferencedinthetablebelowforanyplatformcombinationswherethisisthecase (thenoteprovidesinstructionsforeliminatingincompatibilitiespostroletransition) .ItispossibletoaccessastandbydatabaseinsuchenvironmentsinOracleDatabase11gbytemporarilyconvertingittoaSnapshotStandbydatabase, orinOracleDatabase10gbyopeningthestandbyread / writeasdescribedintheDataGuard10gConceptsandAdministrationguide: UsingaPhysicalStandbyDatabaseforRead / WriteTestingandReporting.Bothproceduresrequirefollowingthestepsinnote414043.1beforemakingthedatabaseavailabletousers.
PleasebesuretoreadSupportNoteswhenreferencedinthetablebelow.
RMANgenerallysupportsinstantiationofaphysicalstandbydatabaseforthesupportedplatformcombinations.PleaseseeSupportNote1079563.1fordetails.
Platformsinasupportedcombinationmayoperateineithertheprimaryorstandbyrole.
EnterpriseManagercannotbeusedforstandbydatabasecreationorotheradministrativefunctionsinanyconfigurationwherePLATFORM_IDsarenotidentical.OraclerecommendsusingtheDataGuardBrokercommandlineinterface (DGMGRL) toadministermixedplatformcombinationsfromOracleDatabase11gonwardandSQL * Pluscommandlineforconfigurationsthatpre-dateOracleDatabase11g.
PLATFORM_ID
PLATFORM_NAME

Releasename
PLATFORM_IDssupportedwithinthesameDataGuardconfigurationwhenusingDataGuardRedoApply (PhysicalStandby)
2
Solaris [tm] OE (64-bit)

Solaris Operating Program (SPARC) (64-bit)
2

6–Oracle11.two.0.2onward, primarydatabasemustbenon-RACandnon-TDE
three
HP-UX (64-bit)

HP-UXPA-RISC
three

4–Oracle10gonward, seeSupportNotes395982.1and414043.1
4
HP-UXIA (64-bit)

HP-UXItanium
four

3–Oracle10gonward, seeSupportNotes395982.1and414043.1
five
HPTru64UNIX

HPTru64UNIX
5
6
IBMAIXonPOWERSystems (64-bit)
2–Oracle11.2.0.2onward, primarydatabasemustbenon-RACandnon-TDE

6
7
MicrosoftWindows (32-bit)

MicrosoftWindows (x86)
7

eight,12–Oracle10gonward, seeSupportNote414043.1

10–Oracle11gonward

11,13–Oracle11gonward, seeSupportNote414043.1
8
MicrosoftWindowsIA (64-bit)

MicrosoftWindows (64-bitItanium)
7–Oracle10gonward, seeSupportNote414043.1

8

12–Oracle10gonward

11,13–Oracle11gonward
9
IBMzSeriesBasedLinux

z / Linux
9

18 (64-bitzSeriesonly)
ten
Linux (32-bit)

Linuxx86
7–Oracle11gonward

ten

11,13–Oracle10gonward, seeSupportNote414043.1
11
LinuxIA (64-bit)

LinuxItanium
10–Oracle10gonward, seeSupportNote414043.1

11

13–Oracle10gonward

7–Oracle11gonward, seeSupportNote414043.1

8,12–Oracle11gonward
12
MicrosoftWindows64-bitforAMD

MicrosoftWindows (x86-64)
7–Oracle10gonward, seeSupportNote414043.1

8–Oracle10gonward

12

11,13–Oracle11gonward
13
Linux64-bitforAMD

Linuxx86-64
7–Oracle11gonward, seeSupportNote414043.1

10–Oracle10gonward, seeSupportNote414043.1

11–Oracle10gonward

8,12–Oracle11gonward

13

20–Oracle11gonward
15
HPOpenVMS

HPOpenVMSAlpha

HPIAOpenVMS

OpenVMSItanium
15
16
AppleMacOS

MacOSXServer
16
17
SolarisOperatingSystem (x86)

SolarisOperatingSystem (x86)
17

20–Oracle10gonward, seeSupportNote414043.1
18
IBMPowerBasedLinux

LinuxonPower
9 (64-bitzSeriesonly)

18
20
SolarisOperatingSystem (AMD64)

SolarisOperatingSystem (x86-64)
13–Oracle11gonward

17–Oracle10gonward, seeSupportNote414043.1

20
LogicalStandby
InadditiontogeneralsupportwhenusingthesameOracleplatform, DataGuardSQLApply (logicalstandby) cansupportspecificmixedOraclePlatformcombinationsasofOracleDatabase11g.OraclePlatformIDs, platformnames, andwhichcombinationsofplatformID (s) thatcanbecombinedtoformasupportedDataGuardconfigurationusingSQLApplyarelistedinthetablecomb

TableNotes
AllmixedplatformcombinationsforSQLApplyinthetablebelowaresupportedfromOracleDatabase11gonward.
PriortoDataGuardBroker11g, theDataGuardBrokerdidnotsupportdifferentword-sizeinthesameDataGuardconfiguration, thusrequiringallmanagementfromtheSQL * Pluscommandline.ThisrestrictionisliftedfromDataGuard11gonward.
Bothprimaryandstandbydatabasesmustbesetatthesamecompatibilitymodeastheminimumrelease (ifspecified) inthetablebelow.
PleasebesuretoreadSupportNoteswhenreferencedinthetablebelow.
RMANgenerallysupportsinstantiationofaphysicalstandbydatabaseforthesupportedplatformcombinations.PleaseseeSupportNote1079563.1fordetails.
go more .
EnterpriseManagercannotbeusedforstandbydatabasecreationorotheradministrativefunctionsinanyconfigurationwherePLATFORM_IDsarenotidentical.OraclerecommendsusingtheDataGuardBrokercommandlineinterface (DGMGRL) toadministermixedplatformcombinationsfromOracleDatabase11gonwardandSQL * Pluscommandlineforconfigurationsthatpre-dateOracleDatabase11g.
PLATFORM_ID
PLATFORM_NAME

Releasename
PLATFORM_IDssupportedwithinthesameDataGuardconfigurationwhenusingDataGuardSQLApply (LogicalStandby)
2
Solaris [tm] OE (64-bit)

Solaris Operating Technique (SPARC) (64-bit)
2
three
HP-UX (64-bit)

HP-UXPA-RISC
three,4
four
HP-UXIA (64-bit)

HP-UXItanium
three,four
five
HPTru64UNIX

HPTru64UNIX
five
6
AIX-BasedSystems (64-bit)

AIX5L
six
7
MicrosoftWindows (32-bit)

MicrosoftWindows (x86)
7,10

eight,12–Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransition haspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.
8
MicrosoftWindowsIA (64-bit)

MicrosoftWindows (64-bitItanium)
7–Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransitionhaspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.

eight,11,12,13
9
IBMzSeriesBasedLinux

z / Linux
9
ten
Linux (32-bit)

Linuxx86
7,ten

11,13–Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransitionhaspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.
11
LinuxIA (64-bit)

LinuxItanium
10–Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransitionhaspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.

8,11,13
12
MicrosoftWindows64-bitforAMD

MicrosoftWindows (x86-64)
7–fromOracle11gonward.Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransition haspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.

eight,12
13
Linux64-bitforAMD

Linuxx86-64
10–Replicationcanonlyoccurfroma32-bitprimarytoa64-bitstandby, oncearoletransitionhaspromotedthe64-bitsystemtotheprimaryrole, theoriginal32-bitprimaryisnotsupportedasastandbydatabase.

8,11,13
15
HPOpenVMS

HPOpenVMSAlpha

HPIAOpenVMS

OpenVMSItanium
15
16
AppleMacOS

MacOSXServer
16
17
SolarisOperatingSystem (x86)

SolarisOperatingSystem (x86)
17
18
IBMPowerBasedLinux

LinuxonPower
18
20
SolarisOperatingSystem (AMD64)

SolarisOperatingSystem (x86-64)
20
Reference:

CrossPlatformDatabaseMigrations-OwenIreland

DataGuardSupportforHeterogeneousPrimaryandPhysicalStandbysinSameDataGuardConfiguration [ID413484.1]

DataGuardSupportforHeterogeneousPrimaryandLogicalStandbysinSameDataGuardConfiguration [ID1085687.1]

Associated articles | Relatedposts:

FailtoqueuethewholeFALgapindataguard An example of current alarm logs shows the following records: FAL [server]: FailtoqueuethewholeFAL […] ...