Re: database decommission checklist

I fully agree with the previous two postings of: 1) making a full backup to disk and to tape 2) shutdown the database but leave everything intact for a few months until you, as the DBA, are fully convinced that this database is absolutely not needed anymore

And I may add the following:

Use $ORACLE_HOME/bin/dbca to delete the database in question. This will ensure that all references to this database are gone from the system just in case you do need to create another database in the future and happen to choose the same SID for it - you know it will happen.

dave wrote:
> I always take a full backup and make sure its on tape before I
> physically delete the database.. Even if the users say its not
> required cause its happened before that a week later someone needed
> some data.
>
>
>
> Does anyone have any suggestions for decommissioning a large
> database? There is no requirement to save the data so all I can
> think of is
> 1) Shutdown
> 2) Erase
>
> Doesn't have a lot of pizazz - any other ideas?
>
>
>

-- 

*****************************************
Julio Aguilar-Chang
Geophysics Group, EES-17
Los Alamos National Laboratory

jachang_at_lanl.gov
(505) 667-1004 - work
(505) 665-3687 - fax
*****************************************


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