Long Term Storage ideas for Data in an Oracle Database
walls99Mar 23 2012 — edited Mar 27 2012We have data that we no longer need access to and want to archive it on tapes for long term storage.
We want to save the data using datapump or rman from time to time and and store the exports/backups on tapes. The issue we don't want to face in the future is , if Oracle deprecates the methodology we used to save the data in 2012, we no longer have a way to retrieve the data into a database 10 years from now.
This may sound crazy, but hear me out. Before datapump existed everyone was using vanilla exp to export the data. Now we have datapump as exp's upgrade and we have rman too. What if in 2012 we took an export using datapump or a backup using rman and save it off on a tape. 10 years go by and in 2022 management wants to look at the 2012 data. Lets say by this time Oracle's mothodology changes and they have a much more efficient/robust export/backup method. One way for us to keep the old backups up to date is to import the data back before the method we used in 2012 is deprecated and then export/backup the data using the new method to keep the exports/tapes in sync with then current technology.
My question is, what methods of saving large amounts of data do you recommend/use to save data to a tape so that you don't have to worry about changing times.
An idea I heard is to save the data as insert statements. This would work for most of the data except for blobs.
Any help would be appreciated.
Thanks in advance.