Re: Oracle Archive Solution

We (Oracle) recommend that you consider using partitioning and compression to keep more data in your database for longer, rather than adding the complexity and expense of moving data out of your production database into some other form of storage. We loosely describe this approach as "in-database archiving".

Partitioning allows you to segment the data in your larger tables based on timestamp or equivalent criteria, and then move the older less valuable partitions to slower / cheaper / denser storage. Compression can be applied on a per-partition basis to reduce the amount of storage required for a given amount of user data, and also to improve performance of queries that scan that data (by reducing the amount of I/O needed). Oracle's database compression features can deliver 2x-4x compression ratios with OLTP Table Compression, and up to 10x, 15x, or more with Hybrid Columnar Compression on Oracle Storage (Exadata, ZFSSA, Pillar Axiom) - so the storage savings can be extremely large. All of this works transparently for end users and applications - no code changes are required to implement partitioning or compression. Let me know if you have questions about any of this...

Thanks,

Kevin Jernigan
Senior Director Product Management
Advanced Compression, Hybrid Columnar
Compression (HCC), Database File System
(DBFS), SecureFiles, Database Smart Flash Cache, Total Recall, Database Resource
Manager (DBRM), Direct NFS Client (dNFS), Continuous Query Notification (CQN),
Index Organized Tables (IOT), Information Lifecycle Management (ILM)
(650) 607-0392 (o)
(415) 710-8828 (m)

On 4/20/2012 9:30 AM, Li Li wrote:
> Hi List,
>
> I am wondering if anyone has implemented an archive solution and would
> be willing to share what product you used, either commercial, open
> source or home-grown? We are at a point that we have to archive data
> based on dates as our database has grown tremendously since the
> company started and data has never been archived.
>
> TIA,
> -Li
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l