hi , Lawrence Simela ! Thank your answer again
The same to you as Paul . I have in nomout state. well then what do
you think about the matter ?
"Lawrence Simela" <lsimela_at_mahalini.prestel.co.uk> wrote in message news:<9p24s7$h3j$1_at_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 - 20:19:58 CDT
