Re: Hetergenous Dataguard

Don

Yes I had checked your Blog and in my case it is Sparc but Thanks for the excillent info on the blog.

Sanjay


________________________________
From: Justin Cave (DDBC) <jcave_at_ddbcinc.com>
To: Don Seiler <don_at_seiler.us>; Sanjay Mishra <smishra_97_at_yahoo.com>; "Freek.DHooge@uptime.be" <Freek.DHooge@uptime.be>; "oracle-l@freelists.org" <oracle-l@freelists.org>
Sent: Wed, October 21, 2009 8:53:17 PM
Subject: RE: Hetergenous Dataguard

Excellent point.  I assumed since one of the source databases was AIX that the Solaris machine would be SPARC, but I should have noted that assumption.  

As far as I'm aware, the AIX to linux restore is not possible in 10g though.  


Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com




-----Original Message-----
From: Don Seiler [mailto:don_at_seiler.us] 
Sent: Wednesday, October 21, 2009 6:14 PM
To: Justin Cave (DDBC); Sanjay Mishra; Freek.DHooge_at_uptime.be; oracle-l@freelists.org
Subject: Re: Hetergenous Dataguard

I have in fact done two such restores. Both times doing a restore on
linux from solaris.  Both are x86-64.  I have a blog post about it as
well on http://www.pythian.com.  Oracle does support this as long as
both architectures are the same and a convert is done on any
tablespaces containing UNDO segments.

If you meant Solaris SPARC, then yes, it woudn't work.

Don.

On 10/21/09, Justin Cave (DDBC) <jcave_at_ddbcinc.com> wrote:
> 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.
> http://www.ddbcinc.com
>
>
>
> From: Sanjay Mishra [mailto:smishra_97_at_yahoo.com]
> Sent: Wednesday, October 21, 2009 10:27 AM
> To: Freek.DHooge_at_uptime.be; Justin Cave (DDBC); oracle-l@freelists.org
> 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 Site.
>
> 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 only.
>
> TIA
> Sanjay
> ________________________________
> From: D'Hooge Freek <Freek.DHooge_at_uptime.be>
> To: "jcave_at_ddbcinc.com" <jcave@ddbcinc.com>; "smishra_97@yahoo.com"
> <smishra_97_at_yahoo.com>; "oracle-l@freelists.org" <oracle-l@freelists.org>
> 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  :)
>
>
>
> Regards,
>
>
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge_at_uptime.be<mailto:freek.dhooge@uptime.be>
> tel +32(0)3 451 23 82
> http://www.uptime.be
>
> ________________________________________
> From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce@freelists.org>
> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce@freelists.org>]
> On Behalf Of Justin Cave (DDBC)
> Sent: woensdag 21 oktober 2009 0:05
> To: smishra_97_at_yahoo.com<mailto:smishra_97@yahoo.com>;
> oracle-l_at_freelists.org<mailto:oracle-l@freelists.org>
> 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.
> http://www.ddbcinc.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 8.5.422 / Virus Database: 270.14.21/2445 - Release Date: 10/19/09
> 06:40:00
>


-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.422 / Virus Database: 270.14.21/2445 - Release Date: 10/19/09 06:40:00
--
http://www.freelists.org/webpage/oracle-l


      

--
http://www.freelists.org/webpage/oracle-l