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
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.
Dig Deeper on Oracle database administration
-
![]()
Migrate an Oracle RAC database to new servers with zero downtime
By: Brian Peasland
-
![]()
Understanding rollback in Oracle following SHUTDOWN IMMEDIATE
By: Brian Peasland
-
![]()
How to perform Oracle database recovery with a corrupt online redo log
By: Brian Peasland
-
![]()
Oracle error 6550 may mean incorrect Oracle export version
By: Brian Peasland
