RE: rename a database

Yes, Keep a lookout for your tempfiles.

RMAN however, is the new paradigm... you can duplicate to new name, or
restore to same name on new server, but cannot 'duplicate' to same name
on same server, (because it requires the source database to be up).  To
same name on same server is a little easier the old fashioned way, (user
written backups).   (but then again... how much of a hindrance is that)?

Other combos are beyond scope.

Joel Patterson
Database Administrator
joel.patterson@xxxxxxxxxxx
x72546
904  727-2546

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
genegurevich@xxxxxxxxxxxx
Sent: Monday, May 19, 2008 2:57 PM
To: oracle-l
Subject: rename a database

Hello :


I need to rename an existing database (10.2.3). In the past (about 10
years
ago and oracle 7) I was able to take the create controlfile command
(via alter database rebuild controlfile to trace), replace the
filesystem
name and the database name with a new instance name, rename
all the filesystems accordingly, execute the create controlfile command
and
be done.

As I said I have not done it in about 10 years. Can this still be done
like
that? Am I missing anything?

thank you

Gene Gurevich


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l


Other related posts: