Re: Can I change db_name or SID for a exist db or How?

From: Lawrence Simela <lsimela_at_mahalini.prestel.co.uk>
Date: Fri, 28 Sep 2001 16:32:00 +0100
Message-ID: <9p24s7$h3j$1@phys-ma.sol.co.uk>

Yup as Paul says.. Run script in nomount. The STARTUP NOMOUNT instruction should already be in the script. Sorry I should have made it clearer.. it was off the top of my head!

hth
Lawrence

"lanas" <lanas_at_263.net> wrote in message news:5abaade9.0109271728.61d42e0_at_posting.google.com...
> Thank first!
> but fellow , There is a trouble when I went to 6th step that you
> told me
> --6:Run the file created in 1 and edited in 4
> >CREATE CONTROLFILE REUSE DATABASE "MASTER" NORESETLOGS NOARCHIVELOG
> --before change , the db_name is "web"
> MAXLOGFILES 32
> MAXLOGMEMBERS 2
> MAXDATAFILES 254
> MAXINSTANCES 8
> MAXLOGHISTORY 1815
> LOGFILE
> GROUP 1 '/home/oracle/OraHome1/oradata/web/redo01.log' SIZE 500K,
> GROUP 2 '/home/oracle/OraHome1/oradata/web/redo02.log' SIZE 500K,
> GROUP 3 '/home/oracle/OraHome1/oradata/web/redo03.log' SIZE 500K
> DATAFILE
> '/home/oracle/OraHome1/oradata/web/system01.dbf',
> '/home/oracle/OraHome1/oradata/web/tools01.dbf',
> '/home/oracle/OraHome1/oradata/web/rbs01.dbf',
> '/home/oracle/OraHome1/oradata/web/temp01.dbf',
> '/home/oracle/OraHome1/oradata/web/users01.dbf',
> '/home/oracle/OraHome1/oradata/web/indx01.dbf',
> '/home/oracle/OraHome1/oradata/web/oem_repository.dbf',
> '/home/oracle/OraHome1/oradata/web/SNAPSHOT.dbf',
> '/home/oracle/OraHome1/oradata/web/SNAPLOG.dbf',
> '/home/oracle/OraHome1/oradata/web/LANAS.dbf'
> CHARACTER SET ZHS16GBK

>

> and as soon as it show me some funny message:
> "REATE CONTROLFILE REUSE DATABASE "MASTER" NORESETLOGS NOARCHIVELOG
> *
> ORA-01503: CREATE CONTROLFILE failed
> ORA-01161: database name WEB in file header does not match given name
> of MASTER
> ORA-01110: data file 1:
> '/home/oracle/OraHome1/oradata/web/system01.dbf'"
> oh! god .It seems that controlfile not only catch the db_name ,but
> also datafiles have remembered db_name.

>

> any way , Who can help me dealing datafiles ?
> maybe you , Thank much.

>

> I regret it will bother you.

>
>


> ==================

>
>
>

> "Lawrence Simela" <lsimela_at_mahalini.prestel.co.uk> wrote in message
news:<9ou38t$740$2_at_phys-ma.sol.co.uk>...
> > Yes you can change the Db name of an existing database.
> > This topic has been covered on this newsgroup in the past so you may
want to
> > look at the archives as well. But a brief guide is as follows:
> >
> > 1. Issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement
> > This will create in your udump directory a file with all the commands to
> > recreate the control file.
> > 2. Backup your existing control file including the mirrored version.
> > 3. Shutdown database and remove existing control files
> > 4. Edit the file created in 1 to change the database name
> > 5. edit the init.ora file to change the SID and db_name as appropriate
> > 6. Run the file created in 1 and edited in 4
> > 7. Issue a statement to change the global name of the database as
follows
> > ALER DAtABASE RENAME GLOBAL_NAME TO new_db_name.domain;
> >
> > And you are done.
> >
> > Lawrence
> >
> >
> > "lanas" <lanas_at_263.net> wrote in message
> > news:5abaade9.0109261706.33c91ea1_at_posting.google.com...
> > > thanx all
Received on Fri Sep 28 2001 - 10:32:00 CDT