| Is there any kind of "Transparent Data Archival" in Oracle [message #469716] |
Thu, 05 August 2010 11:29  |
orauser1
Messages: 5
Registered: August 2010
|
Junior Member |
|
|
Hi
we are running a larger OLTP application and would like to archive some of the older data transparently. What I mean by this is that it would be nice if data that is older than say 5 years would go to a kind of archive data store. Thereby queries on the OLTP system should still be able to transparently access this data while querying the original tables.
There is a new 11g feature called 'Flashback Data Archive' which goes into this direction but it archives all updates and deletes (to allow to reconstruct the data as of any point in time), which is not quite what we need.
Do you know of any other feature or solution that might help to achieve this 'transparent data archival'?
Regards orauser1
|
|
|
|
|
|
| Re: Is there any kind of "Transparent Data Archival" in Oracle [message #469779 is a reply to message #469729] |
Thu, 05 August 2010 15:23  |
orauser1
Messages: 5
Registered: August 2010
|
Junior Member |
|
|
Hi Michel
Thanks for the quick reply. FDA can be used to reconstruct transparently how the data looked at a given point in time (e.g. before something got deleted), right.
We do not need this 'point in time' feature. We just would like to offload the current OLTP application from old data that is seldom (but still sometimes) used. In such seldom cases the data should be available transparently, that is the existing queries should not have to be adapted (some performance degradataion would be acceptable for these infrequent queries). Does this help?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Is there any kind of "Transparent Data Archival" in Oracle [message #470108 is a reply to message #469965] |
Sun, 08 August 2010 11:40 |
orauser1
Messages: 5
Registered: August 2010
|
Junior Member |
|
|
Hi Michel
sorry for struggling trying to explain what we want: having the situation that the OLTP database grew considerably makes handling (e.g. exports, etc) and costs suboptimal. So it would be great if we could reduce the actual data size and move the seldom used data (old data) onto a cheaper place (e.g. by using compression, cheaper storage, whatever). Note that the old data should be still transparently available so that queries that involve old data still return the old data (if it takes more time then this would be ok). Does this help?
|
|
|
|
| Re: Is there any kind of "Transparent Data Archival" in Oracle [message #470109 is a reply to message #470108] |
Sun, 08 August 2010 11:49 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Michel Cadot wrote on Thu, 05 August 2010 22:27Use partitioning for this and archive partitions that are seldomly needed on cheaper device (I think this is the purpose otherwise why not keeping them in their current place).
Does this not answer the question?
"Archive" here means "move".
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
