you need to execute the script in a nomount state.
lanas wrote:
>
> 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 - 23:30:09 CDT
