Re: Real life implementation of 7 year data retention requirement
Date: Thu, 13 Feb 2014 21:09:49 +0000
Message-ID: <CAOuMUT5BBDBYmMB1gdEAkxoo2Hi_5xbuuW+6xtX3a48URt4kOw_at_mail.gmail.com>
Hi,
From the original post
"We are asked to implement a database backup policy so that the state of database can be resurrected to any given point in time up to past 7 years"
I think the words "database backup policy" should be replaced with "data retention policy". I don't believe backups are the way to meet this requirement. I think a data warehouse is the way to go.
And for the requirement to be able to present your data as it was at any historical point in time there is a great data model and methodology called data vault which is designed to do just that.
See here:
http://en.wikipedia.org/wiki/Data_Vault_Modeling http://learndatavault.com/
Regards,
Fergal
On 13 February 2014 20:40, Dennis Williams <oracledba.williams_at_gmail.com>wrote:
> Paresh,
>
> There is something magical that enables many businesses to meet the 7 year
> data retention. Two pieces of magic. The first is the magic of decreasing
> storage costs. Second, the magic of database indexes. From what I've seen,
> most businesses just never delete old data from their production database.
>
> Now, if you retire a database, and are required to maintain access, then
> you have some of the issues discussed here - obsolete hardware, obsolete
> database versions, etc. You may keep the database offline, but bring it
> back up, upgrade the Oracle version, back it up, then take it offline.
>
> The original poster on this discussion described something even more
> daunting -- the requirement to recover the database to a point at any time
> over those years. That is very challenging. Probably a manager who doesn't
> understand what would be required technically. Perhaps if presented with
> the requirement to hire two more DBAs to meet that requirement, common
> sense may prevail.
>
> Dennis
>
>
>
>>
>
-- Fergal Taheny Pentec IT Limited 2 knightsbrook court, Dublin Road, Trim, Co. Meath. +353 (0) 87 9823137 ftaheny_at_gmail.com This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify us immediately. It is possible for data transmitted by email to be deliberately or accidentally corrupted or intercepted. For this reason, where the communication is by email, Pentec IT does not accept any responsibility for any breach of confidence which may arise through the use of this medium. Pentec IT Limited is Registered in Ireland: No 443280 with a registered office at 2 Knightsbrook Court, Dublin Road, Trim, Co. Meath. Company Directors: Fergal Taheny, Caitriona Ni Riain. -- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 13 2014 - 22:09:49 CET