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_at_crowley.com
x72546
904 727-2546

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of genegurevich_at_discover.com
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 Received on Mon May 19 2008 - 14:19:07 CDT