8 Replies Latest reply on Dec 14, 2011 6:07 PM by 726307

    Disaster recovery

      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
          You can not have hybrid columnar compression on a non-Exadata frame
          1 person found this helpful
          • 2. Re: Disaster recovery
            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.

            1 person found this helpful
            • 3. Re: Disaster recovery
              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)
              1 person found this helpful
              • 4. Re: Disaster recovery
                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

                  Edited by: sami on Dec 8, 2011 1:52 AM
                  • 6. Re: Disaster recovery
                    This MAA whitepaper should answer all your questions and offer suggestions on the best practices in such situations:
                    • 7. Re: Disaster recovery
                      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

                      1 person found this helpful
                      • 8. Re: Disaster recovery
                        Very helpful information
                        Thanx alot

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