8 Replies Latest reply: Dec 14, 2011 12:07 PM by 726307 RSS

    Disaster recovery

    726307
      There is technique concept "compress data" in the Exadata ----i'm new in Exadata maybe it call "HCC"

      anyway,what is the impact in the DR-site when it build with non-Exadata machine?

      Thanks in advance
        • 1. Re: Disaster recovery
          damorgan
          You can not have hybrid columnar compression on a non-Exadata frame
          • 2. Re: Disaster recovery
            gsalem-Oracle
            Sami,
            if you use a non-exadata machine for DR, all your tables that are in HCC format on Exadata must be uncompressed before being accessible. You do that via Alter table/partition move uncompress or 'compress basic'.
            Beware of the space implications, as well as the time it might take to do this.

            Ghassan
            • 3. Re: Disaster recovery
              andy.colvin
              This is correct. You can create a physical standby of an Exadata database using HCC to a non-Exadata platform. After switching over to the standby, you will have to uncompress any objects using HCC before selecting from them (unless you use ZFS storage appliance as your storage). This will not only require extra storage, but you will need to be sure that you have plenty of CPUs on the DR system. As you can expect, decompression is a very cpu-intensive task.

              We do not recommend using a non-Exadata system for disaster recovery, for the following reasons:

              <li>Performance differences between primary and standby systems
              <li>Increased requirements (CPU and storage) for standby systems
              <li>Higher window to switch to standby system (additional time needed to decompress HCC objects)
              <li>Lack of additional environment to test patching (standby first patch apply)
              • 4. Re: Disaster recovery
                726307
                Thanks for all,
                can i run my database without using of HCC feature?
                or, what is the solution in the case of using a non-Exadata system for disaster recovery?


                thanks in advance
                • 5. Re: Disaster recovery
                  726307
                  w

                  Edited by: sami on Dec 8, 2011 1:52 AM
                  • 6. Re: Disaster recovery
                    Dan.Norris-Oracle
                    This MAA whitepaper should answer all your questions and offer suggestions on the best practices in such situations:
                    http://www.oracle.com/technetwork/database/features/availability/maa-wp-dr-dbm-130065.pdf
                    • 7. Re: Disaster recovery
                      Uwehesse-Oracle
                      One thing that the very good whitepaper that you linked to does not mention (because it wasn't the case in March 2011 yet) is that now ZFS and Pillar storage supports HCC compression. So the Non-Exadata Standby Machine can process the HCC compressed tables if it uses that kind of storage, probably.

                      Kind regards
                      Uwe Hesse

                      http://uhesse.wordpress.com
                      • 8. Re: Disaster recovery
                        726307
                        Very helpful information
                        Thanx alot

                        Edited by: sami on Dec 14, 2011 9:07 PM