Re: Long-Term Archiving

Some of you may be interested in reading this:

*http://tinyurl.com/6352uy

*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

Jared Still
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.
> Just
> 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
> Germany,
> Uwe
>
> --
>
> http://oraculix.wordpress.com/
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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