If you are runing Oracle apps it is a little bit more involved. see the
Rapid Clone instructions from Metalink.
We clone regularly to get test instances that are copies of production. I
did have a consultant say that it was better to have production be a native
install rather than a clone since you "can't be sure" everything that needs
to be changed is. Again, this is wrt apps. There is a lot of instance
relatated information stored in the database tables that must also be
changed.
| Henry A.L. Wollman Rejoice and be glad!
|_____________________________________________________
| Moody Bible Institute, Database Administrator, [Email address protected]
| 820 N. LaSalle Blvd, Chicago, IL 60610 312-329-2291
|_____________________________________________________
-----Original Message-----
From: Poole David
[mailto:oracledba-ezmlmshield-x47954100.[Email address protected]
Sent: Wednesday, March 30, 2005 11:55 AM
To: LazyDBA Discussion
Subject: RE: dbname
Thanks for everyones input re changing database names. I for one was one of
those who for some reason mistakenly believed that it was a bad idea and
difficult to change a database name. I cannot remember where for sure I
picked this belief up but it is one I have held for a few years. I can only
point this out to have been picked up on a course years ago as I certainly
wouldn't make something up I didn't know for sure. Can anyone else who may
have contributed to this thread or not pinpoint when and where they picked
up there belief that renaming databases was bad. I can swear on it I heard
it on a course but cannot be sure as it was years ago. :/
-----Original Message-----
From: Patterson Joel
[mailto:oracledba-ezmlmshield-x33340087.[Email address protected]
Sent: 30 March 2005 15:06
To: LazyDBA Discussion
Subject: RE: dbname
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
--------
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