Here's my delimma. I have the need to migrate several large Oracle 8.1.7.4 databases from SUN to AIX. And, perform this operation, per database, in a relatively short production outage window.
I know that through performing an export from 817 in Solaris then performing an import under AIX is successful, because we've done it. But the time it took was pretty extensive due to the sizes of the databases (600GB+). The time it is taking is much larger than the maximum allowed downtime we can take.
In addition, the Oracle tablespace files are on cooked filesystems residing on Veritas filesystems. This same requirement will remain under AIX - Veritas filesystem for the Oracle databases.
So - I was wondering if there was any way to simply copy the tablespace files from Solaris to the AIX box and bring up Oracle. Will that work or not?
What are other options? I've heard of shareplex and dataguard being 3rd party tools to set up hot standby Oracle databases. Would those allow the hot standby databases to be of a different platform?
---
Batavus
I know that through performing an export from 817 in Solaris then performing an import under AIX is successful, because we've done it. But the time it took was pretty extensive due to the sizes of the databases (600GB+). The time it is taking is much larger than the maximum allowed downtime we can take.
In addition, the Oracle tablespace files are on cooked filesystems residing on Veritas filesystems. This same requirement will remain under AIX - Veritas filesystem for the Oracle databases.
So - I was wondering if there was any way to simply copy the tablespace files from Solaris to the AIX box and bring up Oracle. Will that work or not?
What are other options? I've heard of shareplex and dataguard being 3rd party tools to set up hot standby Oracle databases. Would those allow the hot standby databases to be of a different platform?
---
Batavus
