6 Replies Latest reply: May 6, 2013 2:31 PM by tychos RSS

    Import data to Exadata

    user9043667
      Hi all,

      I am having an Oracle 11g R2 RAC setup. My database size is 22TB in normal servers. I have checked my database in Exadata X2-2 and found out that the HCC was good and as per my assumption the 22TB can come down to 10TB . My challenge is i need to transfer the 22TB data to the exadata quater rack which is having space constraint. Is there any way other than export & Impor,t as data export and import will use entire 22TB. Is there any way to transfer the data to Exadata with compressed form from the source server.

      Regards,
      Bobs
        • 1. Re: Import data to Exadata
          912595
          You can use XTTS( if platform is dufferent) or TTS to migrate tablespaces one-by-one. So when once tablespace are migrated they can be compressed after migration to make room for other tablespaces.

          Or other laborious task is to drop the REDO/DBFS diskgroups(which you might have) and assign the space to data diskgroup only, so you can have enough space to make RMAN or import/export work. Once migration gets over you can then compress the data and release the space back to redo/dbfs DG (ofcourse you need to recreate them).

          BTW it depends upon the data how much compression you can get after compressing.So its not always true so say you can compress data to 1/10(either high archival or high query). Hope that helps
          • 2. Re: Import data to Exadata
            user9043667
            Hi,

            Thanks for the reply.

            I am using RHEL 5.5 64bit on Source and in Exadata it is OEL 5.5 64bit. Now i am in production and i can t be able to drop the redo and DBFS diskgroups. Can we go for any dblinks creating the tablestructure and and importing the data to Exadata machine. Is there any recommended steps for TTS from source to Exadata.

            Regards,
            Bobs
            • 3. Re: Import data to Exadata
              Marc Fielding
              Hi Bobs,

              Assuming your data is already in an Oracle database, I'd definitely suggest looking at direct path inserts across db links. Tanel Poder has an excellent presentation on a large-scale migration of this type: http://www.slideshare.net/tanelp/tanel-poder-performance-stories-from-exadata-migrations

              Hope this helps!

              Marc
              • 4. Re: Import data to Exadata
                user9043667
                Hi Marc,

                Thanks for the link.

                Is there any detailed documentation on how we can insert the massive data through dblinks from source server to Exadata.

                Regards,
                Bobs
                • 5. Re: Import data to Exadata
                  Marc Fielding
                  Hi Bobs,

                  I think Tanel's presentation will is one of the better resources out there when designing this type of migration strategy. The book "Expert Oracle Exadata" also has a good section on data migration.

                  In general, though, if you're looking to move large volumes of data over database links I would suggest:
                  - Avoid staging data, and instead try and stream directly to the final destination
                  - Keeping all those Exadata disks and CPUs busy, which means a high degree of parallelism
                  - Remember that a single database link is inherantly serial. You will therefore want to parallelize over multiple links.
                  - Making use of direct path loads, and deferring index/constraint creation until after data loads are complete
                  - Physically sorted data will typically improve HCC compression ratios
                  - Make sure your network can keep up with your data load volumes. InfiniBand is your friend!
                  - Giving some thought to how to organize your data: migration is an excellent time to make data model and partitioning changes that can be very difficult afterwards
                  - Testing your data load procedures with smaller data volumes before moving on to larger volumes

                  Cheers!

                  Marc
                  • 6. Re: Import data to Exadata
                    tychos
                    Hi Bobs,
                    If you can't afford the downtime you maybe can look into tools like Golden Gate or Shareplex.
                    This will give you time to build your database on Exadata and implementing HCC compression for static data or OLTP compression for dynamic data.
                    The original database stays up running and changes get replicated to the Exadata dbs during the building phase.
                    When the build is completed you stop (or reverse) replication and repoint the application to the Exadata database.
                    I must admit it will involve additional license costs.
                    Regards,
                    Tycho