Manage Learn to apply best practices and optimize your operations.

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

The resulting files can then be written to DVD or some other media for long term storage.

Dig Deeper on Oracle database administration