Re: Long-Term Archiving
Date: Wed, 10 Dec 2008 09:16:27 -0800
Some of you may be interested in reading this:
*Though it could be organized better, there's some interesting info on the problems associated with archiving data in a manner that ensures it will be useful later.
One example: assuming that a backup tape will still be good 10 years from now is pretty risky
Certifiable Oracle DBA and Part Time Perl Evangelist
On Tue, Dec 9, 2008 at 1:25 PM, Uwe Küchler <uwe_at_kuechler.org> wrote:
> Hello fellowship of the Oracle,
> due to not so recent changes in
> European and German law, many companies, particularly in the financial
> sector, have the need to archive critical data over a long period, like 6
> to 10 years.
> BUT - simply using RMan or Export doesn't always suit
> the requirement to be able to restore data after several years.
> think about an RMan Backup of a 9i DB that you need to restore in 10 years
> - we're probably at Oracle 16 or whatever, then and you probably won't be
> able to restore your old data to this new version. Keeping a copy of the
> old Oracle binaries is not the best option, either; maybe you won't have
> the appropriate OS version or hardware handy, then.
> So I'd like
> to ask the community what kind of solutions you recommend to your
> customers / managers, when they ask you: "How can we retrieve our
> data after 10 years if there is a tax audit?"
> I've heard,
> but haven't found a reliable pointer yet, that Oracle will support
> backward compatibility of the export dump format throughout the next
> versions. In this case, a regular snapshot of data by exporting it might
> be an idea. What are your thoughts on that?
> Best regards from