4 Replies Latest reply: Sep 20, 2013 3:05 PM by Martin Preiss RSS

    A question on different options for data archival and compression

    orausern

      Hi Experts,

       

      I have production database of about 5 terabyte size in production and about 50 GB in development/QA. I am on Oracle 11.2.0.3 on Linux. We have RMAN backups configured. I have a question about data archival stretegy.  To keep the OLTP database size optimum, what options can be suggested for data archival?

       

      1) Should each table have a archival stretegy?

      2) What is the best way to archive data - should it be sent to a seperate archival database?

       

      In our environment, only for about 15 tables we have the archival stretegy defined. For these tables, we copy their data every night to a seperate schema meant to store this archived data and then transfer it eventualy to a diffent archival database. For all other tables, there is no data archival stretegy.

       

      What are the different options and best practices about it that can be reviewed to put a practical data archival strategy in place? I will be most thankful for your inputs.

       

      Also what are the different data compression stregegies? For example we have about 25 tables that are read-only. Should they be compressed using the default oracle 9i basic compression? (alter table compress).

       

      Thanks,

      OrauserN