Re: Move Oracle database from old hard disk to new hard disk

Since almost 90% of the stuff posted should be available on the Oracle Documentation, I guess we can just use this as a standard answer 90% of the time.

Anyway, here is a bit more info to recreate another database on another server (different database name, database-creation-time parameters etc)

1. In the original database, issue a command to generate a trace:

       alter database backup controlfile to trace

    This will generate a trace file under your udump directory (Hope you don't ask where

    it is, otherwise, you will get more stern remarks from our fearsome DBAs).

2. Edit the trace to your own taste for the new target environment.

3. Shutdown your original database and copy it to the new target. Remember to delete the old control files. You can change location etc. Since you can change the name of a datafile anytime, I don't know if this is a good time to rename them. Maybe I will try next time.

4. Recreate your control files on the target environment using the file you edited on (2).

Quite a few details are left out, but this is one way to refresh a database. Hope this helps. Received on Tue Jul 25 2006 - 12:39:35 CDT