Re: Copying a Database

tvaresh wrote:
>
> 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

More questions :

1. Can u rename those datafiles?
2. How do you open with resetlogs?

Thanks for any help

John Received on Tue Mar 18 1997 - 00:00:00 CST