Re: Copying a Database

backup the control file to trace
shutdown immediate
rm the old control files
startup nomount
edit 'use' -> 'set' in the create control file sql create the new control file

• done deal

datafile names have nothing to do with database names instance names are only controlled in the init.ora

Cheers,

Brian Murphy

tvaresh <tvaresh_at_ix.netcom.com> wrote in article <01bc298e$20e7faa0$2a9f20cc_at_sdm>...
>
>
> 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 Tue Mar 11 1997 - 00:00:00 CST