Re: Copying an Oracle Database

From: <kvsraju_at_my-dejanews.com>
Date: Sat, 06 Feb 1999 06:11:52 GMT
Message-ID: <79gmf5$9rv$1@nnrp1.dejanews.com>

In article <79ap53$adt$1_at_nnrp1.dejanews.com>, bongbaroma_at_aol.com wrote:
> In article <36b5f635.3770500_at_192.168.10.43>,
> reycraft_at_hillmar.com (Kirby Reycraft) wrote:
> > Is there an easy way to simply copy an existing database and give it
> > a new name?
> >
> > TIA
> >
> > Kirby
> >
>
> You need to recreate your controlfile using a new database name. First, you
> need to run "alter database backup controlfile to trace". Then edit the
> output trace file by changing the name of the database.
>

Hi,
This is k.v.s.raju
There is no specific command to change the database name. The reason is ,The name of the database will be stored in different parts of database viz.controfile ,parameter file (INIT.ORA) ,datafile header,logfile header,archived logfile headers and data dictionary . Simply changing database name cann't change all over. For this there is specific procedure to follow.

1.Take backup of the controlfile .(only by tracing it).
2.shutdown the database.
3.edit paramter file and set  db_name=<new name>
4.Go to Nomount state.
5.Modify the traced script of controlfile with
       RESETLOGS

SET DATABASE <NEW NAME>
6.Create controlfile using the traced script. 7 open the database ALTER DATABASE OPEN RESETLOGS.

This method will change the database name in the datafile headers,logfile headers and in controlfile.
remember after u change the database name and open the database old backup won't be useful.So,immediately take a cold backup of the database.

Hope this clarifies u
rgds
K.V.S.RAJU
ORACLE DATABASE ADMINISTRATOR,
INDIA.
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Feb 06 1999 - 00:11:52 CST