RE: Hetergenous Dataguard

  • From: "Justin Cave (DDBC)" <jcave@xxxxxxxxxxx>
  • To: Sanjay Mishra <smishra_97@xxxxxxxxx>, "Freek.DHooge@xxxxxxxxx" <Freek.DHooge@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Oct 2009 11:50:45 -0600

That does not sound realisitic.

A backup taken on a Solaris machine cannot be restored to a Linux server in 
10g.  Neither can a backup taken from an AIX machine be restored to a Linux 
server in 10g.  Starting in 11.1, cross-platform transportable database 
functionality might allow you to do this, but that would only be on the full 
backup and restore, not on the incremental.  You may be able to use 
transportable tablespaces in 10g to do the initial copy as well.

Streams or Oracle Golden Gate would seem like a far more realistic option if 
you need to create a reporting replica in a different geographic region.  This 
would not (without some potentially significant work) allow you to fail over to 
the replica, but I am hoping that is not your intention at this point.

Justin Cave
Distributed Database Consulting, Inc.

From: Sanjay Mishra [mailto:smishra_97@xxxxxxxxx]
Sent: Wednesday, October 21, 2009 10:27 AM
To: Freek.DHooge@xxxxxxxxx; Justin Cave (DDBC); oracle-l@xxxxxxxxxxxxx
Subject: Re: Hetergenous Dataguard

Thank s for the information on the Streams. Actually the reason for Datguard or 
other setup is to move the part of the Database to another Geographical 
location. There is not big bandwidth available available between two location 
and so cannot take the backup and copy it to other location and make the 
cutover as Database is around 500G. There is not much changes on the Primary 

Can I get an update if this process is feasible for the above scenarios
1. Take the Database level 0 backup on Solaris/Aix - There are two environment 
which need to be moved where one is AIX and other Solaris. Target is Linux
2. Take the Increamental and copy it to target location. On the final date, 
Step 1 Level 0 backup will be restored and incremental one will be applied

Issue is that if I can continue two backup on the Production like one Full 
going daily and another above incremental. Is it possible to be done both 
recorded in Controlfile or we need to change the backup process to one of them 

From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx>
To: "jcave@xxxxxxxxxxx" <jcave@xxxxxxxxxxx>; "smishra_97@xxxxxxxxx" 
<smishra_97@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Sent: Tue, October 20, 2009 6:22:32 PM
Subject: RE: Hetergenous Dataguard

Interesting note, although the options seems to be limited
I thought that the platform always had to be the same.

Learned something new again today  :)


Freek D'Hooge
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx<mailto:freek.dhooge@xxxxxxxxx>
tel +32(0)3 451 23 82

From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx> 
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Justin Cave (DDBC)
Sent: woensdag 21 oktober 2009 0:05
To: smishra_97@xxxxxxxxx<mailto:smishra_97@xxxxxxxxx>; 
Subject: RE: Hetergenous Dataguard

I believe Metalink Doc ID 413484.1 Data Guard Support for Heterogeneous Primary 
and Standby Systems in the Same Data Guard Configuration is the canonical 
reference for what configurations are allowed depending on the Oracle version.

Unfortunately, an AIX primary is only compatible with an AIX standby.  On the 
other hand, a Linux x86 box can have a Windows standby database.

Justin Cave
Distributed Database Consulting, Inc.


No virus found in this incoming message.
Checked by AVG -
Version: 8.5.422 / Virus Database: 270.14.21/2445 - Release Date: 10/19/09 

Other related posts: