Re: Copying a Database

KWIATKOWSKI LARRY <KWIATKOWSKIL_at_SICDES.DNET.ETN.COM> wrote in article <3316F914.44D1_at_SICDES.DNET.ETN.COM>...
> I want to rename a database and instance from EDUC to DEVL. Is this the
> correct procedure:
>
> 1. start the database in mount mode
> 2. rename the datafiles "/id01/EDUC/control01" "/id01/DEVL/control01"
> (rename all datafiles to the new DEVl name)
> 3. stop the instance.
> 4. change oratab from EDUC to DEVL.
> 4. copy the ofa compliant directories EDUC to DEVL.
> 5. edit the init.ora files to reflect the new controlfilenames.
> 6. start the new instance.
>
>
>
> any input will be appreciated
>

What I've done in the past to rename a database is this:

  svrmgrl
  connect internal
  alter database backup controlfile to trace   exit to command line
  cd to the trace directory and list the latest trace file there. It should contain a "script" for recreating the control files. You can modify that script to change the path of the datafile as well as the database name (using the "set" parameter on the create controlfile line). Shutdown your database, reconfigure it (i.e. move the datafiles, etc.), then start the modified trace file from svrmgrl. That will rename the database. A word of caution - you'll have to open with resetlogs, so before and after backups are HIGHLY advised. Please feel free to email me if you have any other questions - you can use my professional address - smiller_at_gers.com. Good luck!

Steve Received on Wed Mar 05 1997 - 00:00:00 CST