Avatar of Pepe2323
Pepe2323
 asked on

Dataguard Across plataforms

Hi All

i'm planning to  move my Oracle 10g database from Solaris to AIX, i'm planning to do the following:

- Perform a Full backup
- Restore the backup on the AIX server.

my database will be different from my initial Full backup so i'l planning to sync that difference using dataguard; my real questions here it is.

Can i perform  dataguard on version oracle 10g where my source is a solaris and my destination is AIX?

If i need an other solution for that what can be ?

Regards.
Oracle Database

Avatar of undefined
Last Comment
Praveen Kumar Chandrashekatr

8/22/2022 - Mon
johnsone

I believe that you cannot cross platforms this way.  RMAN does contain a utility that will allow you to convert the data files between the 2 platforms, but there is no facility for the archive logs that would be required to keep the second copy up to date.

Here is the documentation on convert between platforms -> https://docs.oracle.com/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDCFCIB

The entire chapter is relevant, but here is a direct link to converting an entire database -> https://docs.oracle.com/cd/B19306_01/backup.102/b14191/dbxptrn.htm#CHDEFAEE
Praveen Kumar Chandrashekatr

You can use Heterogeneous Data Guard Configurations for cross platform or Export/Import Transportable databse or Oracle Golden Gate .

Here is the document which talks about these process.

https://docs.oracle.com/database/121/HAOVW/planned.htm#HAOVW12000

here is a doc on Hertogeneous Data Guard has an example
http://www.pythian.com/blog/howto-oracle-cross-platform-migration-with-minimal-downtime/
ASKER CERTIFIED SOLUTION
Franck Pachot

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
johnsone

You can transport tablespaces across endian using the rman convert command.  That is documented in the links that I posted.  However, you cannot roll them forward.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Pepe2323

ASKER
My Solaris is Sparc
Pepe2323

ASKER
In that case my best options can be, perform a full export then import at last; configure goldengate that help me with the replication online

isn't it ?
johnsone

I'm not that familiar with Goldengate, but I would think that you could use transportable tablespaces, or restoring and converting a backup, to get the initial data load done.  exp/imp seems to be a lot of work to move a database between machines.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Pepe2323

ASKER
I had to take Golden Gate solution.

Thanks for all the advices.
Praveen Kumar Chandrashekatr

there should be split in points has i have also pointed different approaches in my post. ID: 40431207