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

From: lanas <lanas_at_263.net>
Date: 27 Sep 2001 18:28:02 -0700
Message-ID: <5abaade9.0109271728.61d42e0@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 Thu Sep 27 2001 - 20:28:02 CDT