6 Replies Latest reply: Nov 14, 2012 1:52 AM by Uwehesse-Oracle RSS

    Dataguard 11g setup between AIX and Linux

    971342
      Hi,

      We are planning to move our Oracle databases from AIX 6.1 to Oracle Linux 6.2

      To reduce the downtime, we are thinking of setting up a dataguard (physical or logical) and do the switchover.

      Have you performed this before?

      Will you pls send me the steps?

      Thanks,
      DR
        • 1. Re: Dataguard 11g setup between AIX and Linux
          mseberg
          Hello;

          If I understand the question correctly you should refer to this note :

          Data Guard Support for Heterogeneous Primary and Physical Standbys in Same Data Guard Configuration [ID 413484.1]

          Best Regards

          mseberg
          • 2. Re: Dataguard 11g setup between AIX and Linux
            971342
            Thanks, am checking the doc.
            • 3. Re: Dataguard 11g setup between AIX and Linux
              971342
              As per 413484.1 "This is not supported due to issues reported in Bug 12702521"

              Is it possible to set Logical standby between two diff OS / Endian format ?
              • 4. Re: Dataguard 11g setup between AIX and Linux
                mseberg
                Hello again;

                I thinking no for the same reason.

                When my shop moved from AIX to Linux we just install Oracle on Linux and patched it to the same level as the AIX. We created users, tablespaces, job etc in advance and then just used import/export to move the needed schema's. Data Pump make this much easier.

                Do a schema(s) compare and switch when ready. But in any event I don't believe Data Guard can help you. You mostly have a migrate issue.

                Please consider closing your question when complete.

                h3. Oracle Database 10g & Multi-Terabyte Database Migration

                http://www.oracle.com/technetwork/database/features/availability/thehartfordprofile-xtts-133180.pdf

                h3. Incrementally Updating Transportable Tablespaces using RMAN

                http://www.oracle.com/technetwork/database/features/availability/itts-130873.pdf

                h3. Platform Migration Using Transportable Database Oracle Database 11g and 10g Release 2

                http://www.oracle.com/technetwork/database/features/availability/maa-wp-10gr2-platformmigrationtdb-131164.pdf


                Best Regards

                mseberg

                Edited by: mseberg on Nov 13, 2012 6:31 PM
                • 5. Re: Dataguard 11g setup between AIX and Linux
                  971342
                  Hi mseberg,

                  We are doing same - moving DB from AIX to Linux.

                  We have databases ranging from 1TB to 20TB.

                  So, export/import wont work directly.
                  we will have to use transport tablespace with the file conversion using RMAN.

                  We are trying to reduce / eliminate the downtime for critical databases.

                  Thanks,
                  DR
                  • 6. Re: Dataguard 11g setup between AIX and Linux
                    Uwehesse-Oracle
                    Although the incremental TTS method looks great, it seems that it is presently only supported for Exadata as the target platform.

                    At least this MOS Note says so:
                    https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1389592.1

                    It contains an even more detailed description, by the way :)

                    Kind regards
                    Uwe Hesse

                    "Don't believe it, test it!"
                    http://uhesse.com