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.

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

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.

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.

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