How to archive and decommission a database
An Oracle user asks the best way to archive and decommision a 5GB Oracle 7.3 Database.
What would be the best way to archive and decommission a 5GB Oracle 7.3 Database? This data needs to be available for at least 20 years from now in case a regulatory agency requires it, and we are afraid that in the future we won't be able to recover it to a newer version of Oracle.
I use Oracle's export utility for this type of task. Your database isn't too large, so exp will work. The nice thing about exp is that future versions of Oracle will still be able to read the resulting dump file. So perform the following:
exp userid=system/manager file=my_db.dmp log=my_db.log full=y
Continue Reading This Article
Enjoy this article as well as all of our content, including E-Guides, news, tips and more.
Step 2 of 2:
The resulting files can then be written to DVD or some other media for long term storage.
