RE: Long-Term Archiving
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <uwe@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 9 Dec 2008 16:35:32 -0500
Uwe,
Well to date Oracle is keeping their word on backwards compatibility.
I know that exports taken in V6.0.36 will successfully import into 10.2.0.3,
but how long that will remain true is anyone's guess. There are a number of
vendors who provide long term archival of data via their own proprietary ways
and guarantee data retrieval back at least 10 years. Take a look at
http://www.applimation.com as an example. A simple Google search for "Oracle
data archiving" gets quite a bit back. Come to think of it, I think our good
friend Quest has a product too.
Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
information transmitted in this communication is intended only for the person
or entity to which it is addressed and may contain confidential and/or
privileged material. Any review, retransmission, dissemination or other use of,
or taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received this
in error, please destroy any copies, contact the sender and delete the material
from any computer.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Uwe Küchler
Sent: Tuesday, December 09, 2008 4:25 PM
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
