RE: database decommission checklist

We recently decommissioned a 8.1.7.0 database. In addition to all excellent suggestions by others, we also:

• Checked jobs inside and particularly outside the database, cron jobs on the server itself and jobs on the application server. Made sure there's no access to the file system or to the network from inside the database that needs to be taken care of.
• Dumped the database and imported into a 10.2.0.4 database (we no longer have 8i) and have one power user use the application connect to it. In the process, we found the import went into a WE8ISO8859P1 character set database fine, but not one using AL32UTF8 (unless we would spend time doing some conversion). In the next few months, this temporary "database" will be used by the power user for lookup only. So the relevant tablespaces are made read only.
• Gzipped the dump file. The primary schema uses CHAR extensively. The compression ratio is over 10 times (40G to 360M).

Yong Huang       

--
http://www.freelists.org/webpage/oracle-l