Re: Oracle db file & redo archive file relocate question

Hi,

   You can actually use three different methods to do the job; imp/exp,    recreating controlfiles or renaming the database files

   Try this is testing environment first. But I am pretty confident it will work.  

   Steps...

1. Copy down all the names and locations of datafiles, log files and control files using dba_data_files and v$logfile respectively.

      eg. select * 
          from dba_data_files;

   2. shutdown immediate.

   3. startup mount.

   4. copy all database files ie. all datafiles, log files and control files

      from old location to new location.

   5. Rename the datafiles in this way :

       
      eg. alter database rename file '/blah/old/system01.dbf' to
                                     '/blah/new/system01.dbf';

      Repeat for all database files at step 1. (The best is spool out 
      in step 1 and modify the output and run it as a script)

   6. shutdown immediate.

   7. move the controlfiles to new location.

   8. Change the location of your init.ora to point to have the right path

      for controlfiles, else the startup will gives error.

   9. startup    

1. You are done

Allan W. Tham
DBA Received on Fri Sep 07 2001 - 01:49:15 CDT