RE: Long-Term Archiving
- From: "Stauffer, Robert G" <rstauffer@xxxxxxxxxxxxxxxxxxxx>
- To: <uwe@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Dec 2008 08:36:52 -0500
Uwe,
Assuming you'll be using Oracle in ten years and Oracle keeps its promise,
export is probably a good bet. But here's an interesting, "simple"
alternative. At regular intervals, extract the app and dictionary table data
to text files, extract the code to text files, keep a printed data model, and
archive it all to disk, CD, DVD, etc. - some type of storage that has a good
chance of being around in ten years. This allows you to read the data and be
able to determine how the app handles it without actually having the app and
database running. And it would work for non-Oracle databases and apps. It's a
simple concept, but not a new one. And no, we haven't implemented it. We've
been using export - for now.
Bob Stauffer
DBA
D&E Communications
Ephrata, PA
rstauffer@xxxxxxxxxxxxxxxxxxxx
717-738-8737
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Uwe Küchler
Sent: Tuesday, December 09, 2008 16:25
To: oracle-l@xxxxxxxxxxxxx
Subject: Long-Term Archiving
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/
--
//www.freelists.org/webpage/oracle-l
**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use
of the individual or entity to which they are addressed and may contain
information that is privileged, proprietary and confidential. If you are not
the intended recipient, you may not use, copy or disclose to anyone the message
or any information contained in the message. If you have received this
communication in error, please notify the sender and delete this e-mail
message. The contents do not represent the opinion of D&E except to the extent
that it relates to their official business.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
