Not so hard
This is done lots of times when creating/refreshing the database on a
new box. Usually the file names now reference different directories
also which you can also remedy by changing the names in the trace
controlfile.
A very brief outline of steps... i.e. doesn't show how to create a trace
controlfile
Take your backup controlfile to trace, edit it.
Change the line that begins:
CREATE CONTROLFILE REUSE DATABASE "OLD" NORESETLOGS ARCHIVELOG
To:
CREATE CONTROLFILE SET DATABASE "NEW" RESETLOGS ARCHIVELOG
Edit init.ora file, change all references from old to new
Connect as sysdba
Startup nomount
Create controlfile... execute the trace you edited... @trace
Recover database using backup controlfile until cancel, or auto.
Alter database open resetlogs
Rename your global name... i.e. select * from global_name;
alter database rename global_name to "" (syntax could be off)
change tnsnames.ora
-----Original Message-----
From: Kerber Andrew
[mailto:oracledba-ezmlmshield-x56337572.[Email address protected]
Sent: Wednesday, March 30, 2005 8:22 AM
To: LazyDBA Discussion
Subject: RE: dbname
Generally it is not a good idea to change database names, because it is
very confusing to other users, and can mess up your software. Also, I
believe you have to open the database with resetlogs rename it, and will
thus lose your old backups unless you are on 10g.
-----Original Message-----
From: Michael Porter
[mailto:oracledba-ezmlmshield-x40590617.[Email address protected]
Sent: Wednesday, March 30, 2005 07:05
To: LazyDBA Discussion
Subject: Re: dbname
Your statement is wrong and confusing people on this list "... you
should not change the db name after database creation mena say first db
name was DHW and after creation your changing to some thing like DBDHW
then it wont work database will not start"...
That is totally false. There is NO reason you cannot change the
database name as much as you want. You need to understand the
implications to any apps or software that might access it but.. Oracle
could care less how often you rename. I do it nearly daily for test
purposes and have done so since the beginning of Oracle. Please get
your facts straight before making such statements.
M
>>> "Rahul " <oracledba-ezmlmshield-x69557142.[Email address protected]
03/29/05 11:19 PM >>>
hi there,
yes!!! you can change the db name in any case after
creating
the database
but you should not change the db name after database creation mena say
first
db name was DHW and after creation your changing to some thing like
DBDHW
then it wont work database will not start
and if you want to do these thing then you need to create controlfile
by
create controlfile command
................
Regards
Rahul Chaudhari
----- Original Message -----
From: "Sajid Iqbal "
<oracledba-ezmlmshield-x33938750.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Thursday, March 24, 2005 3:10 PM
Subject: dbname
>
> Are the Instance_name and db_name parameters in the init file
case
> sensitive ?
>
> Can I change them to be lower case ? without it affecting anything ?
>
> Regards
>
> Sa
>
>
************************************************************************
****
****
> This e-mail and any files transmitted with it are confidential and
intended
> soley for the use of the individual to whom it is addressed. Any
views
or
> opinions presented are soley those of the author and do not
necessarily
> represent those of City College Manchester.
>
> If you are not the intended recipient, please be advised that you
have
> received this e-mail in error and that any use, dissemination,
forwarding,
> printing, or copying of this e-mail is stricty prohibited.
>
>
************************************************************************
****
****
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page